Poi生成Excel

原生poi生成Excel

@Test
public void testBaseWrite() throws IOException {
    HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
    HSSFSheet sheet = hssfWorkbook.createSheet("区域");
    Row titleRow = sheet.createRow(0);
    titleRow.createCell(0).setCellValue("省");
    titleRow.createCell(1).setCellValue("市");
    titleRow.createCell(2).setCellValue("区");
    titleRow.createCell(3).setCellValue("邮编");
    titleRow.createCell(4).setCellValue("区域号");
    for (Area area : list) {
        int lastRowNum = sheet.getLastRowNum();
        Row row = sheet.createRow(lastRowNum+1);
        row.createCell(0).setCellValue(area.getProvince());
        row.createCell(1).setCellValue(area.getCity());
        row.createCell(2).setCellValue(area.getArea());
        row.createC