We have a client that used to send us a manually created excel file (3 sheets, 3 columns each) that I was able to read without any problems. However, after they automated their process creating this excel file using SQL Server 2000 DTS Package (Excel version 2000) I'm not able to read it. I've tried both poi-2.5.1-final-20040804.jar and poi-2.0-final-20040126.jar. Error thrown is "Unable to construct record instance, the following exception occured: null". I get the same error on Windows 2000 and Linux. Code that throws the error: HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(myFile));
I found that if I open this file on my workstation, resize a column and save it, then I'm able to read it. This makes me believe that there is something "special" about the sql server generated excel file but unfortunately I don't have access to a sql server install so I can't play around with it. Anyone know what's going on? Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
