exporter.close();
outputStream.flush();
}
public void exportToXLS(JSONObject worksheetJSON, OutputStream stream) throws JSONException, IOException, SerializationException{
WorkSheetXLSExporter exporter = new WorkSheetXLSExporter();
HSSFWorkbook wb = new HSSFWorkbook();
CreationHelper createHelper = wb.getCreationHelper();
int sheetsNumber = worksheetJSON.getInt(SHEETS_NUM);
JSONArray exportedSheets = worksheetJSON.getJSONArray(EXPORTED_SHEETS);
for (int i = 0; i < sheetsNumber; i++) {
JSONObject sheetJ = exportedSheets.getJSONObject(i);
String sheetName = "Sheet " + i;
HSSFSheet sheet = wb.createSheet(sheetName);
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
for(int j = 0; j < 50; j++){
sheet.createRow(j);
}
if(sheetJ.has(WorkSheetXLSExporter.HEADER)){
JSONObject header = sheetJ.getJSONObject(WorkSheetXLSExporter.HEADER);
if(header!=null){
exporter.setHeader(sheet, header, createHelper, wb, patriarch);
}
}
int endRowNum = 37;
if(sheetJ.has(WorkSheetXLSExporter.CONTENT)){
endRowNum = fillSheetContent(wb, sheet, sheetJ, createHelper, exporter, patriarch);
}
if(sheetJ.has(WorkSheetXLSExporter.FOOTER)){
JSONObject footer = sheetJ.getJSONObject(WorkSheetXLSExporter.FOOTER);
if(footer!=null){
exporter.setFooter(sheet, footer, createHelper, wb, endRowNum, patriarch);
}
}
}
wb.write(stream);