Aspose.cells read the protected password Excel file _ practical Tips

A recent need to be able to read password-protected Excel content is to read data directly in Excel without any other processing.

When Excel double click, need to enter a password, when using the Aspose.cells component to read the error

Workbook book = new Workbook (fullfilename, new Loadoptions () {password= "111111"});
      
Worksheet sheet = Book. Worksheets[0];
Cells Cells = sheet. Cells;

When building a Workbook object, there is a loadoptions parameter, which has a property password can be used to set and read the password, and the problem is perfectly resolved.

The above aspose.cells read the protected password Excel file is a small series to share all the content, hope to give you a reference, but also hope that we support cloud habitat community.