You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/03/03 22:01:03 UTC
DO NOT REPLY [Bug 46796] New: I can not read excel password
protected workbook files
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
Summary: I can not read excel password protected workbook files
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: inge_jimenezvasquez@yahoo.com
I just need to read an excel password protected workbook file.
This excel file is password protected because no one can modify the structure
of it. I just need to read the contents of the specified sheet, i understand
that is not posible edit this excel file, but a person should be able to read
the contents of one or some sheets of this workbook.
When we tried to open a excel file that is password protected (workbook and
sheet) it throws a java.lang.reflect.InvocationTargetException, but when we
tried to open a excel file that is password protected (only sheet) it reads
succesfully.
I think that if we were to try to open an excel file that is password protected
(workbook and sheet) it should read the contents succesfully, but only for
reading the contents, not write it, i mean, without modifying the estructure of
the workbook.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #4 from David Jimenez Vasquez <in...@yahoo.com> 2009-03-03 14:23:34 PST ---
Created an attachment (id=23326)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23326)
Excel files reading using POI
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #6 from David Jimenez Vasquez <in...@yahoo.com> 2009-03-03 15:02:36 PST ---
I am going to try with Apache POI 3.2-FINAL and 3.5-beta5 to view the results.
Thanks in advance.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #3 from David Fisher <df...@jmlafferty.com> 2009-03-03 13:53:49 PST ---
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?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #5 from David Jimenez Vasquez <in...@yahoo.com> 2009-03-03 14:24:41 PST ---
I am using the Apache POI 2.5.1
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #1 from David Fisher <df...@jmlafferty.com> 2009-03-03 13:12:52 PST ---
When Excel tries to open your "Workbook" and "Sheet" protected file do you have
to supply the password in order to view the contents?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #2 from David Jimenez Vasquez <in...@yahoo.com> 2009-03-03 13:41:41 PST ---
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: DO NOT REPLY [Bug 46796] I can not read excel password
protected workbook files
Posted by MSB <ma...@tiscali.co.uk>.
Hello David,
As I am not a developer, I am speaking completely out of turn here. Having
said that, I do not think that it wil be at all straightforward - even if it
is possible - to add this feature. Workbooks that are protected in this
manner are actually encrypted. Not surprisingly, the encryption algorithm
that Microsoft use is not made public as far as I know; so you can imagine
the challenge this presents.
Bugzilla from bugzilla@apache.org wrote:
>
> https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
>
>
>
>
>
> --- Comment #8 from David Jimenez Vasquez <in...@yahoo.com>
> 2009-03-05 20:21:44 PST ---
> 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?
>
> --
> Configure bugmail:
> https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are the assignee for the bug.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/DO-NOT-REPLY--Bug-46796--New%3A-I-can-not-read-excel-password-protected-workbook-files-tp22317838p22367470.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #8 from David Jimenez Vasquez <in...@yahoo.com> 2009-03-05 20:21:44 PST ---
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?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WONTFIX
--- Comment #9 from Nick Burch <ni...@torchbox.com> 2009-03-16 10:05:16 PST ---
(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
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #10 from Maxim Valyanskiy <ma...@gmail.com> 2009-08-06 03:18:07 PDT ---
https://issues.apache.org/bugzilla/show_bug.cgi?id=47652
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46796] I can not read excel password protected
workbook files
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46796
--- Comment #7 from Josh Micich <jo...@gildedtree.com> 2009-03-03 15:31:17 PST ---
(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
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org