POI简单初识 Demo （资源来自网络本人属于收藏总结）

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
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 testPOI {

    /**
     * @param args
     * @throws IOException 
     */
    public static void main(String[] args) throws IOException {
        // TODO Auto-generated method stub
         SimpleDateFormat dateFormat = new SimpleDateFormat("YYYYMMDDhhmmss");
         String now = dateFormat.format(new Date());
         System.out.println(now);
         String basePath = "C:\\Users\\hzxx\\Desktop";    //文件位置
         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);
    }

}

输出效果