Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

http://stackoverflow.com/questions/8840672/poi-sxssfworkbook-excel-found-unreadable-content

2 down vote favorite

I have an existing workbook that acts as template. I tried to update a cell value in an existing row, meaning the adjacent cell has a value. The problem is that after the file is created and I open it, I get the following error: "Excel found unreadable content in...." I assume the reason is SXSSFWorkbook only handles writing and if a row exists it cant update the contents of the row, which would entail reading and then writing - is this correct or am I experiencing a bug?

 

In case anyone else has this problem, check to make sure the length of your SheetName is not too long. I was getting this error when setting the workbook sheet name longer than around 30 characters.

  XSSFWorkbook wb = new XSSFWorkbook();
  XSSFSheet sheet = wb.createSheet();
  wb.setSheetName(0, "Supporting Documentation"); // make sure this is not too long

 

 

=============

http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-td4658852.html

http://apache-poi.1045710.n5.nabble.com/Unreadable-Content-using-XSSF-POI-3-8-while-writing-to-response-getOutputStream-td5710172.html