Kamis, 05 November 2020

POI Apache xlsx rename workbook

 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