当前位置: 首页>>代码示例>>Java>>正文

Java CellStyle.cloneStyleFrom方法代码示例

本文整理汇总了Java中org.apache.poi.ss.usermodel.CellStyle.cloneStyleFrom方法的典型用法代码示例。如果您正苦于以下问题：Java CellStyle.cloneStyleFrom方法的具体用法？Java CellStyle.cloneStyleFrom怎么用？Java CellStyle.cloneStyleFrom使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.poi.ss.usermodel.CellStyle的用法示例。


在下文中一共展示了CellStyle.cloneStyleFrom方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: createStyles

import org.apache.poi.ss.usermodel.CellStyle; //导入方法依赖的package包/类
/**
     * 创建表格样式
     * @param wb 工作薄对象
     * @return 样式列表
     */
    private Map<String, CellStyle> createStyles(Workbook wb) {
        Map<String, CellStyle> styles = new HashMap<String, CellStyle>();

        CellStyle style = wb.createCellStyle();
        style.setAlignment(CellStyle.ALIGN_CENTER);
        style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
        Font titleFont = wb.createFont();
        titleFont.setFontName("Arial");
        titleFont.setFontHeightInPoints((short) 16);
        titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
        style.setFont(titleFont);
        styles.put("title", style);

        style = wb.createCellStyle();
        style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
        style.setBorderRight(CellStyle.BORDER_THIN);
        style.setRightBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
        style.setBorderLeft(CellStyle.BORDER_THIN);
        style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
        style.setBorderTop(CellStyle.BORDER_THIN);
        style.setTopBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
        style.setBorderBottom(CellStyle.BORDER_THIN);
        style.setBottomBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
        Font dataFont = wb.createFont();
        dataFont.setFontName("Arial");
        dataFont.setFontHeightInPoints((short) 10);
        style.setFont(dataFont);
        styles.put("data", style);

        style = wb.createCellStyle();
        style.cloneStyleFrom(styles.get("data"));
        style.setAlignment(CellStyle.ALIGN_LEFT);
        styles.put("data1", style);

        style = wb.createCellStyle();
        style.cloneStyleFrom(styles.get("data"));
        style.setAlignment(CellStyle.ALIGN_CENTER);
        styles.put("data2", style);

        style = wb.createCellStyle();
        style.cloneStyleFrom(styles.get("data"));
        style.setAlignment(CellStyle.ALIGN_RIGHT);
        styles.put("data3", style);

        style = wb.createCellStyle();
        style.cloneStyleFrom(styles.get("data"));
//		style.setWrapText(true);
        style.setAlignment(CellStyle.ALIGN_CENTER);
        style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
        style.setFillPattern(CellStyle.SOLID_FOREGROUND);
        Font headerFont = wb.createFont();
        headerFont.setFontName("Arial");
        headerFont.setFontHeightInPoints((short) 10);
        headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
        headerFont.setColor(IndexedColors.WHITE.getIndex());
        style.setFont(headerFont);
        styles.put("header", style);

        return styles;
    }
开发者ID:sombie007，项目名称:ExcelHandle，代码行数:66，代码来源:ExportExcel.java

示例2: createStyles

import org.apache.poi.ss.usermodel.CellStyle; //导入方法依赖的package包/类
/**
 * excel 样式
 *
 * @return
 */
