java 创建多个sheet_java-使用Apache poi和servlet创建多个工作表

当我使用Apache poi和servlet创建多个工作表时.它正在创建工作表,但未将数据写入文件.我正在尝试通过下面的代码将前1000条记录写入sheet1,然后将1000条记录写入sheet2,但无法正常工作

private void writeDataToExcelFile(String string,

ArrayList> excelData, OutputStream outputStream) {

HSSFWorkbook myWorkBook = new HSSFWorkbook();

String sheetName = "";

sheetName = "Document-" + 0;

HSSFSheet mySheet = myWorkBook.createSheet();

HSSFRow myRow = null;

HSSFCell myCell = null;

for (int rowNum = 0; rowNum < excelData.size(); rowNum++) {

ArrayList rowData = excelData.get(rowNum);

if(rowNum>0 && rowNum%1000 == 0)

{

sheetName = "Document-" + (rowNum/1000);

mySheet = myWorkBook.createSheet();

}

myRow = mySheet.createRow(rowNum);

for (int cellNum = 0; cellNum < rowData.size(); cellNum++) {

myCell = myRow.createCell(cellNum);

myCell.setCellValue(rowData.get(cellNum));

}

}

System.out.println("Last row:" + mySheet.getLastRowNum());

System.out.println("Row number:" + mySheet.rowIterator().next().getRowNum());

try {

myWorkBook.write(outputStream);

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

outputStream.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

我的逻辑有什么问题.请提供必要的帮助.

谢谢