Examples with HorizontalCellStyleStrategy - com.alibaba.excel.write.style.HorizontalCellStyleStrategy

Example 1 with HorizontalCellStyleStrategy

use of com.alibaba.excel.write.style.HorizontalCellStyleStrategy in project easyexcel by alibaba.

the class WriteV34Test method test.

@Test
public void test() throws Exception {
    String fileName = TestFileUtil.getPath() + "handlerStyleWrite" + System.currentTimeMillis() + ".xlsx";
    // 头的策略
    WriteCellStyle headWriteCellStyle = new WriteCellStyle();
    // 背景设置为红色
    headWriteCellStyle.setFillForegroundColor(IndexedColors.RED.getIndex());
    WriteFont headWriteFont = new WriteFont();
    headWriteFont.setFontHeightInPoints((short) 20);
    headWriteCellStyle.setWriteFont(headWriteFont);
    // 内容的策略
    WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
    // 这里需要指定 FillPatternType 为FillPatternType.SOLID_FOREGROUND 不然无法显示背景颜色.头默认了 FillPatternType所以可以不指定
    contentWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
    // 背景绿色
    contentWriteCellStyle.setFillForegroundColor(IndexedColors.GREEN.getIndex());
    WriteFont contentWriteFont = new WriteFont();
    // 字体大小
    contentWriteFont.setFontHeightInPoints((short) 20);
    contentWriteCellStyle.setWriteFont(contentWriteFont);
    // 这个策略是 头是头的样式 内容是内容的样式 其他的策略可以自己实现
    HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);
    // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
    EasyExcel.write(fileName, DemoData.class).head(head()).registerWriteHandler(horizontalCellStyleStrategy).sheet("模板").doWrite(data(1));
}

Also used : WriteCellStyle(com.alibaba.excel.write.metadata.style.WriteCellStyle) WriteFont(com.alibaba.excel.write.metadata.style.WriteFont) HorizontalCellStyleStrategy(com.alibaba.excel.write.style.HorizontalCellStyleStrategy) Test(org.junit.Test)

Example 2 with HorizontalCellStyleStrategy

use of com.alibaba.excel.write.style.HorizontalCellStyleStrategy in project charon by harvies.

the class ConverterTest method main.

public static void main(String[] args) {
    List<Head> list = new ArrayList<>();
    Head head = new Head();
    // head.setA("aaa");
    head.setB(Arrays.asList("ccccccccc", "dddddddd", "ccccccccc", "dddddddd", "ccccccccc", "dddddddd", "ccccccccc", "dddddddd"));
    head.setC(Arrays.asList(111111111, 1222222222, 1222222222, 1222222222, 1222222222, 1222222222, 1222222222));
    head.setD(true);
    list.add(head);
    // 头的策略
    WriteCellStyle headWriteCellStyle = new WriteCellStyle();
    // 背景设置为红色
    // headWriteCellStyle.setFillForegroundColor(IndexedColors.ORANGE.getIndex());
    // WriteFont headWriteFont = new WriteFont();
    // headWriteFont.setFontHeightInPoints((short) 20);
    // headWriteCellStyle.setWriteFont(headWriteFont);
    // 内容的策略
    WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
    // 这里需要指定 FillPatternType 为FillPatternType.SOLID_FOREGROUND 不然无法显示背景颜色.头默认了 FillPatternType所以可以不指定
    // contentWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
    // // 背景绿色
    // contentWriteCellStyle.setFillForegroundColor(IndexedColors.GREEN.getIndex());
    // WriteFont contentWriteFont = new WriteFont();
    // // 字体大小
    // contentWriteFont.setFontHeightInPoints((short) 20);
    // contentWriteCellStyle.setWriteFont(contentWriteFont);
    // 单元格不溢出
    // contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.FILL);
    HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);
    ExcelWriter excelWriter = EasyExcelFactory.write(FileUtils.getCurrentUserHomePath() + "/Downloads/test_write.xlsx").head(Head.class).registerWriteHandler(horizontalCellStyleStrategy).build();
    WriteSheet writeSheet = new WriteSheet();
    writeSheet.setSheetNo(0);
    writeSheet.setSheetName("工作表1");
    excelWriter.write(list, writeSheet);
    excelWriter.finish();
}

Also used : WriteCellStyle(com.alibaba.excel.write.metadata.style.WriteCellStyle) ExcelWriter(com.alibaba.excel.ExcelWriter) ArrayList(java.util.ArrayList) WriteSheet(com.alibaba.excel.write.metadata.WriteSheet) HorizontalCellStyleStrategy(com.alibaba.excel.write.style.HorizontalCellStyleStrategy)

Example 3 with HorizontalCellStyleStrategy

use of com.alibaba.excel.write.style.HorizontalCellStyleStrategy in project study by bage2014.

the class WriteTest method styleWrite.

/**
 * 自定义样式
 * <p>
 * 1. 创建excel对应的实体对象 参照{@link DemoData}
 * <p>
 * 2. 创建一个style策略 并注册
 * <p>
 * 3. 直接写即可
 */
