java返回excel文件流损坏,通过与Java结合使用Apache POI创建excel（.xlsx）文件后，文件已损坏...

I have created a Workbook/Excel in .xlsx format with Java using Apache POI API successfully. My code is as below that is created a file named "RiponAlWasim.xlsx" in D drive:

Workbook wb = new XSSFWorkbook();

FileOutputStream fileOut = new FileOutputStream("D:\\RiponAlWasim.xlsx");

wb.write(fileOut);

fileOut.close();

wb.close();

When I tried to open "RiponAlWasim.xlsx" it was shown the file is corrupted. What's the wrong?

解决方案

It needs to be added at least one sheet to the workbook. So, after creating a worksheet the following code is working well:

Workbook wb = new XSSFWorkbook();

Sheet sheet1 = wb.createSheet("Ripon");

FileOutputStream fileOut = new FileOutputStream("D:\\RiponAlWasim.xlsx");

wb.write(fileOut);

fileOut.close();

wb.close();