Aspose. Cells reads protected Excel files with passwords, aspose. cellsexcel
Recently, I encountered a requirement that I should be able to read the password-protected Excel content. Previously, I directly read the data in the Excel file without any additional processing.
When you double-click an Excel file, you need to enter a password. When you use the Aspose. Cells component to read data, an error is reported.
Workbook book = new Workbook (fullFilename, new LoadOptions () {Password = "111111"}); Worksheet sheet = book. Worksheets [0]; Cells cells = sheet. Cells;
When building a Workbook object, there will be a LoadOptions parameter, where there is a property Password that can be used to set and read the Password, the problem is perfectly solved.
The above Aspose. Cells reads the protected Excel file, which is all the content shared by the editor. I hope it can be used as a reference for you, and I hope you can also provide more support for helping customers.