Vikranth,
I tried and got a very nasty exception. My code reads as follows:
HSSFSheet sheet;
public POIWizardExcelParser(String fileName) throws IOException
{
FileInputStream fin;
POIFSFileSystem fs;
HSSFWorkbook wb;
try
{
fin = new FileInputStream(fileName);
}
catch (IOException io)
{
throw new IOException("Cannot open file: " +
fileName + "\n" + io.getMessage());
}
try
{
fs = new POIFSFileSystem(fin);
}
catch (Exception e)
{
throw new IOException("Cannot create a POIFS File
System.\n" + e.getMessage());
}
try
{
wb = new HSSFWorkbook(fs);
}
catch (Exception e)
{
throw new IOException("Cannot create a Workbook.\n"
+ e.getMessage());
}
sheet = wb.getSheetAt(0);
}
I get the following error when creating a new HSSFWorkbook:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:246
)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:18
4)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:140)
at
com.gs.eq.mot.gui.base.POIWizardExcelParser.<init>(POIWizardExcelParser.java
:49)
at
com.gs.eq.mot.gui.wizard.views.InputPanel.setWizardData(InputPanel.java:109)
at
com.gs.eq.mot.gui.wizard.controller.WizardController.forwardCommand(WizardCo
ntroller.java:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
com.gs.eq.mot.gui.base.GenericListener$1.invoke(GenericListener.java:56)
at $Proxy0.actionPerformed(Unknown Source)
at
com.gs.eq.mot.gui.base.JLFAbstractAction.actionPerformed(JLFAbstractAction.j
ava:99)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1817)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
19)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener
.java:245)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:227)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:227)
at java.awt.Component.processMouseEvent(Component.java:5093)
at java.awt.Component.processEvent(Component.java:4890)
at java.awt.Container.processEvent(Container.java:1566)
at java.awt.Component.dispatchEventImpl(Component.java:3598)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Component.dispatchEvent(Component.java:3439)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
at java.awt.Container.dispatchEventImpl(Container.java:1609)
at java.awt.Window.dispatchEventImpl(Window.java:1585)
at java.awt.Component.dispatchEvent(Component.java:3439)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:197)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:150)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)
Caused by: java.lang.IllegalArgumentException: Illegal length
at
org.apache.poi.util.StringUtil.getFromUnicode(StringUtil.java:107)
at
org.apache.poi.hssf.record.FontRecord.fillFields(FontRecord.java:172)
at org.apache.poi.hssf.record.Record.fillFields(Record.java:142)
at org.apache.poi.hssf.record.Record.<init>(Record.java:104)
at org.apache.poi.hssf.record.FontRecord.<init>(FontRecord.java:125)
I am curious how you got around it.
Oscar A. Ramirez
Goldman, Sachs & Co.
Voice: (212) 357-7402
Email: [EMAIL PROTECTED]
-----Original Message-----
From: Vikranth [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:49 AM
To: Ramirez, Oscar
Subject: Password-protected Excel Workbook
Hello Oscar,
You just forget that the excel file is password protected. You will still
be able to read and write to the excel file even if it is password
protected. I have tried it out ..
Regards,
Vikranth
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
