Package org.jzy3d.io.xls

Interface IExcelBuilder

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      org.apache.poi.ss.usermodel.Comment addComment​(org.apache.poi.ss.usermodel.Cell cell, String text, int row, int col, int colWidth, int rowHeight)  
      Collection<org.apache.poi.ss.usermodel.Sheet> getAllSheets()  
      org.apache.poi.ss.usermodel.Font getBoldFont()  
      org.apache.poi.hssf.util.HSSFColor getColor​(ByteColor color)  
      org.apache.poi.ss.usermodel.Sheet getCurrentSheet()  
      int getCurrentSheetId()  
      org.apache.poi.ss.usermodel.Workbook getWorkbook()  
      int loadPicture​(String image)  
      void mergeRange​(int firstRow, int firstColumn, int lastRow, int lastColumn)  
      org.apache.poi.ss.usermodel.CellStyle newCellStyle()  
      org.apache.poi.ss.usermodel.CellStyle newColoredCellStyle​(org.apache.poi.ss.usermodel.IndexedColors color)  
      org.apache.poi.ss.usermodel.CellStyle newColoredCellStyle​(ByteColor color)  
      org.apache.poi.ss.usermodel.Font newFont​(int size)  
      int newSheet​(int index, String name)  
      void save​(File file)  
      void save​(String file)  
      org.apache.poi.ss.usermodel.Cell setCell​(int row, int column, double value)  
      org.apache.poi.ss.usermodel.Cell setCell​(int row, int column, double value, org.apache.poi.ss.usermodel.CellStyle style)  
      org.apache.poi.ss.usermodel.Cell setCell​(int row, int column, String content)
      Set a cell text content with no styling information.
      org.apache.poi.ss.usermodel.Cell setCell​(int row, int column, String content, org.apache.poi.ss.usermodel.CellStyle style)
      Set a cell content at the given indices, and apply the style if it is not null.
      org.apache.poi.ss.usermodel.Cell setCellFormula​(int row, int column, String formula)  
      void setColumnWidth​(int column, int width)
      Set the width (in units of 1/256th of a character width)
      void setColumnWidthAuto​(int column)  
      void setCurrentSheetId​(int s)  
      void setFreezePane​(int colSplit, int rowSplit)  
      void setFreezePane​(int colSplit, int rowSplit, int leftmostColumn, int topRow)  
      void setPicture​(int pictureIdx, int col1, int row1, boolean resize)  
      void setRowHeight​(int row, int height)  
      void setSplitPane​(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, int activePane)  

    • Method Detail

      • setCell

        org.apache.poi.ss.usermodel.Cell setCell​(int row,
                                         int column,
                                         String content,
                                         org.apache.poi.ss.usermodel.CellStyle style)
        Set a cell content at the given indices, and apply the style if it is not null. If row(i) does not exist yet, it is created, otherwise it is recycled. If cell(i,j) does not exist yet, it is created, otherwise it is recycled. Reminder: excel support a maximum of 65,536 rows and 256 columns per sheet
        Parameters:
        row - row index
        column - column index
        content - a string to display in the cell
        style - a style to apply to the cell
        Returns:
        the created or retrieved cell in case additional stuff should be done on it.

      • setCell

        org.apache.poi.ss.usermodel.Cell setCell​(int row,
                                         int column,
                                         String content)
        Set a cell text content with no styling information.

      • setCellFormula

        org.apache.poi.ss.usermodel.Cell setCellFormula​(int row,
                                                int column,
                                                String formula)

      • setCell

        org.apache.poi.ss.usermodel.Cell setCell​(int row,
                                         int column,
                                         double value)

      • setCell

        org.apache.poi.ss.usermodel.Cell setCell​(int row,
                                         int column,
                                         double value,
                                         org.apache.poi.ss.usermodel.CellStyle style)

      • getCurrentSheet

        org.apache.poi.ss.usermodel.Sheet getCurrentSheet()

      • getAllSheets

        Collection<org.apache.poi.ss.usermodel.Sheet> getAllSheets()

      • getCurrentSheetId

        int getCurrentSheetId()

      • setCurrentSheetId

        void setCurrentSheetId​(int s)

      • newSheet

        int newSheet​(int index,
             String name)

      • setRowHeight

        void setRowHeight​(int row,
                  int height)

      • setColumnWidth

        void setColumnWidth​(int column,
                    int width)
        Set the width (in units of 1/256th of a character width)

      • setColumnWidthAuto

        void setColumnWidthAuto​(int column)

      • setFreezePane

        void setFreezePane​(int colSplit,
                   int rowSplit)

      • setFreezePane

        void setFreezePane​(int colSplit,
                   int rowSplit,
                   int leftmostColumn,
                   int topRow)

      • setSplitPane

        void setSplitPane​(int xSplitPos,
                  int ySplitPos,
                  int leftmostColumn,
                  int topRow,
                  int activePane)

      • mergeRange

        void mergeRange​(int firstRow,
                int firstColumn,
                int lastRow,
                int lastColumn)

      • addComment

        org.apache.poi.ss.usermodel.Comment addComment​(org.apache.poi.ss.usermodel.Cell cell,
                                               String text,
                                               int row,
                                               int col,
                                               int colWidth,
                                               int rowHeight)

      • newColoredCellStyle

        org.apache.poi.ss.usermodel.CellStyle newColoredCellStyle​(ByteColor color)

      • newColoredCellStyle

        org.apache.poi.ss.usermodel.CellStyle newColoredCellStyle​(org.apache.poi.ss.usermodel.IndexedColors color)

      • newFont

        org.apache.poi.ss.usermodel.Font newFont​(int size)

      • getBoldFont

        org.apache.poi.ss.usermodel.Font getBoldFont()

      • newCellStyle

        org.apache.poi.ss.usermodel.CellStyle newCellStyle()

      • getWorkbook

        org.apache.poi.ss.usermodel.Workbook getWorkbook()

      • getColor

        org.apache.poi.hssf.util.HSSFColor getColor​(ByteColor color)

      • setPicture

        void setPicture​(int pictureIdx,
                int col1,
                int row1,
                boolean resize)