Java 实现导出excel表

需要的Maven仓库依赖如下：

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
　　 <version>3.17</version>
</dependency>

1.直接上代码

    import java.io.FileOutputStream;  
    import java.text.SimpleDateFormat;  
    import java.util.ArrayList;  
    import java.util.List;  
      
    import org.apache.poi.hssf.usermodel.HSSFCell;  
    import org.apache.poi.hssf.usermodel.HSSFCellStyle;  
    import org.apache.poi.hssf.usermodel.HSSFRow;  
    import org.apache.poi.hssf.usermodel.HSSFSheet;  
    import org.apache.poi.hssf.usermodel.HSSFWorkbook;  
      
    public class CreateSimpleExcelToDisk  
    {  
        /** 
         * @功能：手工构建一个简单格式的Excel 
         */  
        private static List<Student> getStudent() throws Exception  
        {  
            List list = new ArrayList();  
            SimpleDateFormat df = new SimpleDateFormat("yyyy-mm-dd");  
      
            Student user1 = new Student(1, "张三", 16, df.parse("1997-03-12"));  
            Student user2 = new Student(2, "李四", 17, df.parse("1996-08-12"));  
            Student user3 = new Student(3, "王五", 26, df.parse("1985-11-12"));  
            list.add(user1);  
            list.add(user2);  
            list.add(user3);  
      
            return list;  
        }  
      
        public static void main(String[] args) throws Exception  
        {  
            // 第一步，创建一个webbook，对应一个Excel文件  
            HSSFWorkbook wb = new HSSFWorkbook();  
            // 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet  
            HSSFSheet sheet = wb.createSheet("学生表一");  
            // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short  
            HSSFRow row = sheet.createRow((int) 0);  
            // 第四步，创建单元格，并设置值表头 设置表头居中  
            HSSFCellStyle style = wb.createCellStyle();  
            style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式  
      
            HSSFCell cell = row.createCell((short) 0);  
            cell.setCellValue("学号");  
            cell.setCellStyle(style);  
            cell = row.createCell((short) 1);  
            cell.setCellValue("姓名");  
            cell.setCellStyle(style);  
            cell = row.createCell((short) 2);  
            cell.setCellValue("年龄");  
            cell.setCellStyle(style);  
            cell = row.createCell((short) 3);  
            cell.setCellValue("生日");  
            cell.setCellStyle(style);  
      
            // 第五步，写入实体数据 实际应用中这些数据从数据库得到，  
            List list = CreateSimpleExcelToDisk.getStudent();  
      
            for (int i = 0; i < list.size(); i++)  
            {  
                row = sheet.createRow((int) i + 1);  
                Student stu = (Student) list.get(i);  
                // 第四步，创建单元格，并设置值  
                row.createCell((short) 0).setCellValue((double) stu.getId());  
                row.createCell((short) 1).setCellValue(stu.getName());  
                row.createCell((short) 2).setCellValue((double) stu.getAge());  
                cell = row.createCell((short) 3);  
                cell.setCellValue(new SimpleDateFormat("yyyy-mm-dd").format(stu  
                        .getBirth()));  
            }  
            // 第六步，将文件存到指定位置  
            try  
            {  
                FileOutputStream fout = new FileOutputStream("E:/students.xls");  
                wb.write(fout);  
                fout.close();  
            }  
            catch (Exception e)  
            {  
                e.printStackTrace();  
            }  
        }  
    }  

 2 另外补充一点，还可以设置行和列自适应的

?

1 2 3 4 5 6 7 8 9 10 11 12 13

// 设置列宽 sheet.setColumnWidth(0, 18 * 256); sheet.setColumnWidth(2, 18 * 256); sheet.setColumnWidth(3, 18 * 256); sheet.setColumnWidth(4, 18 * 256);   //设置行高 HSSFRow row = sheet.createRow((int) 0); row.setHeight(st);    //设置第一行和第二行格式为合并单元行，分别对应起始行，结束行，起始列，结束列  sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 2));  sheet.addMergedRegion(new CellRangeAddress(1, 1, 0, 2));

 还有就是乱码问题

//这是一个工具类，IE浏览器这边做了修改，不然一直这一直有问题，现在是可以的
public static void exportExcel(String name, HSSFWorkbook workbook, HttpServletResponse response, HttpServletRequest request)
            throws IOException
    {
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        // 使用时间戳作为表格名称
        String fileName = name + df.format(new Date()) + ".xls";

        // String downloadFileName = new String(strObj.getBytes("utf-8"), "iso8859-1");
        String finalFileName = null;
        final String userAgent = request.getHeader("USER-AGENT");
        // 设置http头
        if(null != userAgent && -1 != userAgent.indexOf("MSIE") || null != userAgent
                && -1 != userAgent.indexOf("Trident")){//IE浏览器
            finalFileName = java.net.URLEncoder.encode(fileName,"UTF8");
        }else if(StringUtils.contains(userAgent, "Mozilla")){//google,火狐浏览器
            finalFileName = new String(fileName.getBytes(), "ISO8859-1");
        }else{
            finalFileName = URLEncoder.encode(fileName,"UTF8");//其他浏览器
        }
        response.setCharacterEncoding("utf-8");
        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-Disposition", "attachment;fileName=" + finalFileName);

        // out出文件流
        OutputStream os = response.getOutputStream();

        // 输出excel
        workbook.write(os); // 关闭io流
        os.close();
    }