file Writing problem

[Ravikanth thota]

hi everyone,

i am working with Excel workbook using apache POI API.After writing the data into the workbook the size of the file is reducing and the file is getting corrupted it has shown an error like:

"Excel Found Unreadable Content in FILENAME.xlsx. do you want to recover the content of this workbook?If you trust the source of this workbook click yes! "

i am attaching my code

import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class TempleteOverride
{
	public static void main(String[] args) throws Exception
	{
		String filename = "E:\\xls\\test.xlsx";
		FileInputStream fis = null;
		try 
		{
			fis = new FileInputStream(filename);
			XSSFWorkbook workbook = new XSSFWorkbook(fis);
			XSSFSheet sheet = workbook.getSheetAt(0);
			XSSFRow row = sheet.getRow(0);
			XSSFCell cell = row.getCell(1);
			double s = cell.getNumericCellValue();
			cell.setCellValue(199);
			FileOutputStream fileOut = new FileOutputStream(filename);	
			workbook.write(fileOut);
			fileOut.close();
			System.out.println("cell overrided");
			fis.close();
		} 
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
}

please help me in finding the error..!!!

[Sudhir Ravindra]

Looks like you are trying to add content to an existing work book. Which version of excel was this sheet created in.
Try creating a new workbook as described in http://poi.apache.org/spreadsheet/quick-guide.html#CreateCells and see if you can reproduce the issue.

[Ravikanth thota]

Sudhir Ravindra wrote:Looks like you are trying to add content to an existing work book. Which version of excel was this sheet created in.
Try creating a new workbook as described in http://poi.apache.org/spreadsheet/quick-guide.html#CreateCells and see if you can reproduce the issue.

i am using Microsoft 2010 excel. my code is working fine with .xls files(till Microsoft 2007). but for .xlsx files, after writing into excel, if we try to open excel it is showing error as i mentioned above..

[Ishmeet Kaur]

Hey, were you able to solve this issue?

I am having the same problem when I try to create an Excel sheet using Apache POI.

[Tony Docherty]

Not sure if this will help but I've always used the WorkBookFactory to create the WorkBook ie:

Workbook myWorkBook = WorkbookFactory.create(new FileInputStream("MyExcel.xlsx"));

If this doesn't help can you show the code you are using.