Password protection of Excel file

rshahrabani9e8a7 · March 2, 2017, 3:12pm

Hi,

We are currently evaluating the Aspose.Cells product for .NET and would like to test the following functionality:

1) Password protect an entire Excel file (.xls or .xlsx) such that it cannot be opened for viewing or editing unless the user enters the correct password.

2) Merging 2 or more Excel files into a single file with multiple sheets (one sheet for each merged file).

Your assistance with this is greatly appreciated.

Ronny Shahrabani

rshahrabani@shahrabani.com

babar.raza · March 2, 2017, 10:35pm

Hi Ronny,

Thank you for contacting Aspose support.

Please check the article on protecting spreadsheets with Aspose.Cells for .NET APIs.
In order to combine multiple spreadsheets in a single file, please use the Workbook.Combine method. Please check the code snippet shared in your other thread for demonstration.