poi导出xlsx(Excel2007)

Excel2007以上版本导出简单实现

使用Apache POI导出Excel(.xlsx)
Excel <=2003 数据限制，行(65536)列(256)
Excel =2007 数据限制，行(1048576)列(16384)

---

Apache POI官方网站
Apache POI使用详解
此代码可直接运行

package exportexcel;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class BuildXLSX {
@SuppressWarnings("resource")
public static void main(String[] args) throws IOException {
    SimpleDateFormat dateFormat = new SimpleDateFormat("YYYYMMDDhhmmss");
    String now = dateFormat.format(new Date());
    //导出文件路径
    String basePath = "C:/";
    //文件名
    String exportFileName = "数据_"+now+".xlsx";
    String[] cellTitle = {"序号","姓名","学号","性别","入学日期"};
    //需要导出的数据
    List<String[]> dataList = new ArrayList<String[]>();
    dataList.add(new String[]{"东邪","17232401001","男","2015年9月"});
    dataList.add(new String[]{"西毒","17232401002","女","2016年9月"});
    dataList.add(new String[]{"南帝","17232401003","男","2017年9月"});
    dataList.add(new String[]{"北丐","17232401004","男","2015年9月"});
    dataList.add(new String[]{"中神通","17232401005","女","2017年9月"});
    // 声明一个工作薄
    XSSFWorkbook workBook = null;
    workBook = new XSSFWorkbook();
    // 生成一个表格
    XSSFSheet sheet = workBook.createSheet();
    workBook.setSheetName(0,"学生信息");
    // 创建表格标题行 第一行
    XSSFRow titleRow = sheet.createRow(0);
    for(int i=0;i<cellTitle.length;i++){
        titleRow.createCell(i).setCellValue(cellTitle[i]);
    }
    //插入需导出的数据
    for(int i=0;i<dataList.size();i++){
        XSSFRow row = sheet.createRow(i+1);
        row.createCell(0).setCellValue(i+1);
        row.createCell(1).setCellValue(dataList.get(i)[0]);
        row.createCell(2).setCellValue(dataList.get(i)[1]);
        row.createCell(3).setCellValue(dataList.get(i)[2]);
        row.createCell(4).setCellValue(dataList.get(i)[3]);
    }
    File  file = new File(basePath+exportFileName);
    //文件输出流
    FileOutputStream outStream = new FileOutputStream(file);
    workBook.write(outStream);
    outStream.flush();
    outStream.close();
    System.out.println("导出2007文件成功！文件导出路径：--"+basePath+exportFileName);
}
}

需要的jar包
poi-3.15.jar
poi-ooxml-3.15.jar
poi-ooxml-schemas-3.15.jar
commons-collections4-4.1.jar
xmlbeans-2.3.0.jar

参考:http://www.jianshu.com/p/e5e1d82a3775

转载于:https://www.cnblogs.com/Bouger/p/6635168.html