Package org.jzy3d.io.xls

Interface IExcelBuilder

All Known Implementing Classes:
ExcelBuilder, ExcelBuilderMultiSheet
public interface IExcelBuilder

  • Method Summary

    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 Details

    • 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)

    • save

      void save(String file) throws IOException
      Throws:
      IOException

    • save

      void save(File file) throws IOException
      Throws:
      IOException

    • 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)

    • loadPicture

      int loadPicture(String image) throws IOException
      Throws:
      IOException

    • setPicture

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