poi生成excel 样式控制

最新推荐文章于 2023-05-16 15:23:34 发布

t1137471535

最新推荐文章于 2023-05-16 15:23:34 发布

阅读量460

点赞数

分类专栏： POI

POI 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

此程序是使用poi-3.7.jar自动生成excel的小程序，程序中自己设置了字体、单元格、标题、边框等样式，包含了合并单元格，设置单元格大小等，生成excel时，调用相应方法就行了，程序如下：（注意导入poi-3.7.jar包）

package cn.sh.ideal.test;

import java.io.FileOutputStream;
import java.util.HashMap;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
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.HSSFCellUtil;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.PrintSetup;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.Region;

public class CreateExcel{

   /**
     * 设置单元格的格式
     */
    /**
     * @param wb
     * @return
     */
    private static Map<String, CellStyle> createStyles(Workbook wb){
        Map<String, CellStyle> styles = new HashMap<String, CellStyle>();

        short borderColor = IndexedColors.GREY_50_PERCENT.getIndex();

      //正文title样式
        CellStyle style;
       style = wb.createCellStyle();
       // 居中
       style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
       style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
       //边框
       style.setBorderTop(HSSFCellStyle.BORDER_THIN);
       style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
       style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
       style.setBorderRight(HSSFCellStyle.BORDER_THIN);
       style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
       style.setFillForegroundColor(HSSFColor.YELLOW.index);
       //设置字体
       Font titleFont = wb.createFont();
       titleFont.setFontName("宋体");
       titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
       //设置字体大小
       titleFont.setFontHeightInPoints((short)16);
       //设置颜色
       titleFont.setColor(IndexedColors.AUTOMATIC.getIndex());
       //设置样式的字体
       style.setFont(titleFont);
        styles.put("title", style);

        //标题行样式
        CellStyle styleName;
        styleName = wb.createCellStyle();
        styleName.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        styleName.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        styleName.setBorderTop(HSSFCellStyle.BORDER_THIN);
        styleName.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        styleName.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        styleName.setBorderRight(HSSFCellStyle.BORDER_THIN);
       Font nameFont = wb.createFont();
       nameFont.setFontName("宋体");
       nameFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
       nameFont.setFontHeightInPoints((short)12);
       nameFont.setColor(IndexedColors.AUTOMATIC.getIndex());
       styleName.setFont(nameFont);
        styles.put("name", styleName);

        //标题行动态数据样式
        CellStyle styleData;
        styleData = wb.createCellStyle();
        styleData.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        styleData.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        styleData.setBorderTop(HSSFCellStyle.BORDER_THIN);
        styleData.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        styleData.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        styleData.setBorderRight(HSSFCellStyle.BORDER_THIN);
       Font dataFont = wb.createFont();
       dataFont.setFontName("宋体");
       dataFont.setFontHeightInPoints((short)12);
       dataFont.setColor(IndexedColors.AUTOMATIC.getIndex());
       styleData.setFont(dataFont);
       styleData.setWrapText(true);
        styles.put("data", styleData);

        //单元格样式
        CellStyle styleCell;
        styleCell = wb.createCellStyle();
        styleCell.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        styleCell.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        styleCell.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        styleCell.setBorderRight(HSSFCellStyle.BORDER_THIN);
        styleCell.setBorderTop(HSSFCellStyle.BORDER_THIN);
        styleCell.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        Font cellFont = wb.createFont();
        cellFont.setFontName("宋体");
        cellFont.setFontHeightInPoints((short)12);
        cellFont.setColor(IndexedColors.AUTOMATIC.getIndex());
        styleCell.setFont(dataFont);
        styleCell.setWrapText(true);
        styles.put("cell", styleCell);

        return styles;
    }