Recently, I encountered a requirement that in order to be able to read password-protected Excel content, I used to read data in Excel directly and did not require any other processing.
When Excel double-clicks, you need to enter a password, and an error will be reported when using the component to read it.
Workbook book = new Workbook(fullFilename, new LoadOptions() { Password="111111" });
Worksheet sheet = [0];
Cells cells = ;
When building a Workbook object, there will be a LoadOptions parameter, and there is a property Password that can be used to set and read passwords, and the problem will be solved perfectly.
The above article reading protected Excel files with passwords is all the content I share with you. I hope you can give you a reference and I hope you can support me more.