Hi
I am executing the following programme and The excel contains macros for drop down
public static void main(
String a[])
{
try
{
FileInputStream fis = new FileInputStream("D:/t/f/Headcoun.xls");
POIFSFileSystem pfs = new POIFSFileSystem(fis);
HSSFWorkbook book = new HSSFWorkbook(pfs,false);
} catch (FileNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
I am getting the exception as below
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:224)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)
at examples.ExcelTest.main(ExcelTest.java:76)
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
Exception in
thread "main" 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.java:160)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)
at examples.ExcelTest.main(ExcelTest.java:76)
Any one can help ?
Thanks,
Suneesh
