Package com.netlang.excel

Class ExcelSheet

java.lang.Object
com.netlang.excel.ExcelSheet
public class ExcelSheet extends Object
The ExcelSheet class

  • Constructor Summary

    Constructors
    Constructor
    Description
    ExcelSheet(com.intellus.xls.XLSSheet sheet)
    Initializes a newly created ExcelSheet

  • Method Summary

    Modifier and Type
    Method
    Description
    String
    get(int row, int column)
     
    String
    get(int row, String column)
     
    boolean
    getBoolean(int row, int column)
     
    boolean
    getBoolean(int row, String column)
     
    Date
    getDate(int row, int column)
     
    Date
    getDate(int row, String column)
     
    double
    getDouble(int row, int column)
     
    double
    getDouble(int row, String column)
     
    com.intellus.util.IDate
    getIDate(int row, int column)
     
    com.intellus.util.IDate
    getIDate(int row, String column)
     
    int
    getLastColumn(int row)
     
    int
    getLastRow()
     
    long
    getLong(int row, int column)
     
    long
    getLong(int row, String column)
     
    org.apache.poi.ss.usermodel.Sheet
    getSheet()
     
    void
    insertRows(int insertAtRow, int numRowsToInsert)
     
    boolean
    isEmpty(int row)
     
    void
    removeAllRows()
     
    void
    removeRows(int startRow, int endRow)
     
    int
    search(int startRow, int column, String data, boolean caseSensitive)
     
    int
    search(int startRow, String column, String data, boolean caseSensitive)
     
    void
    set(int row, int column, boolean value)
     
    void
    set(int row, int column, double value)
     
    void
    set(int row, int column, String value)
     
    void
    set(int row, int column, Date value)
     
    void
    set(int row, String column, boolean value)
     
    void
    set(int row, String column, double value)
     
    void
    set(int row, String column, String value)
     
    void
    set(int row, String column, BigDecimal value)
     
    void
    set(int row, String column, Date value)
     
    void
    setAlignment(int row, int cell, org.apache.poi.ss.usermodel.HorizontalAlignment align)
     
    void
    setBackground(int row, int cell, int fgColor, org.apache.poi.ss.usermodel.FillPatternType fgPattern)
     
    void
    setBoolean(int row, int column, boolean value)
     
    void
    setCellBackground(int row, int cell, int bgColor, org.apache.poi.ss.usermodel.FillPatternType bgPattern)
     
    void
    setCellBackground(int row, int cell, org.apache.poi.ss.usermodel.IndexedColors bgColor, org.apache.poi.ss.usermodel.FillPatternType bgPattern)
     
    void
    setCellBorderStyle(int row, int column, boolean right, boolean left, boolean top, boolean bottom, int borderColor, org.apache.poi.ss.usermodel.BorderStyle border)
     
    void
    setCellForeground(int row, int cell, int fgColor)
     
    void
    setCellForeground(int row, int cell, org.apache.poi.ss.usermodel.IndexedColors fgColor)
     
    void
    setColumnWidth(int column, int width)
     
    void
    setDate(int row, int column, Date value)
     
    void
    setDouble(int row, int column, double value)
     
    void
    setFont(int row, int cell, String font, int size, int color)
     
    void
    setFont(int row, int cell, String font, int size, org.apache.poi.ss.usermodel.IndexedColors color)
     
    void
    setRowHeight(int row, float height)
     

    Methods inherited from class java.lang.Object

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

  • Constructor Details

    • ExcelSheet

      public ExcelSheet(com.intellus.xls.XLSSheet sheet)
      Initializes a newly created ExcelSheet

  • Method Details

    • setRowHeight

      public void setRowHeight(int row, float height) throws Exception
      Throws:
      Exception

    • setColumnWidth

      public void setColumnWidth(int column, int width) throws Exception
      Throws:
      Exception

    • setBackground

      public void setBackground(int row, int cell, int fgColor, org.apache.poi.ss.usermodel.FillPatternType fgPattern) throws Exception
      Throws:
      Exception

    • setCellBorderStyle

      public void setCellBorderStyle(int row, int column, boolean right, boolean left, boolean top, boolean bottom, int borderColor, org.apache.poi.ss.usermodel.BorderStyle border) throws Exception
      Throws:
      Exception

    • setCellBackground

      public void setCellBackground(int row, int cell, org.apache.poi.ss.usermodel.IndexedColors bgColor, org.apache.poi.ss.usermodel.FillPatternType bgPattern) throws Exception
      Throws:
      Exception

    • setCellBackground

      public void setCellBackground(int row, int cell, int bgColor, org.apache.poi.ss.usermodel.FillPatternType bgPattern) throws Exception
      Throws:
      Exception

    • setCellForeground

      public void setCellForeground(int row, int cell, org.apache.poi.ss.usermodel.IndexedColors fgColor) throws Exception
      Throws:
      Exception

    • setCellForeground

      public void setCellForeground(int row, int cell, int fgColor) throws Exception
      Throws:
      Exception

    • setFont

      public void setFont(int row, int cell, String font, int size, int color) throws Exception
      Throws:
      Exception

    • setFont

      public void setFont(int row, int cell, String font, int size, org.apache.poi.ss.usermodel.IndexedColors color) throws Exception
      Throws:
      Exception

    • setAlignment

      public void setAlignment(int row, int cell, org.apache.poi.ss.usermodel.HorizontalAlignment align) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, int column, String value) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, int column, double value) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, int column, Date value) throws Exception
      Parameters:
      row -
      column -
      value -
      Throws:
      Exception

    • set

      public void set(int row, int column, boolean value) throws Exception
      Throws:
      Exception

    • setDouble

      public void setDouble(int row, int column, double value) throws Exception
      Throws:
      Exception

    • setDate

      public void setDate(int row, int column, Date value) throws Exception
      Throws:
      Exception

    • setBoolean

      public void setBoolean(int row, int column, boolean value) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, String column, String value) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, String column, BigDecimal value) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, String column, double value) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, String column, Date value) throws Exception
      Throws:
      Exception

    • set

      public void set(int row, String column, boolean value) throws Exception
      Throws:
      Exception

    • insertRows

      public void insertRows(int insertAtRow, int numRowsToInsert) throws Exception
      Throws:
      Exception

    • removeRows

      public void removeRows(int startRow, int endRow) throws Exception
      Throws:
      Exception

    • removeAllRows

      public void removeAllRows() throws Exception
      Throws:
      Exception

    • getDouble

      public double getDouble(int row, String column) throws Exception
      Throws:
      Exception

    • getDouble

      public double getDouble(int row, int column) throws Exception
      Throws:
      Exception

    • getLong

      public long getLong(int row, String column) throws Exception
      Throws:
      Exception

    • getLong

      public long getLong(int row, int column) throws Exception
      Throws:
      Exception

    • getBoolean

      public boolean getBoolean(int row, String column) throws Exception
      Throws:
      Exception

    • getBoolean

      public boolean getBoolean(int row, int column) throws Exception
      Throws:
      Exception

    • getIDate

      public com.intellus.util.IDate getIDate(int row, String column) throws Exception
      Throws:
      Exception

    • getIDate

      public com.intellus.util.IDate getIDate(int row, int column) throws Exception
      Throws:
      Exception

    • getDate

      public Date getDate(int row, String column) throws Exception
      Throws:
      Exception

    • getDate

      public Date getDate(int row, int column) throws Exception
      Throws:
      Exception

    • search

      public int search(int startRow, String column, String data, boolean caseSensitive) throws Exception
      Throws:
      Exception

    • search

      public int search(int startRow, int column, String data, boolean caseSensitive) throws Exception
      Throws:
      Exception

    • getLastRow

      public int getLastRow() throws Exception
      Throws:
      Exception

    • isEmpty

      public boolean isEmpty(int row) throws Exception
      Throws:
      Exception

    • get

      public String get(int row, String column) throws Exception
      Throws:
      Exception

    • get

      public String get(int row, int column) throws Exception
      Throws:
      Exception

    • getLastColumn

      public int getLastColumn(int row)

    • getSheet

      public org.apache.poi.ss.usermodel.Sheet getSheet()