You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2004/10/17 00:24:19 UTC

DO NOT REPLY [Bug 31749] New: - Unable to open the written excel sheet.

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=31749>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=31749

Unable to open the written excel sheet.

           Summary: Unable to open the written excel sheet.
           Product: POI
           Version: 2.5
          Platform: Other
        OS/Version: Windows XP
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: ash_sha_21@yahoo.com


I am running into series of problems.
Here is the sample code which i m executing.

********
import java.io.*;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class TestPoi {
	
	public static void main(String[] args) throws Exception{
		
		HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream
(new File("c://test//uw.xls")),true);
		FileOutputStream fos = new FileOutputStream(new File
("c://test//uw_output.xls"));
		workbook.write(fos);
		fos.close();
	}

}
******************

The output file uw_output.xls is totally unusable as i am not able to open 
this file.
Here are series of steps which i performed.

1. When i executed this programe for the first time i got  warnings  like 
below one.

[WARNING] Unknown Ptg 3c (60) at cell (36,2)

Then i deleted all the rows having the junk characters and  i executed the 
programe again.This time it did not generate any warnings but the excel file 
which it created was unreadable.

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