You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Kommineni, Sateesh (GE Consumer & Industrial)" <sa...@ge.com> on 2004/02/02 14:04:30 UTC

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

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:

  . bin=java.io.BufferedInputStream@1118aa5
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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

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

Posted by Andrew Kharchuk <ak...@ukraina.com>.
Hi.

I think  your problem is the following - you have wrong file path  when you
create object using  new FileInputStream(path+FILE_NAME)

----- Original Message ----- 
From: "Kommineni, Sateesh (GE Consumer & Industrial)"
<sa...@ge.com>
To: <po...@jakarta.apache.org>
Sent: Monday, February 02, 2004 3:04 PM
Subject: org.apache.poi.hssf.record.RecordFormatException in Reading/Writing
to an Excel File..


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:

  . bin=java.io.BufferedInputStream@1118aa5
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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org