Saat menggunakan xlsx di APACHE POI maka akhirnya saat mau export ke excel gunakan code ini
Workbook workbook;
....
workbook = excelExportDAO.createLoanOffersXls(loanOffersDTOs);
if (workbook != null) {
if (workbook instanceof HSSFWorkbook) {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition",
"attachment; filename=report.xls");
} else {
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.setHeader("Content-Disposition",
"attachment; filename=report.xlsx");
}
OutputStream out = response.getOutputStream();
hssfWorkbook.write(out);
out.close();
} https://stackoverflow.com/questions/29705422/file-format-and-extension-of-the-report-xlsx-dont-match
Tidak ada komentar:
Posting Komentar