@Test
public void styleWrite() {
    String fileName = TestFileUtil.getPath() + "styleWrite" + System.currentTimeMillis() + ".xlsx";
    // 头的策略
    WriteCellStyle headWriteCellStyle = new WriteCellStyle();
    // 背景设置为红色
    headWriteCellStyle.setFillForegroundColor(IndexedColors.RED.getIndex());
    WriteFont headWriteFont = new WriteFont();
    headWriteFont.setFontHeightInPoints((short) 20);
    headWriteCellStyle.setWriteFont(headWriteFont);
    // 内容的策略
    WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
    // 这里需要指定 FillPatternType 为FillPatternType.SOLID_FOREGROUND 不然无法显示背景颜色.头默认了 FillPatternType所以可以不指定
    contentWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
    // 背景绿色
    contentWriteCellStyle.setFillForegroundColor(IndexedColors.GREEN.getIndex());
    WriteFont contentWriteFont = new WriteFont();
    // 字体大小
    contentWriteFont.setFontHeightInPoints((short) 20);
    contentWriteCellStyle.setWriteFont(contentWriteFont);
    // 这个策略是 头是头的样式 内容是内容的样式 其他的策略可以自己实现
    HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);
    // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
    EasyExcel.write(fileName, DemoData.class).registerWriteHandler(horizontalCellStyleStrategy).sheet("模板").doWrite(data());
}

Example 4 with HorizontalCellStyleStrategy

use of com.alibaba.excel.write.style.HorizontalCellStyleStrategy in project mybatch by mywill26.

the class GeneralExcelWriter method getStrategy.

public static HorizontalCellStyleStrategy getStrategy() {
    WriteCellStyle cellStyle = new WriteCellStyle();
    cellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());
    WriteFont writeFont = new WriteFont();
    writeFont.setFontHeightInPoints((short) 10);
    writeFont.setBold(true);
    cellStyle.setWriteFont(writeFont);
    return new HorizontalCellStyleStrategy(cellStyle, new WriteCellStyle());
}

Example 5 with HorizontalCellStyleStrategy

use of com.alibaba.excel.write.style.HorizontalCellStyleStrategy in project personManage by WHUTdk.

the class EasyexcelUtil method setDefaultCellStyle.

private static HorizontalCellStyleStrategy setDefaultCellStyle() {
    // 头的策略
    WriteCellStyle headWriteCellStyle = new WriteCellStyle();
    // 背景设置为红色
    headWriteCellStyle.setFillForegroundColor(IndexedColors.RED.getIndex());
    WriteFont headWriteFont = new WriteFont();
    headWriteFont.setFontHeightInPoints((short) 12);
    headWriteCellStyle.setWriteFont(headWriteFont);
    // 内容的策略
    WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
    HSSFDataFormat dataFormat = new HSSFWorkbook().createDataFormat();
    // 本文格式
    contentWriteCellStyle.setDataFormat(dataFormat.getFormat("@"));
    contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
    contentWriteCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
    // 填充类型 这里需要指定 FillPatternType 为FillPatternType.SOLID_FOREGROUND 不然无法显示背景颜色.头默认了 FillPatternType所以可以不指定
    // contentWriteCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
    // 背景绿色
    // contentWriteCellStyle.setFillForegroundColor(IndexedColors.GREEN.getIndex());
    WriteFont contentWriteFont = new WriteFont();
    // 字体大小
    contentWriteFont.setFontHeightInPoints((short) 12);
    contentWriteCellStyle.setWriteFont(contentWriteFont);
    // 这个策略是 头是头的样式 内容是内容的样式 其他的策略可以自己实现
    return new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);
}

Also used : WriteCellStyle(com.alibaba.excel.write.metadata.style.WriteCellStyle) WriteFont(com.alibaba.excel.write.metadata.style.WriteFont) HSSFDataFormat(org.apache.poi.hssf.usermodel.HSSFDataFormat) HSSFWorkbook(org.apache.poi.hssf.usermodel.HSSFWorkbook) HorizontalCellStyleStrategy(com.alibaba.excel.write.style.HorizontalCellStyleStrategy)

Aggregations

WriteCellStyle (com.alibaba.excel.write.metadata.style.WriteCellStyle)10 HorizontalCellStyleStrategy (com.alibaba.excel.write.style.HorizontalCellStyleStrategy)10 WriteFont (com.alibaba.excel.write.metadata.style.WriteFont)8 Test (org.junit.Test)5 ExcelWriter (com.alibaba.excel.ExcelWriter)2 WriteSheet (com.alibaba.excel.write.metadata.WriteSheet)2 Cell (org.apache.poi.ss.usermodel.Cell)2 Workbook (org.apache.poi.ss.usermodel.Workbook)2 DemoData (com.alibaba.easyexcel.test.demo.write.DemoData)1 WriteCellData (com.alibaba.excel.metadata.data.WriteCellData)1 CellWriteHandler (com.alibaba.excel.write.handler.CellWriteHandler)1 CellWriteHandlerContext (com.alibaba.excel.write.handler.context.CellWriteHandlerContext)1 OnceAbsoluteMergeStrategy (com.alibaba.excel.write.merge.OnceAbsoluteMergeStrategy)1 SimpleColumnWidthStyleStrategy (com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy)1 SimpleRowHeightStyleStrategy (com.alibaba.excel.write.style.row.SimpleRowHeightStyleStrategy)1 ExcelException (io.metersphere.exception.ExcelException)1 IOException (java.io.IOException)1 UnsupportedEncodingException (java.io.UnsupportedEncodingException)1 ArrayList (java.util.ArrayList)1 HSSFDataFormat (org.apache.poi.hssf.usermodel.HSSFDataFormat)1