Package com.nuix.superutilities.reporting

Class SimpleWorksheet

  • public class SimpleWorksheet
extends java.lang.Object
    Wrapper class around Aspose Cells Worksheet object which simplifies some of the more common operations.

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      void appendRow​(java.util.List<? extends java.lang.Object> rowValues)  
      void appendRow​(java.util.List<java.lang.Object> rowValues, com.aspose.cells.Style defaultStyle)  
      void autoFitColumns()  
      void autoFitRow​(int row)  
      void eachCell​(int startRow, int endRow, int startCol, int endCol, java.util.function.Consumer<com.aspose.cells.Cell> activity)  
      com.aspose.cells.Worksheet getAsposeWorksheet()
      Gets the underlying Aspose Cells Worksheet object.
      com.aspose.cells.Cell getCell​(int row, int col)
      Gets a particular Cell object from this work sheet.
      int getCurrentRow()  
      com.aspose.cells.Style getStyle​(int row, int col)
      Gets the style of a particular cell in this work sheet
      java.lang.Object getValue​(int row, int col)
      Gets the value of a particular cell in this work sheet
      void mergeCols​(int row, int col, int colCount)
      Merges a series of cells horizontally
      void setCurrentRow​(int currentRow)  
      void setStyle​(int row, int col, com.aspose.cells.Style style)
      Sets the style of of a particular cell in this work sheet
      void setValue​(int row, int col, java.lang.Object value)
      Sets the value of a particular cell in this work sheet

      • Methods inherited from class java.lang.Object

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

    • Method Detail

      • getAsposeWorksheet

        public com.aspose.cells.Worksheet getAsposeWorksheet()
        Gets the underlying Aspose Cells Worksheet object.
        Returns:
        The underlying Aspose Cells Worksheet object.

      • getCell

        public com.aspose.cells.Cell getCell​(int row,
                                     int col)
        Gets a particular Cell object from this work sheet.
        Parameters:
        row - The 0 based row index
        col - The 0 based column index
        Returns:
        The underlying Aspose Cells Cell object at the given indices

      • getValue

        public java.lang.Object getValue​(int row,
                                 int col)
        Gets the value of a particular cell in this work sheet
        Parameters:
        row - The 0 based row index
        col - The 0 based column index
        Returns:
        The value of the cell at the given indices

      • setValue

        public void setValue​(int row,
                     int col,
                     java.lang.Object value)
        Sets the value of a particular cell in this work sheet
        Parameters:
        row - The 0 based row index
        col - The 0 based column index
        value - The value to assign to the cell at the given indices

      • setStyle

        public void setStyle​(int row,
                     int col,
                     com.aspose.cells.Style style)
        Sets the style of of a particular cell in this work sheet
        Parameters:
        row - The 0 based row index
        col - The 0 based column index
        style - The Style to apply to the cell at the given indices

      • getStyle

        public com.aspose.cells.Style getStyle​(int row,
                                       int col)
        Gets the style of a particular cell in this work sheet
        Parameters:
        row - The 0 based row index
        col - The 0 based column index
        Returns:
        The Style of the cell at the given indices

      • mergeCols

        public void mergeCols​(int row,
                      int col,
                      int colCount)
        Merges a series of cells horizontally
        Parameters:
        row - The 0 based row index
        col - The 0 based column index of the first column in the merged group of cells.
        colCount - How many cells total to merge, so if you want the 2 cells following the first cell specified by the indices, provide a value of 3.

      • autoFitColumns

        public void autoFitColumns()
                    throws java.lang.Exception
        Throws:
        java.lang.Exception

      • autoFitRow

        public void autoFitRow​(int row)
                throws java.lang.Exception
        Throws:
        java.lang.Exception

      • appendRow

        public void appendRow​(java.util.List<? extends java.lang.Object> rowValues)

      • appendRow

        public void appendRow​(java.util.List<java.lang.Object> rowValues,
                      com.aspose.cells.Style defaultStyle)

      • eachCell

        public void eachCell​(int startRow,
                     int endRow,
                     int startCol,
                     int endCol,
                     java.util.function.Consumer<com.aspose.cells.Cell> activity)

      • getCurrentRow

        public int getCurrentRow()

      • setCurrentRow

        public void setCurrentRow​(int currentRow)