ASPOSE.CELL FOR JAVA 导出Excel简单例子

public void OutFileToStream(HttpServletRequest request, HttpServletResponse response) throws Exception {

        Workbook workbook = new Workbook();
        WorksheetCollection worksheets = workbook.getWorksheets();
        Worksheet worksheet = worksheets.get(0);
        Cells cells = worksheet.getCells();

        //设置标题样式
        Style HeaderStyle = workbook.createStyle();
        HeaderStyle.getFont().setBold(true);  //文字加粗
        HeaderStyle.setName("宋体");  //文字字体
        HeaderStyle.getFont().setSize(13);  //文字大小
        HeaderStyle.setHorizontalAlignment(TextAlignmentType.CENTER);
        HeaderStyle.setTextWrapped(true);//单元格内容自动换行

        //设置内容样式
        Style cellsStyle = workbook.createStyle();
        cellsStyle.setHorizontalAlignment(TextAlignmentType.CENTER);  //居中
        HeaderStyle.setName("宋体");  //文字字体
        HeaderStyle.getFont().setSize(12);  //文字大小
        cellsStyle.setTextWrapped(true);//单元格内容自动换行

        for (int i = 0; i < 10; i++) {
            cells.get(0, i).setValue("标题" + (i+1));
            cells.get(0, i).setStyle(HeaderStyle);
            cells.setRowHeight(0,25);
            cells.setColumnWidth(i,25);
        }

        for (int i = 0; i < 10; i++) {
            cells.get(1, i).setValue("哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈");
            cells.get(1, i).setStyle(cellsStyle);
            cells.setRowHeight(i, 20);
            cells.setColumnWidth(i, 38);
        }

        String filename = "xxxxxx.xlsx";
        try {
            try {
                filename = new String(filename.getBytes(), "ISO8859-1");
            } catch (UnsupportedEncodingException e) {
                e.printStackTrace();
            }
            response.setContentType("application/octet-stream;charset=ISO8859-1");
            response.setHeader("Content-Disposition", "attachment;filename=" + filename);
            response.addHeader("Pargam", "no-cache");
            response.addHeader("Cache-Control", "no-cache");
            workbook.save(response.getOutputStream(), SaveFormat.XLSX);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

aspose-cells-18.9.jar 下载