Hi ,

I am using Apache POI 3.10 Final version to generate an excel document as per my application requirement. My application runs on JDK 1.5 version and it is producing an unreadable xlsx document saying " Excel found unreadable content in XXX.XLSX. Do you want to recover the contents of the workbook?"

Please find the simulation of code i have used

public static void main(String[] args) {
	
	SXSSFWorkbook workbook = new SXSSFWorkbook(300);

	SXSSFSheet sheet = (SXSSFSheet)   workbook.createSheet("Teller_Discrepancy");   
	
		Map<String, Object[]> data = new HashMap<String, Object[]>(); 
		
		 final String[] titles = {
				 "Col1","Col2","Col3",.......,"Col15"
	    };

		 createHeaderRow(workbook, sheet, titles);
		 writeToExcel(sheet, data, getColumnStyle(workbook));
		 sheet.setDefaultColumnWidth(15);

		FileOutputStream out = new FileOutputStream(new File("C:\Temp"));     
		workbook.write(out);     
		out.close();   

}

private void writeToExcel(SXSSFSheet sheet, Map<String, Object[]> data, CellStyle columnStyle){
		Set<String> keyset = data.keySet(); 
		int rownum = 1; 
		for (String key : keyset) {     
			SXSSFRow row = (SXSSFRow) sheet.createRow(rownum++);     
			Object [] objArr = data.get(key);     
			int cellnum = 0;     
			for (Object obj : objArr) {         
				SXSSFCell cell = (SXSSFCell) row.createCell(cellnum++); 
				cell.setCellStyle(columnStyle);
				if (obj == null) {
					cell.setCellValue("");
				}
				else {
					cell.setCellValue(String.valueOf(obj));
				}
			}
		}
	}
	
	private void createHeaderRow(SXSSFWorkbook workbook, SXSSFSheet sheet, String[] titles) {
		// Setting Title Font properties
	     Font titleFont = workbook.createFont();
	     titleFont.setFontHeightInPoints((short)9);
	     titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
	     
	     // Setting Header Style
	     CellStyle style = workbook.createCellStyle();
	     style.setAlignment(CellStyle.ALIGN_CENTER);
	     style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
	     style.setFillForegroundColor(IndexedColors.YELLOW.getIndex());
	     style.setFillPattern(CellStyle.SOLID_FOREGROUND);
	     style.setFont(titleFont);
	     style.setWrapText(true);
	     style.setBorderBottom(CellStyle.BORDER_THIN);
	     style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
	     style.setBorderLeft(CellStyle.BORDER_THIN);
	     style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
	     style.setBorderRight(CellStyle.BORDER_THIN);
	     style.setRightBorderColor(IndexedColors.BLACK.getIndex());
	     style.setBorderTop(CellStyle.BORDER_THIN);
	     style.setTopBorderColor(IndexedColors.BLACK.getIndex());
	    
	     
	     // Creating Header Row
		SXSSFRow headerRow = (SXSSFRow) sheet.createRow(0);
		headerRow.setHeightInPoints(40);
		SXSSFCell headerCell;
			for (int i = 0; i < titles.length; i++) {
		         headerCell = (SXSSFCell) headerRow.createCell(i);
		         headerCell.setCellValue(titles[i]);
		         headerCell.setCellStyle(style);
			}
	}
	
	private CellStyle getColumnStyle(SXSSFWorkbook workbook) {
		 CellStyle columnStyle = workbook.createCellStyle();
	     columnStyle.setAlignment(CellStyle.ALIGN_CENTER);
	     columnStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
	     columnStyle.setBorderBottom(CellStyle.BORDER_THIN);
	     columnStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());
	     columnStyle.setBorderLeft(CellStyle.BORDER_THIN);
	     columnStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
	     columnStyle.setBorderRight(CellStyle.BORDER_THIN);
	     columnStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
	     columnStyle.setBorderTop(CellStyle.BORDER_THIN);
	     columnStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());
	     return columnStyle;
	}