java导出多个sheet的excel

public void  selectCountExcel(HttpServletResponse response) {
        try {
            ServletOutputStream outputStream = response.getOutputStream();
            response.setContentType("xls/xlsx");
            response.setCharacterEncoding("utf-8");
            String a = "发送总量统计";
            response.setHeader("Content-Disposition", "attachment;fileName="+new String(a.getBytes("gb2312"), "ISO8859-1")+".xls");

            List<List<String>> data1 = new ArrayList<List<String>>();
            List<List<String>> data2 = new ArrayList<List<String>>();
            List<List<String>> data3 = new ArrayList<List<String>>();
            for (int i = 1; i < 5; i++) {
                List rowData = new ArrayList();
                rowData.add(String.valueOf(i));
                rowData.add("上海东霖柏鸿");
                data1.add(rowData);
            }
            for (int i = 1; i < 5; i++) {
                List rowData = new ArrayList();
                rowData.add(String.valueOf(i));
                rowData.add("深圳东霖柏鸿");
                data2.add(rowData);
            }
            for (int i = 1; i < 5; i++) {
                List rowData = new ArrayList();
                rowData.add(String.valueOf(i));
                rowData.add("广州东霖柏鸿");
                data3.add(rowData);
            }
            String[] headers1 = { "ID1", "用户名1" };
            String[] headers2 = { "ID2", "用户名2" };
            String[] headers3 = { "ID3", "用户名3" };
            ExportExcelUtilsTest eeu = new ExportExcelUtilsTest();//工具类写法在下面
            HSSFWorkbook workbook = new HSSFWorkbook();
            eeu.exportExcel(workbook, 0, "上海", headers1, data1, outputStream);
            eeu.exportExcel(workbook, 1, "深圳", headers2, data2, outputStream);
            eeu.exportExcel(workbook, 2, "广州", headers3, data3, outputStream);
//原理就是将所有的数据一起写入，然后再关闭输入流。
            workbook.write(outputStream);
            outputStream.close();
        }catch (Exception e){
            e.printStackTrace();
        }

最后

以上就是高大钢笔为你收集整理的java导出多个sheet的excel的全部内容，希望文章能够帮你解决java导出多个sheet的excel所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。