RE: org.apache.poi.hssf.record.RecordFormatException in Reading/Writing to an Excel File..

[Kommineni, Sateesh \(GE Consumer & Industrial\)]

Hi All,

     I found out the reason why i got the RecordFormatException . The Sheet in which i 
am trying to write was protected . (I didn't check the format of the Excel file we 
have in Solaris ,in which the Sheet we are trying to write is Protected !!).

     Thanks a lot to all you guys for the inputs you provided..

-Sateesh


-----Original Message-----
From: Kommineni, Sateesh (GE Consumer & Industrial) 
Sent: Tuesday, February 03, 2004 4:10 PM
To: POI Users List
Subject: RE: org.apache.poi.hssf.record.RecordFormatException in
Reading/Writing to an Excel File..


Hi ALL,

    I am using poi-2.0-RC2-20040102.zip and don't know whether 
org.apache.poi.hssf.record.RecordFormatException is a Bug in POI or not.

    Is it the case that i need to wait till some one finds a solution for this If it 
is a bug ..

    Any way thanks a lot for all the support..

-Sateesh


-----Original Message-----
From: Kommineni, Sateesh (GE Consumer & Industrial) 
Sent: Monday, February 02, 2004 6:35 PM
To: [EMAIL PROTECTED]
Subject: org.apache.poi.hssf.record.RecordFormatException in
Reading/Writing to an Excel File..
Importance: High


Hi,

    I am try to read an Excel File and then writing to it. It is working well in 
Windows and giving problems in Solaris. The Exception it is giving is:

  . [EMAIL PROTECTED]
415. Excep in generating the 
WorkBook=org.apache.poi.hssf.record.RecordFormatException: Unable to construct record 
instance, the following exception occured: null
416. RecordFormatExcep in 
createWorkBook=org.apache.poi.hssf.record.RecordFormatException: Unable to construct 
record instance, the following exception occured: null
417. Work Book=null

  The Code i am using is given below:

                                try{
                                        bin  = new BufferedInputStream(new 
FileInputStream(path+FILE_NAME));
                                        System.out.println("bin="+bin);
                                wb   = new HSSFWorkbook(bin,false);
                                }
                                catch(Exception ioe){
                                   System.out.println("Excep in generating the 
WorkBook="+ioe);
                                   ioe.printStackTrace();
                                         try{  
                                                fs  = new POIFSFileSystem(new 
FileInputStream(path+FILE_NAME));
                                        wb = new HSSFWorkbook(fs);
                                 }
                                         catch(RecordFormatException rfe){
                                                System.out.println("RecordFormatExcep 
in createWorkBook="+rfe);
                                                rfe.printStackTrace();
                                         }
                                         catch(Exception e){
                                            System.out.println("Excep IS="+e);
                                            e.printStackTrace();
                                         }
                                }
                                finally{
                                   if(bin!=null) bin.close();
                                }
                                System.out.println("Work Book="+wb);


   Pls let me know what went wrong..

Thanks a lot
Sateesh


---------------------------------------------------------------------
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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]