开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