public Map<String, CellStyle> createStyles(Workbook workbook) {
    Map<String, CellStyle> styles = new HashMap();
    CellStyle style = workbook.createCellStyle();
    style.setAlignment((short) 2);
    style.setVerticalAlignment((short) 1);
    Font titleFont = workbook.createFont();
    titleFont.setFontName("Arial");
    titleFont.setFontHeightInPoints((short) 16);
    titleFont.setBoldweight((short) 700);
    style.setFont(titleFont);
    styles.put("title", style);
    style = workbook.createCellStyle();
    style.setVerticalAlignment((short) 1);
    style.setBorderRight((short) 1);
    style.setRightBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
    style.setBorderLeft((short) 1);
    style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
    style.setBorderTop((short) 1);
    style.setTopBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
    style.setBorderBottom((short) 1);
    style.setBottomBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
    Font dataFont = workbook.createFont();
    dataFont.setFontName("Arial");
    dataFont.setFontHeightInPoints((short) 10);
    style.setFont(dataFont);
    styles.put("data", style);
    style = workbook.createCellStyle();
    style.cloneStyleFrom((CellStyle) styles.get("data"));
    style.setAlignment((short) 1);
    styles.put("data1", style);
    style = workbook.createCellStyle();
    style.cloneStyleFrom((CellStyle) styles.get("data"));
    style.setAlignment((short) 2);
    styles.put("data2", style);
    style = workbook.createCellStyle();
    style.cloneStyleFrom((CellStyle) styles.get("data"));
    style.setAlignment((short) 3);
    styles.put("data3", style);
    style = workbook.createCellStyle();
    style.cloneStyleFrom((CellStyle) styles.get("data"));
    style.setAlignment((short) 2);
    style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
    style.setFillPattern((short) 1);
    Font headerFont = workbook.createFont();
    headerFont.setFontName("Arial");
    headerFont.setFontHeightInPoints((short) 10);
    headerFont.setBoldweight((short) 700);
    headerFont.setColor(IndexedColors.WHITE.getIndex());
    style.setFont(headerFont);
    styles.put("header", style);
    return styles;
}
开发者ID:zhangbiy，项目名称:exportExcel，代码行数:58，代码来源:ExcelTest.java

示例3: copyCellStyle

import org.apache.poi.ss.usermodel.CellStyle; //导入方法依赖的package包/类
/**
 * 复制单元格样式
 * 
 * @author      ZhengWei(HY)
 * @createDate  2017-03-18
 * @version     v1.0
 *
 * @param i_FromCellStyle  源单元格样式
 * @param i_ToCellStyle    目标单元格样式
 */
public final static void copyCellStyle(CellStyle i_FromCellStyle ,CellStyle i_ToCellStyle)
{
    if ( i_FromCellStyle instanceof HSSFCellStyle )
    {
        i_ToCellStyle.cloneStyleFrom(i_FromCellStyle);
        /*
        i_ToCellStyle.setAlignment(          i_FromCellStyle.getAlignmentEnum());
        i_ToCellStyle.setDataFormat(         i_FromCellStyle.getDataFormat());
        
        // 边框和边框颜色
        i_ToCellStyle.setBorderBottom(       i_FromCellStyle.getBorderBottomEnum());
        i_ToCellStyle.setBorderLeft(         i_FromCellStyle.getBorderLeftEnum());
        i_ToCellStyle.setBorderRight(        i_FromCellStyle.getBorderRightEnum());
        i_ToCellStyle.setBorderTop(          i_FromCellStyle.getBorderTopEnum());
        i_ToCellStyle.setLeftBorderColor(    i_FromCellStyle.getLeftBorderColor());
        i_ToCellStyle.setRightBorderColor(   i_FromCellStyle.getRightBorderColor());
        i_ToCellStyle.setTopBorderColor(     i_FromCellStyle.getTopBorderColor());
        i_ToCellStyle.setBottomBorderColor(  i_FromCellStyle.getBottomBorderColor());
        
        // 背景和前景
        i_ToCellStyle.setFillBackgroundColor(i_FromCellStyle.getFillBackgroundColor());
        i_ToCellStyle.setFillForegroundColor(i_FromCellStyle.getFillForegroundColor());
        i_ToCellStyle.setFillPattern(        i_FromCellStyle.getFillPatternEnum());
        i_ToCellStyle.setHidden(             i_FromCellStyle.getHidden());
        
        // 首行缩进
        i_ToCellStyle.setIndention(          i_FromCellStyle.getIndention());
        i_ToCellStyle.setLocked(             i_FromCellStyle.getLocked());
  
        // 旋转
        i_ToCellStyle.setShrinkToFit(        i_FromCellStyle.getShrinkToFit());
        i_ToCellStyle.setRotation(           i_FromCellStyle.getRotation());
        i_ToCellStyle.setVerticalAlignment(  i_FromCellStyle.getVerticalAlignmentEnum());
        i_ToCellStyle.setWrapText(           i_FromCellStyle.getWrapText());
        */
    }
    else if ( i_FromCellStyle instanceof XSSFCellStyle )
    {
        i_ToCellStyle.cloneStyleFrom(i_FromCellStyle);
    }
}
开发者ID:HY-ZhengWei，项目名称:hy.common.report，代码行数:52，代码来源:ExcelHelp.java


注：本文中的org.apache.poi.ss.usermodel.CellStyle.cloneStyleFrom方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。