Package cn.net.pap.common.excel.handle

Class ImageModifyHandler2

java.lang.Object
cn.net.pap.common.excel.handle.ImageModifyHandler2
All Implemented Interfaces:
com.alibaba.excel.event.Handler, com.alibaba.excel.event.Order, com.alibaba.excel.write.handler.CellWriteHandler, com.alibaba.excel.write.handler.WriteHandler
public class ImageModifyHandler2 extends Object implements com.alibaba.excel.write.handler.CellWriteHandler

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    static Float
    character2PixelFactor
     
    static Integer
    dpi
     
    static Integer
    pixel2InchFactor
     
    static Float
    rowHeight2PixelFactor
     
    static Integer
    standardCharacterWidth
     

  • Constructor Summary

    Constructors
    Constructor
    Description
    ImageModifyHandler2()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    afterCellDataConverted(com.alibaba.excel.write.metadata.holder.WriteSheetHolder writeSheetHolder, com.alibaba.excel.write.metadata.holder.WriteTableHolder writeTableHolder, com.alibaba.excel.metadata.data.WriteCellData<?> cellData, org.apache.poi.ss.usermodel.Cell cell, com.alibaba.excel.metadata.Head head, Integer relativeRowIndex, Boolean isHead)
    后单元格数据转换
    static org.apache.poi.ss.util.CellRangeAddress
    getMergedRegion(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.Sheet sheet)
     

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    Methods inherited from interface com.alibaba.excel.write.handler.CellWriteHandler

    afterCellCreate, afterCellCreate, afterCellDataConverted, afterCellDispose, afterCellDispose, beforeCellCreate, beforeCellCreate

    Methods inherited from interface com.alibaba.excel.event.Handler

    order

  • Field Details

    • standardCharacterWidth

      public static Integer standardCharacterWidth

    • character2PixelFactor

      public static Float character2PixelFactor

    • pixel2InchFactor

      public static Integer pixel2InchFactor

    • dpi

      public static Integer dpi

    • rowHeight2PixelFactor

      public static Float rowHeight2PixelFactor

  • Constructor Details

    • ImageModifyHandler2

      public ImageModifyHandler2()

  • Method Details

    • afterCellDataConverted

      public void afterCellDataConverted(com.alibaba.excel.write.metadata.holder.WriteSheetHolder writeSheetHolder, com.alibaba.excel.write.metadata.holder.WriteTableHolder writeTableHolder, com.alibaba.excel.metadata.data.WriteCellData<?> cellData, org.apache.poi.ss.usermodel.Cell cell, com.alibaba.excel.metadata.Head head, Integer relativeRowIndex, Boolean isHead)
      后单元格数据转换
      Specified by:
      afterCellDataConverted in interface com.alibaba.excel.write.handler.CellWriteHandler
      Parameters:
      writeSheetHolder - 写单夹
      writeTableHolder - 写表夹
      cellData - 单元格数据
      cell - 细胞
      head - 头
      relativeRowIndex - 相对行索引
      isHead - 是头

    • getMergedRegion

      public static org.apache.poi.ss.util.CellRangeAddress getMergedRegion(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.Sheet sheet)