Package com.simplicite.util.tools

Class ExcelPOITool

  • @Deprecated(forRemoval=true,
            since="4.0")
public class ExcelPOITool
extends java.lang.Object
    Deprecated, for removal: This API element is subject to removal in a future version.
    Use the ExcelTool class

    • Nested Class Summary

      Nested Classes 
      Modifier and Type Class Description
      class  ExcelPOITool.ExcelCell
      Deprecated, for removal: This API element is subject to removal in a future version. 
      class  ExcelPOITool.ExcelRow
      Deprecated, for removal: This API element is subject to removal in a future version. 
      class  ExcelPOITool.ExcelSheet
      Deprecated, for removal: This API element is subject to removal in a future version. 

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static short COLOR_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Blue
      static short COLOR_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Green
      static short COLOR_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Grey
      static short COLOR_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Red
      static short COLOR_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      White
      static java.lang.String DATE_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date cell blue
      static java.lang.String DATE_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date cell green
      static java.lang.String DATE_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date cell grey
      static java.lang.String DATE_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date cell red
      static java.lang.String DATE_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date cell white
      static java.lang.String DATETIME_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date and time cell blue
      static java.lang.String DATETIME_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date and time cell green
      static java.lang.String DATETIME_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date and time cell grey
      static java.lang.String DATETIME_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date and time cell red
      static java.lang.String DATETIME_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Date and time cell white
      static java.lang.String FORMULA_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula cell blue
      static java.lang.String FORMULA_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula cell green
      static java.lang.String FORMULA_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula cell grey
      static java.lang.String FORMULA_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula cell red
      static java.lang.String FORMULA_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula cell white
      static java.lang.String FORMULA_HEAD_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula head cell grey
      static java.lang.String FORMULA_HEAD_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula head cell white
      static java.lang.String INTEGER_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell blue
      static java.lang.String INTEGER_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell green
      static java.lang.String INTEGER_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell grey
      static java.lang.String INTEGER_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell red
      static java.lang.String INTEGER_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell white
      static java.lang.String INTEGER_CHF_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell blue with CHF sign
      static java.lang.String INTEGER_CHF_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell green with CHF sign
      static java.lang.String INTEGER_CHF_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell grey with CHF sign
      static java.lang.String INTEGER_CHF_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell red with CHF sign
      static java.lang.String INTEGER_CHF_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell white with CHF sign
      static java.lang.String INTEGER_DOLLAR_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell blue with Dollar sign
      static java.lang.String INTEGER_DOLLAR_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell green with Dollar sign
      static java.lang.String INTEGER_DOLLAR_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell grey with Dollar sign
      static java.lang.String INTEGER_DOLLAR_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell red with Dollar sign
      static java.lang.String INTEGER_DOLLAR_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell white with Dollar sign
      static java.lang.String INTEGER_EURO_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell blue with Euro sign
      static java.lang.String INTEGER_EURO_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell green with Euro sign
      static java.lang.String INTEGER_EURO_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell grey with Euro sign
      static java.lang.String INTEGER_EURO_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell red with Euro sign
      static java.lang.String INTEGER_EURO_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Integer cell white with Euro sign
      static java.lang.String NUMERIC_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell blue
      static java.lang.String NUMERIC_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell green
      static java.lang.String NUMERIC_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell grey
      static java.lang.String NUMERIC_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell red
      static java.lang.String NUMERIC_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell white
      static java.lang.String NUMERIC_CHF_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell blue with CHF sign
      static java.lang.String NUMERIC_CHF_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell green with CHF sign
      static java.lang.String NUMERIC_CHF_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell grey with CHF sign
      static java.lang.String NUMERIC_CHF_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell red with CHF sign
      static java.lang.String NUMERIC_CHF_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell white with CHF sign
      static java.lang.String NUMERIC_DOLLAR_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell blue with Dollar sign
      static java.lang.String NUMERIC_DOLLAR_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell green with Dollar sign
      static java.lang.String NUMERIC_DOLLAR_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell grey with Dollar sign
      static java.lang.String NUMERIC_DOLLAR_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell red with Dollar sign
      static java.lang.String NUMERIC_DOLLAR_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell white with Dollar sign
      static java.lang.String NUMERIC_EURO_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell blue with Euro sign
      static java.lang.String NUMERIC_EURO_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell green with Euro sign
      static java.lang.String NUMERIC_EURO_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell grey with Euro sign
      static java.lang.String NUMERIC_EURO_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell red with Euro sign
      static java.lang.String NUMERIC_EURO_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric cell white with Euro sign
      static java.lang.String NUMERIC_HEAD_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric head cell grey
      static java.lang.String NUMERIC_HEAD_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric head cell white
      static java.lang.String STRING_CELL_BLUE
      Deprecated, for removal: This API element is subject to removal in a future version.
      String cell blue
      static java.lang.String STRING_CELL_GREEN
      Deprecated, for removal: This API element is subject to removal in a future version.
      String cell green
      static java.lang.String STRING_CELL_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      String cell grey
      static java.lang.String STRING_CELL_RED
      Deprecated, for removal: This API element is subject to removal in a future version.
      String cell red
      static java.lang.String STRING_CELL_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      String cell white
      static java.lang.String STRING_HEAD_GREY
      Deprecated, for removal: This API element is subject to removal in a future version.
      String head cell grey
      static java.lang.String STRING_HEAD_WHITE
      Deprecated, for removal: This API element is subject to removal in a future version.
      String head cell white
      static org.apache.poi.ss.usermodel.CellType TYPE_FORMULA
      Deprecated, for removal: This API element is subject to removal in a future version.
      Formula type
      static org.apache.poi.ss.usermodel.CellType TYPE_NUMERIC
      Deprecated, for removal: This API element is subject to removal in a future version.
      Numeric type
      static org.apache.poi.ss.usermodel.CellType TYPE_STRING
      Deprecated, for removal: This API element is subject to removal in a future version.
      String type

    • Constructor Summary

      Constructors 
      Constructor Description
      ExcelPOITool()
      Deprecated, for removal: This API element is subject to removal in a future version.
      Use constructor with additional argument
      ExcelPOITool​(boolean openxml)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Constructor (empty workbook)
      ExcelPOITool​(byte[] data)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Use constructor with additional argument
      ExcelPOITool​(byte[] data, boolean openxml)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Constructor (workbook from byte array data)
      ExcelPOITool​(Grant g, DocumentDB doc)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Constructor (workbook from document)
      ExcelPOITool​(java.io.File file)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Constructor (workbook from existing file)
      ExcelPOITool​(java.io.InputStream in)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Use constructor with additional argument
      ExcelPOITool​(java.io.InputStream in, boolean openxml)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Constructor (workbook from input stream)
      ExcelPOITool​(java.lang.String path)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Constructor (workbook from existing file)

    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods 
      Modifier and Type Method Description
      org.apache.poi.ss.usermodel.Sheet add​(ExcelPOITool.ExcelSheet sheet)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Add a sheet
      org.apache.poi.ss.usermodel.Sheet add​(ExcelPOITool.ExcelSheet sheet, int autoSizeColumns, int freezeRows)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Add a sheet to workbook
      void addJPEGPicture​(byte[] data, org.apache.poi.ss.usermodel.Sheet sheet, int row, int col)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Add JPEG picture
      void addPNGPicture​(byte[] data, org.apache.poi.ss.usermodel.Sheet sheet, int row, int col)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Add PNG picture
      void generate​(java.io.OutputStream out)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Generate workbook to specified output stream
      byte[] generateToByteArray()
      Deprecated, for removal: This API element is subject to removal in a future version.
      Generate workbook as byte array
      void generateToFile​(java.lang.String fileName)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Generate workbook to file
      java.lang.String generateToString()
      Deprecated, for removal: This API element is subject to removal in a future version.
      Use other generate methods
      org.apache.poi.ss.usermodel.CellStyle getDateCellStyle​(short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get date cell style
      static org.apache.poi.ss.usermodel.CellStyle getDateCellStyle​(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get date cell style
      org.apache.poi.ss.usermodel.CellStyle getDateTimeCellStyle​(short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get date and time cell style
      static org.apache.poi.ss.usermodel.CellStyle getDateTimeCellStyle​(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get date and time cell style
      org.apache.poi.ss.usermodel.CellStyle getFormulaCellStyle​(short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get date cell style
      static org.apache.poi.ss.usermodel.CellStyle getFormulaCellStyle​(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get formula cell style
      org.apache.poi.ss.usermodel.CellStyle getNumericCellStyle​(short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get string cell style
      static org.apache.poi.ss.usermodel.CellStyle getNumericCellStyle​(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get numeric cell style
      static org.apache.poi.ss.usermodel.CellStyle getNumericCellStyle​(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head, int precision, java.lang.String currency)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get string cell style
      org.apache.poi.ss.usermodel.CellStyle getStringCellStyle​(short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get string cell style
      static org.apache.poi.ss.usermodel.CellStyle getStringCellStyle​(org.apache.poi.ss.usermodel.Workbook wb, short bgcolor, boolean head)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get string cell style
      java.util.Map<java.lang.String,​org.apache.poi.ss.usermodel.CellStyle> getStyles()
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get custom styles
      org.apache.poi.ss.usermodel.Workbook getWorkbook()
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get workbook
      ExcelPOITool.ExcelCell newCell​(int cellIndex, double value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelCell newCell​(int cellIndex, float value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelCell newCell​(int cellIndex, int value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelCell newCell​(int cellIndex, ObjectField field, java.lang.String value)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelCell newCell​(int cellIndex, java.lang.String content)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelCell newCell​(int cellIndex, java.lang.String content, org.apache.poi.ss.usermodel.CellType type)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelCell newCell​(int cellIndex, java.lang.String content, org.apache.poi.ss.usermodel.CellType type, java.lang.String styleName)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelCell newCell​(int cellIndex, java.lang.String content, org.apache.poi.ss.usermodel.CellType type, java.lang.String styleName, ObjectField field)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new cell
      ExcelPOITool.ExcelRow newRow​(int rowIndex)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new row
      ExcelPOITool.ExcelSheet newSheet​(java.lang.String label)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Get new sheet
      void updateFormulas​(org.apache.poi.ss.usermodel.Sheet sheet)
      Deprecated, for removal: This API element is subject to removal in a future version.
      Update formulas in sheet

      • Methods inherited from class java.lang.Object

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

    • Field Detail

      • COLOR_WHITE

        public static final short COLOR_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        White

      • COLOR_BLUE

        public static final short COLOR_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Blue

      • COLOR_RED

        public static final short COLOR_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Red

      • COLOR_GREEN

        public static final short COLOR_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Green

      • COLOR_GREY

        public static final short COLOR_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Grey

      • TYPE_STRING

        public static final org.apache.poi.ss.usermodel.CellType TYPE_STRING
        Deprecated, for removal: This API element is subject to removal in a future version.
        String type

      • TYPE_NUMERIC

        public static final org.apache.poi.ss.usermodel.CellType TYPE_NUMERIC
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric type

      • TYPE_FORMULA

        public static final org.apache.poi.ss.usermodel.CellType TYPE_FORMULA
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula type

      • STRING_HEAD_WHITE

        public static final java.lang.String STRING_HEAD_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        String head cell white
        See Also:
        Constant Field Values

      • STRING_HEAD_GREY

        public static final java.lang.String STRING_HEAD_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        String head cell grey
        See Also:
        Constant Field Values

      • NUMERIC_HEAD_WHITE

        public static final java.lang.String NUMERIC_HEAD_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric head cell white
        See Also:
        Constant Field Values

      • NUMERIC_HEAD_GREY

        public static final java.lang.String NUMERIC_HEAD_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric head cell grey
        See Also:
        Constant Field Values

      • FORMULA_HEAD_WHITE

        public static final java.lang.String FORMULA_HEAD_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula head cell white
        See Also:
        Constant Field Values

      • FORMULA_HEAD_GREY

        public static final java.lang.String FORMULA_HEAD_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula head cell grey
        See Also:
        Constant Field Values

      • STRING_CELL_WHITE

        public static final java.lang.String STRING_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        String cell white
        See Also:
        Constant Field Values

      • STRING_CELL_BLUE

        public static final java.lang.String STRING_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        String cell blue
        See Also:
        Constant Field Values

      • STRING_CELL_RED

        public static final java.lang.String STRING_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        String cell red
        See Also:
        Constant Field Values

      • STRING_CELL_GREEN

        public static final java.lang.String STRING_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        String cell green
        See Also:
        Constant Field Values

      • STRING_CELL_GREY

        public static final java.lang.String STRING_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        String cell grey
        See Also:
        Constant Field Values

      • INTEGER_CELL_WHITE

        public static final java.lang.String INTEGER_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell white
        See Also:
        Constant Field Values

      • INTEGER_CELL_BLUE

        public static final java.lang.String INTEGER_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell blue
        See Also:
        Constant Field Values

      • INTEGER_CELL_RED

        public static final java.lang.String INTEGER_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell red
        See Also:
        Constant Field Values

      • INTEGER_CELL_GREEN

        public static final java.lang.String INTEGER_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell green
        See Also:
        Constant Field Values

      • INTEGER_CELL_GREY

        public static final java.lang.String INTEGER_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell grey
        See Also:
        Constant Field Values

      • INTEGER_EURO_CELL_WHITE

        public static final java.lang.String INTEGER_EURO_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell white with Euro sign
        See Also:
        Constant Field Values

      • INTEGER_EURO_CELL_BLUE

        public static final java.lang.String INTEGER_EURO_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell blue with Euro sign
        See Also:
        Constant Field Values

      • INTEGER_EURO_CELL_RED

        public static final java.lang.String INTEGER_EURO_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell red with Euro sign
        See Also:
        Constant Field Values

      • INTEGER_EURO_CELL_GREEN

        public static final java.lang.String INTEGER_EURO_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell green with Euro sign
        See Also:
        Constant Field Values

      • INTEGER_EURO_CELL_GREY

        public static final java.lang.String INTEGER_EURO_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell grey with Euro sign
        See Also:
        Constant Field Values

      • INTEGER_DOLLAR_CELL_WHITE

        public static final java.lang.String INTEGER_DOLLAR_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell white with Dollar sign
        See Also:
        Constant Field Values

      • INTEGER_DOLLAR_CELL_BLUE

        public static final java.lang.String INTEGER_DOLLAR_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell blue with Dollar sign
        See Also:
        Constant Field Values

      • INTEGER_DOLLAR_CELL_RED

        public static final java.lang.String INTEGER_DOLLAR_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell red with Dollar sign
        See Also:
        Constant Field Values

      • INTEGER_DOLLAR_CELL_GREEN

        public static final java.lang.String INTEGER_DOLLAR_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell green with Dollar sign
        See Also:
        Constant Field Values

      • INTEGER_DOLLAR_CELL_GREY

        public static final java.lang.String INTEGER_DOLLAR_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell grey with Dollar sign
        See Also:
        Constant Field Values

      • INTEGER_CHF_CELL_WHITE

        public static final java.lang.String INTEGER_CHF_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell white with CHF sign
        See Also:
        Constant Field Values

      • INTEGER_CHF_CELL_BLUE

        public static final java.lang.String INTEGER_CHF_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell blue with CHF sign
        See Also:
        Constant Field Values

      • INTEGER_CHF_CELL_RED

        public static final java.lang.String INTEGER_CHF_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell red with CHF sign
        See Also:
        Constant Field Values

      • INTEGER_CHF_CELL_GREEN

        public static final java.lang.String INTEGER_CHF_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell green with CHF sign
        See Also:
        Constant Field Values

      • INTEGER_CHF_CELL_GREY

        public static final java.lang.String INTEGER_CHF_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Integer cell grey with CHF sign
        See Also:
        Constant Field Values

      • NUMERIC_CELL_WHITE

        public static final java.lang.String NUMERIC_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell white
        See Also:
        Constant Field Values

      • NUMERIC_CELL_BLUE

        public static final java.lang.String NUMERIC_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell blue
        See Also:
        Constant Field Values

      • NUMERIC_CELL_RED

        public static final java.lang.String NUMERIC_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell red
        See Also:
        Constant Field Values

      • NUMERIC_CELL_GREEN

        public static final java.lang.String NUMERIC_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell green
        See Also:
        Constant Field Values

      • NUMERIC_CELL_GREY

        public static final java.lang.String NUMERIC_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell grey
        See Also:
        Constant Field Values

      • NUMERIC_EURO_CELL_WHITE

        public static final java.lang.String NUMERIC_EURO_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell white with Euro sign
        See Also:
        Constant Field Values

      • NUMERIC_EURO_CELL_BLUE

        public static final java.lang.String NUMERIC_EURO_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell blue with Euro sign
        See Also:
        Constant Field Values

      • NUMERIC_EURO_CELL_RED

        public static final java.lang.String NUMERIC_EURO_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell red with Euro sign
        See Also:
        Constant Field Values

      • NUMERIC_EURO_CELL_GREEN

        public static final java.lang.String NUMERIC_EURO_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell green with Euro sign
        See Also:
        Constant Field Values

      • NUMERIC_EURO_CELL_GREY

        public static final java.lang.String NUMERIC_EURO_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell grey with Euro sign
        See Also:
        Constant Field Values

      • NUMERIC_DOLLAR_CELL_WHITE

        public static final java.lang.String NUMERIC_DOLLAR_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell white with Dollar sign
        See Also:
        Constant Field Values

      • NUMERIC_DOLLAR_CELL_BLUE

        public static final java.lang.String NUMERIC_DOLLAR_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell blue with Dollar sign
        See Also:
        Constant Field Values

      • NUMERIC_DOLLAR_CELL_RED

        public static final java.lang.String NUMERIC_DOLLAR_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell red with Dollar sign
        See Also:
        Constant Field Values

      • NUMERIC_DOLLAR_CELL_GREEN

        public static final java.lang.String NUMERIC_DOLLAR_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell green with Dollar sign
        See Also:
        Constant Field Values

      • NUMERIC_DOLLAR_CELL_GREY

        public static final java.lang.String NUMERIC_DOLLAR_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell grey with Dollar sign
        See Also:
        Constant Field Values

      • NUMERIC_CHF_CELL_WHITE

        public static final java.lang.String NUMERIC_CHF_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell white with CHF sign
        See Also:
        Constant Field Values

      • NUMERIC_CHF_CELL_BLUE

        public static final java.lang.String NUMERIC_CHF_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell blue with CHF sign
        See Also:
        Constant Field Values

      • NUMERIC_CHF_CELL_RED

        public static final java.lang.String NUMERIC_CHF_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell red with CHF sign
        See Also:
        Constant Field Values

      • NUMERIC_CHF_CELL_GREEN

        public static final java.lang.String NUMERIC_CHF_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell green with CHF sign
        See Also:
        Constant Field Values

      • NUMERIC_CHF_CELL_GREY

        public static final java.lang.String NUMERIC_CHF_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Numeric cell grey with CHF sign
        See Also:
        Constant Field Values

      • FORMULA_CELL_WHITE

        public static final java.lang.String FORMULA_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula cell white
        See Also:
        Constant Field Values

      • FORMULA_CELL_BLUE

        public static final java.lang.String FORMULA_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula cell blue
        See Also:
        Constant Field Values

      • FORMULA_CELL_RED

        public static final java.lang.String FORMULA_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula cell red
        See Also:
        Constant Field Values

      • FORMULA_CELL_GREEN

        public static final java.lang.String FORMULA_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula cell green
        See Also:
        Constant Field Values

      • FORMULA_CELL_GREY

        public static final java.lang.String FORMULA_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Formula cell grey
        See Also:
        Constant Field Values

      • DATE_CELL_WHITE

        public static final java.lang.String DATE_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date cell white
        See Also:
        Constant Field Values

      • DATE_CELL_BLUE

        public static final java.lang.String DATE_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date cell blue
        See Also:
        Constant Field Values

      • DATE_CELL_RED

        public static final java.lang.String DATE_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date cell red
        See Also:
        Constant Field Values

      • DATE_CELL_GREEN

        public static final java.lang.String DATE_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date cell green
        See Also:
        Constant Field Values

      • DATE_CELL_GREY

        public static final java.lang.String DATE_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date cell grey
        See Also:
        Constant Field Values

      • DATETIME_CELL_WHITE

        public static final java.lang.String DATETIME_CELL_WHITE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date and time cell white
        See Also:
        Constant Field Values

      • DATETIME_CELL_BLUE

        public static final java.lang.String DATETIME_CELL_BLUE
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date and time cell blue
        See Also:
        Constant Field Values

      • DATETIME_CELL_RED

        public static final java.lang.String DATETIME_CELL_RED
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date and time cell red
        See Also:
        Constant Field Values

      • DATETIME_CELL_GREEN

        public static final java.lang.String DATETIME_CELL_GREEN
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date and time cell green
        See Also:
        Constant Field Values

      • DATETIME_CELL_GREY

        public static final java.lang.String DATETIME_CELL_GREY
        Deprecated, for removal: This API element is subject to removal in a future version.
        Date and time cell grey
        See Also:
        Constant Field Values

    • Constructor Detail

      • ExcelPOITool

        @Deprecated(forRemoval=true,
            since="4.0")
public ExcelPOITool()
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Use constructor with additional argument
        Throws:
        java.io.IOException

      • ExcelPOITool

        public ExcelPOITool​(boolean openxml)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Constructor (empty workbook)
        Parameters:
        openxml - Use OpenXML format (.xlsx)?
        Throws:
        java.io.IOException

      • ExcelPOITool

        public ExcelPOITool​(java.lang.String path)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Constructor (workbook from existing file)
        Parameters:
        path - File path
        Throws:
        java.io.IOException

      • ExcelPOITool

        public ExcelPOITool​(java.io.File file)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Constructor (workbook from existing file)
        Parameters:
        file - File
        Throws:
        java.io.IOException

      • ExcelPOITool

        @Deprecated(forRemoval=true,
            since="4.0")
public ExcelPOITool​(byte[] data)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Use constructor with additional argument
        Throws:
        java.io.IOException

      • ExcelPOITool

        public ExcelPOITool​(byte[] data,
                    boolean openxml)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Constructor (workbook from byte array data)
        Parameters:
        data - Byte array data
        openxml - Use OpenXML format (.xlsx)?
        Throws:
        java.io.IOException

      • ExcelPOITool

        public ExcelPOITool​(Grant g,
                    DocumentDB doc)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Constructor (workbook from document)
        Parameters:
        g - Grant
        doc - Document
        Throws:
        java.io.IOException

      • ExcelPOITool

        @Deprecated(forRemoval=true,
            since="4.0")
public ExcelPOITool​(java.io.InputStream in)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Use constructor with additional argument
        Throws:
        java.io.IOException

      • ExcelPOITool

        public ExcelPOITool​(java.io.InputStream in,
                    boolean openxml)
             throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Constructor (workbook from input stream)
        Parameters:
        in - Input stream
        openxml - Use OpenXML format (.xlsx)?
        Throws:
        java.io.IOException

    • Method Detail

      • newSheet

        public ExcelPOITool.ExcelSheet newSheet​(java.lang.String label)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new sheet
        Parameters:
        label - Sheet label

      • newRow

        public ExcelPOITool.ExcelRow newRow​(int rowIndex)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new row
        Parameters:
        rowIndex - Row index

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      ObjectField field,
                                      java.lang.String value)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        field - Field
        value - value

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      java.lang.String content)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        content - Cell content
        Returns:
        Cell

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      int value)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        value - Cell integer content
        Returns:
        Cell

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      float value)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        value - Cell float content
        Returns:
        Cell

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      double value)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        value - Cell double content
        Returns:
        Cell

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      java.lang.String content,
                                      org.apache.poi.ss.usermodel.CellType type)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        content - Cell content
        type - Cell type

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      java.lang.String content,
                                      org.apache.poi.ss.usermodel.CellType type,
                                      java.lang.String styleName)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        content - Cell content
        type - Cell type
        styleName - Cell style name
        Returns:
        Cell

      • newCell

        public ExcelPOITool.ExcelCell newCell​(int cellIndex,
                                      java.lang.String content,
                                      org.apache.poi.ss.usermodel.CellType type,
                                      java.lang.String styleName,
                                      ObjectField field)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get new cell
        Parameters:
        cellIndex - Cell index
        content - Cell content
        type - Cell type
        styleName - Cell style name
        field - Field
        Returns:
        Cell

      • getStringCellStyle

        public static org.apache.poi.ss.usermodel.CellStyle getStringCellStyle​(org.apache.poi.ss.usermodel.Workbook wb,
                                                                       short bgcolor,
                                                                       boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get string cell style
        Parameters:
        wb - Workbook
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getStringCellStyle

        public org.apache.poi.ss.usermodel.CellStyle getStringCellStyle​(short bgcolor,
                                                                boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get string cell style
        Parameters:
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getNumericCellStyle

        public static org.apache.poi.ss.usermodel.CellStyle getNumericCellStyle​(org.apache.poi.ss.usermodel.Workbook wb,
                                                                        short bgcolor,
                                                                        boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get numeric cell style
        Parameters:
        wb - Workbook
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getNumericCellStyle

        public static org.apache.poi.ss.usermodel.CellStyle getNumericCellStyle​(org.apache.poi.ss.usermodel.Workbook wb,
                                                                        short bgcolor,
                                                                        boolean head,
                                                                        int precision,
                                                                        java.lang.String currency)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get string cell style
        Parameters:
        wb - Workbook
        bgcolor - Background color
        head - Head?
        precision - Precision
        currency - Currency
        Returns:
        Cell style

      • getNumericCellStyle

        public org.apache.poi.ss.usermodel.CellStyle getNumericCellStyle​(short bgcolor,
                                                                 boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get string cell style
        Parameters:
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getDateCellStyle

        public static org.apache.poi.ss.usermodel.CellStyle getDateCellStyle​(org.apache.poi.ss.usermodel.Workbook wb,
                                                                     short bgcolor,
                                                                     boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get date cell style
        Parameters:
        wb - Workbook
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getDateCellStyle

        public org.apache.poi.ss.usermodel.CellStyle getDateCellStyle​(short bgcolor,
                                                              boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get date cell style
        Parameters:
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getDateTimeCellStyle

        public static org.apache.poi.ss.usermodel.CellStyle getDateTimeCellStyle​(org.apache.poi.ss.usermodel.Workbook wb,
                                                                         short bgcolor,
                                                                         boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get date and time cell style
        Parameters:
        wb - Workbook
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getDateTimeCellStyle

        public org.apache.poi.ss.usermodel.CellStyle getDateTimeCellStyle​(short bgcolor,
                                                                  boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get date and time cell style
        Parameters:
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getFormulaCellStyle

        public static org.apache.poi.ss.usermodel.CellStyle getFormulaCellStyle​(org.apache.poi.ss.usermodel.Workbook wb,
                                                                        short bgcolor,
                                                                        boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get formula cell style
        Parameters:
        wb - Workbook
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getFormulaCellStyle

        public org.apache.poi.ss.usermodel.CellStyle getFormulaCellStyle​(short bgcolor,
                                                                 boolean head)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get date cell style
        Parameters:
        bgcolor - Backgroynd color
        head - Head?
        Returns:
        Cell style

      • getWorkbook

        public org.apache.poi.ss.usermodel.Workbook getWorkbook()
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get workbook
        Returns:
        POI workbook

      • getStyles

        public java.util.Map<java.lang.String,​org.apache.poi.ss.usermodel.CellStyle> getStyles()
        Deprecated, for removal: This API element is subject to removal in a future version.
        Get custom styles
        Returns:
        Styles map

      • add

        public org.apache.poi.ss.usermodel.Sheet add​(ExcelPOITool.ExcelSheet sheet)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Add a sheet
        Parameters:
        sheet - Sheet
        Returns:
        POI sheet

      • add

        public org.apache.poi.ss.usermodel.Sheet add​(ExcelPOITool.ExcelSheet sheet,
                                             int autoSizeColumns,
                                             int freezeRows)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Add a sheet to workbook
        Parameters:
        sheet - Sheet
        autoSizeColumns - Auto size columns
        freezeRows - Number of top rows to freeze
        Returns:
        POI sheet

      • addJPEGPicture

        public void addJPEGPicture​(byte[] data,
                           org.apache.poi.ss.usermodel.Sheet sheet,
                           int row,
                           int col)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Add JPEG picture
        Parameters:
        data - Picture data
        sheet - Sheet
        row - Row
        col - Column

      • addPNGPicture

        public void addPNGPicture​(byte[] data,
                          org.apache.poi.ss.usermodel.Sheet sheet,
                          int row,
                          int col)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Add PNG picture
        Parameters:
        data - Picture data
        sheet - Sheet
        row - Row
        col - Column

      • generateToString

        @Deprecated(forRemoval=true,
            since="4.0")
public java.lang.String generateToString()
                                  throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Use other generate methods
        Throws:
        java.io.IOException

      • generateToByteArray

        public byte[] generateToByteArray()
                           throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Generate workbook as byte array
        Returns:
        Byte array
        Throws:
        java.io.IOException - If generation fails

      • generateToFile

        public void generateToFile​(java.lang.String fileName)
                    throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Generate workbook to file
        Parameters:
        fileName - File name
        Throws:
        java.io.IOException - If generation fails

      • generate

        public void generate​(java.io.OutputStream out)
              throws java.io.IOException
        Deprecated, for removal: This API element is subject to removal in a future version.
        Generate workbook to specified output stream
        Parameters:
        out - Output stream
        Throws:
        java.io.IOException - If generation fails

      • updateFormulas

        public void updateFormulas​(org.apache.poi.ss.usermodel.Sheet sheet)
        Deprecated, for removal: This API element is subject to removal in a future version.
        Update formulas in sheet
        Parameters:
        sheet - Sheet