In excel 2007, we can Protect Workbook by select "Protect Workbook" on menu and select "Protect Structures and Windows".
I have file with extension "开发者_JAVA百科.xlsm" and it is protected like the way above. I have password of this file and I need to read it by POI 3.8 in java, how can I do that?
I used to use the class "Decryptor" to verify the password, but it useless. Please help me, I have stucked in this for 3 days...
You can make this
- Create a Excel Object
- Open workbook
- Unprotect with password ActiveWorkbook.Unprotect
- Save file
- Open in POI
- Remake steps 1 to 4, but protect file
[]'s
精彩评论