开发者

How to decrypt excel file 2007 by POI 3.8 if it is protected by "Restrict Editing"

开发者 https://www.devze.com 2023-04-07 15:19 出处:网络
In excel 2007, we can Protect Workbook by select \"Protect Workbook\" on menu and select \"Protect Structures and Windows\".

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

  1. Create a Excel Object
  2. Open workbook
  3. Unprotect with password ActiveWorkbook.Unprotect
  4. Save file
  5. Open in POI
  6. Remake steps 1 to 4, but protect file

[]'s

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号