POI导出Excel表格-蒲公英云

POI导出Excel表格

た入场券 2023-06-06 12:14 100阅读 0赞

具体需要的jar包参考上篇文章POI解析Excel表格

创建表格的格式内容是List<String[]>字符串数组。

package com.ftx.poi;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
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.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
/** * 文件导出 * @author Administrator * */
public class ExportExcel { 
    //创建Excel表格
    public static void main(String[] args) throws IOException { 
        ExportExcel export = new ExportExcel();
        List<String[]> resource=new ArrayList<String[]>();
        resource.add(new String[] { "性别","姓名","住址"});
        resource.add(new String[] { "男","樊江锋","河南郑州"});
        resource.add(new String[] { "女","袁梦阳","河南安阳"});
        //指定生成文件的路径和文件名
        OutputStream outputStream=new FileOutputStream("D:\\exportFile.xls");
        export.exportExcel(resource, outputStream);
        outputStream.flush();
        outputStream.close();
    }
/** * 文件导出方法 * @param resource List<String[]> 集合类型，要导出的具体数据集合 * @param outputStream 输出流，输出的Excel文件保存的具体位置 * @throws IOException */
    public void exportExcel(List<String[]> resource,OutputStream outputStream) throws IOException { 
        //创建一个内存Excel对象
        HSSFWorkbook workbook=new HSSFWorkbook();
        //创建一个表格
        HSSFSheet sheet = workbook.createSheet("sheet1");
        //创建表头
        //获取表头内容 也就是resource集合的第零个索引的字符串数组
        String[] headerStr = resource.get(0);
        HSSFRow headeRow = sheet.createRow(0);
        //设置列宽
        for (int i = 0; i < headerStr.length; i++) { 
            sheet.setColumnWidth(i, 5000);
        }
        //设置头单元格样式
        HSSFCellStyle headerStyle = workbook.createCellStyle();
        headerStyle.setAlignment(HorizontalAlignment.CENTER);//水平居中
        //设置字体
        HSSFFont headerFont = workbook.createFont();
        //headerFont.setColor(HSSFColor.VIOLET.index);
        headerFont.setFontName("宋体");
        headerStyle.setFont(headerFont);
        //定义表头内容
        for (int i = 0; i < headerStr.length; i++) { 
            //定义一个单元格
            HSSFCell headerCell = headeRow.createCell(i);
            headerCell.setCellStyle(headerStyle);
            headerCell.setCellValue(headerStr[i]);
        }
        //标题内容
        //样式
        HSSFCellStyle bodyStyle = workbook.createCellStyle();
        bodyStyle.setAlignment(HorizontalAlignment.CENTER);//水平居中
        //设置字体
        HSSFFont bodyFont = workbook.createFont();
        //bodyFont.setColor(HSSFColor.BLUE.index);
        bodyFont.setFontName("宋体");
        bodyStyle.setFont(bodyFont);
        //创建行，上面表头已经创建过第0行了，所以这里从1开始
        for (int row = 1; row < headerStr.length; row++) { 
            //输出的行数据
            String[] temp = resource.get(row);
            //创建行
            HSSFRow bodyRow = sheet.createRow(row);
            //循环创建列
            for (int cell = 0; cell < temp.length; cell++) { 
                HSSFCell bodyCell = bodyRow.createCell(cell);
                bodyCell.setCellStyle(bodyStyle);
                bodyCell.setCellValue(temp[cell]);
            }
        }
        //将内存创建的excel对象，输出到文件夹中
        workbook.write(outputStream);
    }
}