Hi Guilhaume. Possibly half a year ago (or a bit more) there was a similar question. I've in mind that you just can test it for protection but you can't read it.
It wouldn't be a protection if it could be read with other tools! Then as a user you would throw Excel into the litter box. Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Guilhaume Pinard-Legry [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 17. Juli 2004 16:31 An: [EMAIL PROTECTED] Betreff: Re: locked workbook Hi all I've seen that my message was not very clear: I need to get values from cells that are in a password-protected workbook. but I can't! as there several thousands of files, I will not unprotect them manually Here is the error I get: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedConstructorAccessor1.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons tructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java :224) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav a:160) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:165) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:132) at Test.main(Test.java:30) Caused by: java.lang.IllegalArgumentException: Illegal length at org.apache.poi.util.StringUtil.getFromUnicodeHigh(StringUtil.java:76) at org.apache.poi.hssf.record.FontRecord.fillFields(FontRecord.java:135) at org.apache.poi.hssf.record.Record.fillFields(Record.java:90) at org.apache.poi.hssf.record.Record.<init>(Record.java:55) at org.apache.poi.hssf.record.FontRecord.<init>(FontRecord.java:88) ... 8 more org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java :237) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav a:160) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:165) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:132) at Test.main(Test.java:30) Cr�ez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Cr�ez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/ Dialoguez en direct avec vos amis gr�ce � Yahoo! Messenger !T�l�chargez Yahoo! Messenger sur http://fr.messenger.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
