| Summary: | I can not read excel password protected workbook files | ||
|---|---|---|---|
| Product: | POI | Reporter: | David Jimenez Vasquez <inge_jimenezvasquez> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED WONTFIX | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
| Attachments: | Excel files reading using POI | ||
|
Description
David Jimenez Vasquez
2009-03-03 13:01:01 UTC
When Excel tries to open your "Workbook" and "Sheet" protected file do you have to supply the password in order to view the contents? No, i don't have to supply any password. I can view the contents without supplying the password. This is the situation, i have a JAVA program that uses the library Apache POI HSSF to read and write excel files, when the program tries to read a password protected file (only sheet), it reads succesfully, but when the program tries to read a password protected file (workbook and sheet), it throws a java.lang.reflect.InvocationTargetException. What version of POI are you using? If not the latest 3.5beta5 would you mind seeing if that makes a difference. Is it possible for you to attach a sample file that shows the trouble but does not contain any proprietary information? Created attachment 23326 [details]
Excel files reading using POI
I am using the Apache POI 2.5.1 I am going to try with Apache POI 3.2-FINAL and 3.5-beta5 to view the results. Thanks in advance. (In reply to comment #6) > I am going to try with Apache POI 3.2-FINAL and 3.5-beta5 to view the results. > > Thanks in advance. The latest POI version is not going to work either. This issue was first noticed in bug 27548 . The resolution at that point was to throw an explicit error when POI encountered an encrypted workbook. No progress has been made beyond this. It may take a lot of work to get POI to support encrypted workbooks As Josh Micich said, the latest POI version didn't work either. Despite of knowing it wouldn't work, i tried it anyway to view the results. I tried with the POI 3.2-FINAL and 3.5-beta5, both threw the same exception, org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance. I just have a reflexive question, no offense, but... Won't Apache POI have this feature? Will Apache POI always throw an exception whenever a JAVA program try to read the contents of a password protected workbook file? (In reply to comment #8) > I just have a reflexive question, no offense, but... Won't Apache POI have this > feature? The bulk of the office encryption stuff isn't standard, and isn't documented, so support it very unlikely to be forthcoming, unless someone volunteers to do a massive amount of reverse engineering |