03 导出带样式的数据

最新推荐文章于 2025-02-07 15:23:25 发布

TraceNL

最新推荐文章于 2025-02-07 15:23:25 发布

阅读量80

点赞数

分类专栏： poi exce 文章标签： excel poi

本文链接：https://blog.csdn.net/weixin_39408396/article/details/113957347

版权

poi 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

exce

1 篇文章 0 订阅

订阅专栏

导出带样式的excel

package test01;

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;

import java.io.File;
import java.io.FileOutputStream;

public class ExportWithStyle {
    public static void main(String[] args) {
        String[] title = {"区县", "分局", "完成量", "完成率"};
        String[][] data = {
                {"姑苏区", "白洋湾分局", "10", "45.86%"},
                {"姑苏区", "沧浪分局", "55", "48.88%"},
                {"姑苏区", "虎丘分局", "49", "62.12%"},
                {"姑苏区", "金阊分局", "33", "8.9%"},
                {"姑苏区", "平江分局", "64", "79.5%"},
                {"姑苏区", "双塔分局", "13", "91.76%"},
                {"姑苏区", "苏锦分局", "9", "74.95%"},
                {"姑苏区", "吴门桥分局", "24", "18.78%"},
                {"姑苏区", "姑苏行业网格（虚拟）", "64", "42.56%"}};

        HSSFWorkbook wb = new HSSFWorkbook();

        HSSFFont headFont = wb.createFont();//表头字体样式
        headFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//加粗
        headFont.setColor(HSSFColor.BLACK.index);//黑色字体
        headFont.setFontHeightInPoints((short)11);//文字大小
        headFont.setFontName("微软雅黑");//字体名称

        HSSFCellStyle headStyle = wb.createCellStyle();//表头样式
        headStyle.setFont(headFont);//设置字体样式
        headStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//上下居中
        headStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);//左右居中
        headStyle.setFillForegroundColor(HSSFColor.YELLOW.index);//设置背景颜色
        headStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        headStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        headStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        headStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        headStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);

        HSSFFont bodyFont = wb.createFont();
        bodyFont.setColor(HSSFColor.BLACK.index);
        bodyFont.setFontHeightInPoints((short) 9);
        bodyFont.setFontName("微软雅黑");

        HSSFCellStyle bodyCellStyle = wb.createCellStyle();
        bodyCellStyle.setFont(bodyFont);
        bodyCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        bodyCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        bodyCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        bodyCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        bodyCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        bodyCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
        bodyCellStyle.setWrapText(true);//自动换行

        int rownum = 0;
        HSSFSheet sheet = wb.createSheet("Sheet1");
        HSSFRow row = null;
        HSSFCell cell = null;
        /******************************************输出表头 begin*************************************************/
        row = sheet.createRow(rownum++);
        row.setHeight((short) 500);//设置行高
        for (int i = 0;i < title.length; i++) {
            cell = row.createCell(i);
            cell.setCellStyle(headStyle);
            cell.setCellValue(new HSSFRichTextString(title[i]));
        }
        /******************************************输出表头 end*************************************************/

        /******************************************输出数据 begin*************************************************/
        for (int i = 0; i < data.length; i++) {
            row = sheet.createRow(rownum++);
            for (int j = 0;j < data[i].length; j++) {
                cell = row.createCell(j);
                cell.setCellStyle(bodyCellStyle);
                cell.setCellValue(new HSSFRichTextString(data[i][j]));
            }
        }
        /******************************************输出数据 end*************************************************/

        for (int i = 0; i < title.length; i++){
            sheet.autoSizeColumn((short)i);
        }

        try {
            String filePath = "C:\\Users\\asus\\Desktop\\test\\笔记\\java\\excel\\file\\";
            String fileName = "测试2.xls";

            File file = new File(filePath, fileName);
            FileOutputStream outputStream = new FileOutputStream(file);
            wb.write(outputStream);
            outputStream.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}