com.aspose.cells.Cells.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aspose-cells Show documentation

Aspose.Cells for Java

There is a newer version: 23.1






Cells





com.aspose.cells

Class Cells
java.lang.Object
    com.aspose.cells.Cells


All Implemented Interfaces: 
java.lang.Iterable



public class Cells extends java.lang.Object





             Encapsulates a collection of cell relevant objects, such as Cell, Row, ...etc.
             
Example:
Workbook excel = new Workbook();
Cells cells = excel.getWorksheets().get(0).getCells();

//Set default row height
cells.setStandardHeight(20);
//Set row height
cells.setRowHeight(2, 20.5);

//Set default colum width
cells.setStandardWidth(15);
//Set column width
cells.setColumnWidth(3, 12.57);

//Merge cells
cells.merge(5, 4, 2, 2);












Property Getters/Setters Summary



ColumnCollection getColumns() 
          
            Gets the collection of Column objects that represents the individual columns in this worksheet.
            



int getCount() 
          
            Gets the total count of instantiated Cell objects.
            



long getCountLarge() 
          
            Gets the total count of instantiated Cell objects.
            



Cell getFirstCell() 
          
            Gets the first cell in this worksheet.
            



boolean isDefaultRowHeightMatched() 
void setDefaultRowHeightMatched(boolean) 
          
            Indicates that row height and default font height matches
            



boolean isDefaultRowHidden() 
void setDefaultRowHidden(boolean) 
          
            Indicates whether the row is default hidden.
            



Cell getLastCell() 
          
            Gets the last cell in this worksheet.
            



int getMaxColumn() 
          
            Minimum column index of those cells that have been instantiated in the collection(does not include the column
            where style is defined for the whole column but no cell has been instantiated in it).
            



int getMaxDataColumn() 
          
            Maximum column index of cell which contains data.
            



int getMaxDataRow() 
          
            Maximum row index of cell which contains data.
            



Range getMaxDisplayRange() 
          
            Gets the max range which includes data, merged cells and shapes.
            



int getMaxRow() 
          
            Maximum row index of cell which contains data or style.
            



int getMemorySetting() 
void setMemorySetting(int) 
          
            Gets or sets the memory usage option for this cells.
            The value of the property is MemorySetting integer constant.



java.util.ArrayList getMergedCells() 
          
            Gets the collection of merged cells.
            



int getMinColumn() 
          
            Minimum column index of those cells that have been instantiated in the collection(does not include the column
            where style is defined for the whole column but no cell has been instantiated in it).
            



int getMinDataColumn() 
          
            Minimum column index of cell which contains data.
            



int getMinDataRow() 
          
            Minimum row index of cell which contains data.
            



int getMinRow() 
          
            Minimum row index of cell which contains data or style.
            



boolean getMultiThreadReading() 
void setMultiThreadReading(boolean) 
          
            Gets or sets whether the cells data model should support Multi-Thread reading.
            Default value of this property is false.
            



OdsCellFieldCollection getOdsCellFields() 
          
            Gets the list of fields of ods.
            



boolean getPreserveString() 
void setPreserveString(boolean) 
          
            Gets or sets a value indicating whether all worksheet values are preserved as strings. 
            Default is false.
            



RangeCollection getRanges() 
          
            Gets the collection of Range objects created at run time.
            



RowCollection getRows() 
          
            Gets the collection of Row objects that represents the individual rows in this worksheet.
            



double getStandardHeight() 
void setStandardHeight(double) 
          
            Gets or sets the default row height in this worksheet, in unit of points.
            



double getStandardHeightInch() 
void setStandardHeightInch(double) 
          
            Gets or sets the default row height in this worksheet, in unit of inches.
            



int getStandardHeightPixels() 
void setStandardHeightPixels(int) 
          
            Gets or sets the default row height in this worksheet, in unit of pixels.
            



double getStandardWidth() 
void setStandardWidth(double) 
          
            Gets or sets the default column width in the worksheet, in unit of characters.
            



double getStandardWidthInch() 
void setStandardWidthInch(double) 
          
             Gets or sets the default column width in the worksheet, in unit of inches.
            



int getStandardWidthPixels() 
void setStandardWidthPixels(int) 
          
             Gets or sets the default column width in the worksheet, in unit of pixels.
            



Style getStyle() 
void setStyle(Style) 
          
            Gets and sets the default style.
            



Cell get(int) 
          
            Gets Cell item within the worksheet
            



Cell get(int, int) 
          
            Gets the Cell element at the specified cell row index and column index.
            



Cell get(java.lang.String) 
          
            Gets the Cell element at the specified cell name.
            

 







Method Summary




void addRange(Range rangeObject) 
          
            Adds a range object reference to cells
            




void applyColumnStyle(int column, Style style, StyleFlag flag) 
          
            Applies formats for a whole column.
            




void applyRowStyle(int row, Style style, StyleFlag flag) 
          
            Applies formats for a whole row.
            




void applyStyle(Style style, StyleFlag flag) 
          
            Applies formats for a whole worksheet.
            




Cell checkCell(int row, int column) 
          
            Gets the Cell element or null at the specified cell row index and column index.
            




Column checkColumn(int columnIndex) 
          
             Gets the Column element or null at the specified column index.
            




Row checkRow(int row) 
          
             Gets the Row element or at the specified cell row index.
            




void clear() 
          
            Clears all cell and row objects.
            




void clearContents(CellArea range) 
          
            Clears contents of a range.
            




void clearContents(int startRow, int startColumn, int endRow, int endColumn) 
          
            Clears contents of a range.
            




void clearFormats(CellArea range) 
          
            Clears formatting of a range.
            




void clearFormats(int startRow, int startColumn, int endRow, int endColumn) 
          
            Clears formatting of a range.
            




void clearMergedCells() 
          
            Clears all merged ranges.
            




void clearRange(CellArea range) 
          
            Clears contents and formatting of a range.
            




void clearRange(int startRow, int startColumn, int endRow, int endColumn) 
          
            Clears contents and formatting of a range.
            




void convertStringToNumericValue() 
          
            Converts string data in cells to numeric value if possible.
            




void copyColumn(Cells sourceCells, int sourceColumnIndex, int destinationColumnIndex) 
          
            Copies data and formats of a whole column.
            




void copyColumns(Cells sourceCells0, int sourceColumnIndex, int destinationColumnIndex, int columnNumber) 
          
            Copies data and formats of a whole column.
            




void copyColumns(Cells sourceCells0, int sourceColumnIndex, int destinationColumnIndex, int columnNumber, PasteOptions pasteOptions) 
          
            Copies data and formats of a whole column.
            




void copyColumns(Cells sourceCells, int sourceColumnIndex, int sourceTotalColumns, int destinationColumnIndex, int destinationTotalColumns) 
          
            Copies data and formats of the whole columns.
            




void copyRow(Cells sourceCells, int sourceRowIndex, int destinationRowIndex) 
          
            Copies data and formats of a whole row.
            




void copyRows(Cells sourceCells, int sourceRowIndex, int destinationRowIndex, int rowNumber) 
          
            Copies data and formats of some whole rows.
            




void copyRows(Cells sourceCells0, int sourceRowIndex, int destinationRowIndex, int rowNumber, CopyOptions copyOptions) 
          
            Copies data and formats of some whole rows.
            




void copyRows(Cells sourceCells0, int sourceRowIndex, int destinationRowIndex, int rowNumber, CopyOptions copyOptions, PasteOptions pasteOptions) 
          
            Copies data and formats of some whole rows.
            




Range createRange(int firstIndex, int number, boolean isVertical) 
          
            Creates a Range object from rows of cells or columns of cells.
            




Range createRange(int firstRow, int firstColumn, int totalRows, int totalColumns) 
          
            Creates a Range object from a range of cells.
            




Range createRange(java.lang.String address) 
          
             Creates a Range object from an address of the range.
            




Range createRange(java.lang.String upperLeftCell, java.lang.String lowerRightCell) 
          
            Creates a Range object from a range of cells.
            




void deleteBlankColumns() 
          
            Delete all blank columns which do not contain any data.
            




void deleteBlankColumns(DeleteOptions options) 
          
            Delete all blank columns which do not contain any data.
            




void deleteBlankRows() 
          
            Delete all blank rows which do not contain any data.
            




void deleteBlankRows(DeleteOptions options) 
          
            Delete all blank rows which do not contain any data.
            




void deleteColumn(int columnIndex) 
          
            Deletes a column.
            




void deleteColumn(int columnIndex, boolean updateReference) 
          
            Deletes a column.
            




void deleteColumns(int columnIndex, int totalColumns, boolean updateReference) 
          
            Deletes several columns.
            




void deleteRange(int startRow, int startColumn, int endRow, int endColumn, int shiftType) 
          
            Deletes a range of cells and shift cells according to the shift option.
            




void deleteRow(int rowIndex) 
          
            Deletes a row.
            




boolean deleteRows(int rowIndex, int totalRows) 
          
            Deletes several rows.
            




boolean deleteRows(int rowIndex, int totalRows, boolean updateReference) 
          
            Deletes multiple rows in the worksheet.
            




void dispose() 
          
            Performs application-defined tasks associated with freeing, releasing, or
            resetting unmanaged resources.
            




Cell endCellInColumn(int startRow, int endRow, short startColumn, short endColumn) 
          
            Gets the last cell with maximum column index in this range.
            




Cell endCellInColumn(short columnIndex) 
          
            Gets the last cell in this column.
            




Cell endCellInRow(int rowIndex) 
          
            Gets the last cell in this row.
            




Cell endCellInRow(int startRow, int endRow, int startColumn, int endColumn) 
          
            Gets the last cell with maximum row index in this range.
            




java.lang.Object[][] exportArray(int firstRow, int firstColumn, int totalRows, int totalColumns) 
          
            Exports data in the Cells collection to a two-dimension array object.
            




int[][] exportTypeArray(int firstRow, int firstColumn, int totalRows, int totalColumns) 
          
            Exports cell value type in the Cells collection to a two-dimension array object.
            




Cell find(java.lang.Object what, Cell previousCell) 
          
            Finds the cell containing with the input object.
            




Cell find(java.lang.Object what, Cell previousCell, FindOptions findOptions) 
          
            Finds the cell containing with the input object.
            




Cell findFormula(java.lang.String formula, Cell previousCell) 
          
            Finds the cell with the input string.
            




Cell findFormulaContains(java.lang.String formula, Cell previousCell) 
          
            Finds the cell with formula which contains the input string.
            




Cell getCell(int row, int column) 
          
            Gets the Cell element at the specified cell row index and column index.
            




Style getCellStyle(int row, int column) 
          
            Get the style of given cell.
            




Column getColumn(int columnIndex) 
          
            Gets the Column element or at the specified cell row index.
            




double getColumnWidth(int column) 
          
            Gets the width of the specified column in normal view
            




double getColumnWidthInch(int column) 
          
            Gets the width of the specified column in normal view, in units of inches.
            




int getColumnWidthPixel(int column) 
          
            Gets the width of the specified column in normal view, in units of pixel.
            




com.aspose.cells.Cell[] getDependents(boolean isAll, int row, int column) 
          
            Get all cells which refer to the specific cell.
            




int getGroupedColumnOutlineLevel(int columnIndex) 
          
            Gets the outline level (zero-based) of the column.
            




int getGroupedRowOutlineLevel(int rowIndex) 
          
            Gets the outline level (zero-based) of the row.
            




int getLastDataRow(int column) 
          
            Gets the last row index of cell which contains data in the specified column.
            




int getMaxGroupedColumnOutlineLevel() 
          
            Gets the max grouped column outline level (zero-based).
            




int getMaxGroupedRowOutlineLevel() 
          
            Gets the max grouped row outline level (zero-based).
            




Row getRow(int row) 
          
             Gets the Row element or at the specified cell row index.
            




java.util.Iterator getRowEnumerator() 
          
            Gets the rows enumerator.
            




double getRowHeight(int row) 
          
            Gets the height of a specified row.
            




double getRowHeightInch(int row) 
          
            Gets the height of a specified row in unit of inches.
            




int getRowHeightPixel(int row) 
          
            Gets the height of a specified row in unit of pixel.
            




double getRowOriginalHeightPoint(int row) 
          
            Gets original row's height in unit of point if the row is hidden 
            




int getViewColumnWidthPixel(int column) 
          
            Get the width in different view type.
            




double getViewRowHeight(int row) 
          
            Gets the height of a specified row.
            




double getViewRowHeightInch(int row) 
          
            Gets the height of a specified row in unit of inches.
            




void groupColumns(int firstIndex, int lastIndex) 
          
            Groups columns.
            




void groupColumns(int firstIndex, int lastIndex, boolean isHidden) 
          
            Groups columns.
            




void groupRows(int firstIndex, int lastIndex) 
          
            Groups rows.
            




void groupRows(int firstIndex, int lastIndex, boolean isHidden) 
          
            Groups rows.
            




void hideColumn(int column) 
          
            Hides a column.
            




void hideColumns(int column, int totalColumns) 
          
            Hide multiple columns.
            




void hideGroupDetail(boolean isVertical, int index) 
          
            Collapses the grouped rows/columns. 
            




void hideRow(int row) 
          
            Hides a row.
            




void hideRows(int row, int totalRows) 
          
            Hides multiple rows.
            




void importArray(double[] doubleArray, int firstRow, int firstColumn, boolean isVertical) 
          
            Imports an array of double into a worksheet.
            




void importArray(double[][] doubleArray, int firstRow, int firstColumn) 
          
            Imports a two-dimension array of double into a worksheet.
            




void importArray(int[] intArray, int firstRow, int firstColumn, boolean isVertical) 
          
            Imports an array of integer into a worksheet.
            




void importArray(int[][] intArray, int firstRow, int firstColumn) 
          
            Imports a two-dimension array of integer into a worksheet.
            




void importArray(java.lang.String[] stringArray, int firstRow, int firstColumn, boolean isVertical) 
          
            Imports an array of string into a worksheet.
            




void importArray(java.lang.String[][] stringArray, int firstRow, int firstColumn) 
          
            Imports a two-dimension array of string into a worksheet.
            




void importArrayList(java.util.ArrayList arrayList, int firstRow, int firstColumn, boolean isVertical) 
          
            Imports an arraylist of data into a worksheet.
            




void importCSV(java.io.InputStream stream, TxtLoadOptions options, int firstRow, int firstColumn) 
          
            Import a CSV file to the cells.
            




void importCSV(java.io.InputStream stream, java.lang.String splitter, boolean convertNumericData, int firstRow, int firstColumn) 
          
            Import a CSV file to the cells.
            




void importCSV(java.lang.String fileName, TxtLoadOptions options, int firstRow, int firstColumn) 
          
            Import a CSV file to the cells.
            




void importCSV(java.lang.String fileName, java.lang.String splitter, boolean convertNumericData, int firstRow, int firstColumn) 
          
            Import a CSV file to the cells.
            




int importCustomObjects(java.util.Collection list, int firstRow, int firstColumn, ImportTableOptions options) 
          
            Imports custom objects.
            




int importCustomObjects(java.util.Collection list, java.lang.String[] propertyNames, boolean isPropertyNameShown, int firstRow, int firstColumn, int rowNumber, boolean insertRows, java.lang.String dateFormatString, boolean convertStringToNumber) 
          
            Imports custom objects.
            




int importData(ICellsDataTable table, int firstRow, int firstColumn, ImportTableOptions options) 
          
            Import data from custom data table.
            




void importFormulaArray(java.lang.String[] stringArray, int firstRow, int firstColumn, boolean isVertical) 
          
            Imports an array of formula into a worksheet.
            




void importObjectArray(java.lang.Object[] objArray, int firstRow, int firstColumn, boolean isVertical) 
          
            Imports an array of data into a worksheet.
            




void importObjectArray(java.lang.Object[] objArray, int firstRow, int firstColumn, boolean isVertical, int skip) 
          
            Imports an array of data into a worksheet.
            




int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, boolean isFieldNameShown) 
          
            Imports data in a ResultSet object to the worksheet.
            




int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, boolean isFieldNameShown, java.lang.String customDateFormatString, boolean convertStringToNumber) 
          
            Imports data in a ResultSet object to the worksheet.
            




int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, ImportTableOptions options) 
          
            Imports data in a ResultSet object to the worksheet.
            




int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, int rowNum, int columnNum, boolean isFieldNameShown) 
          
            Imports data in a ResultSet object to the worksheet.
            




int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, int rowNum, int columnNum, boolean isFieldNameShown, java.lang.String customDateFormatString, boolean convertStringToNumber) 
          
            Imports data in a ResultSet object to the worksheet.
            




int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, boolean isFieldNameShown) 
          
            Imports data in a ResultSet object to the worksheet.
            




int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, ImportTableOptions options) 
          
            Imports data in a ResultSet object to the worksheet.
            




int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, int rowNum, int columnNum, boolean isFieldNameShown) 
          
            Imports data in a ResultSet object to the worksheet.
            




void importTwoDimensionArray(java.lang.Object[][] objArray, int firstRow, int firstColumn) 
          
            Imports a two-dimension array of data into a worksheet.
            




void importTwoDimensionArray(java.lang.Object[][] objArray, int firstRow, int firstColumn, boolean convertStringToNumber) 
          
            Imports a two-dimension array of data into a worksheet.
            




void importTwoDimensionArray(java.lang.Object[][] objArray, java.lang.Object[][] styles, int firstRow, int firstColumn, boolean convertStringToNumber) 
          
            Imports a two-dimension array of data into a worksheet.
            




void importTwoDimensionArray(java.lang.Object[][] objArray, java.lang.Object[][] styles, int firstRow, int firstColumn, TxtLoadOptions opts) 
          
            Imports a two-dimension array of data into a worksheet.
            




void insertColumn(int columnIndex) 
          
            Inserts a new column into the worksheet.
            




void insertColumn(int columnIndex, boolean updateReference) 
          
            Inserts a new column into the worksheet.
            




void insertColumns(int columnIndex, int totalColumns) 
          
            Inserts some columns into the worksheet.
            




void insertColumns(int columnIndex, int totalColumns, boolean updateReference) 
          
            Inserts some columns into the worksheet.
            




void insertCutCells(Range cutRange, int row, int column, int shiftType) 
          
            Insert cut range.
            




void insertRange(CellArea area, int shiftType) 
          
            Inserts a range of cells and shift cells according to the shift option.
            




void insertRange(CellArea area, int shiftNumber, int shiftType) 
          
            Inserts a range of cells and shift cells according to the shift option.
            




void insertRange(CellArea area, int shiftNumber, int shiftType, boolean updateReference) 
          
            Inserts a range of cells and shift cells according to the shift option.
            




void insertRow(int rowIndex) 
          
            Inserts a new row into the worksheet.
            




void insertRows(int rowIndex, int totalRows) 
          
            Inserts multiple rows into the worksheet.
            




void insertRows(int rowIndex, int totalRows, boolean updateReference) 
          
            Inserts multiple rows into the worksheet.
            




void insertRows(int rowIndex, int totalRows, InsertOptions options) 
          
            Inserts multiple rows into the worksheet.
            




boolean isBlankColumn(int columnIndex) 
          
            Checks whether given column is blank(does not contain any data).
            




boolean isColumnHidden(int columnIndex) 
          
            Checks whether a column at given index is hidden.
            




boolean isDeletingRangeEnabled(int startRow, int startColumn, int totalRows, int totalColumns) 
          
            Check whether the range could be deleted.
            




boolean isRowHidden(int rowIndex) 
          
            Checks whether a row at given index is hidden.
            




java.util.Iterator iterator() 
          
            Gets the cells enumerator.
            




void linkToXmlMap(java.lang.String mapName, int row, int column, java.lang.String path) 
          
             Link to a xml map.
             




void merge(int firstRow, int firstColumn, int totalRows, int totalColumns) 
          
            Merges a specified range of cells into a single cell. 		
            




void merge(int firstRow, int firstColumn, int totalRows, int totalColumns, boolean mergeConflict) 
          
            Merges a specified range of cells into a single cell. 		
            




void merge(int firstRow, int firstColumn, int totalRows, int totalColumns, boolean checkConflict, boolean mergeConflict) 
          
            Merges a specified range of cells into a single cell. 		
            




void moveRange(CellArea sourceArea, int destRow, int destColumn) 
          
            Moves the range.
            




void removeDuplicates() 
          
            Removes duplicate rows in the sheet.
            




void removeDuplicates(int startRow, int startColumn, int endRow, int endColumn) 
          
            Removes duplicate values in the range.
            




void removeDuplicates(int startRow, int startColumn, int endRow, int endColumn, boolean hasHeaders, int[] columnOffsets) 
          
            Removes duplicate data of the range.
            




void removeFormulas() 
          
            Removes all formula and replaces with the value of the formula.
            




SubtotalSetting retrieveSubtotalSetting(CellArea ca) 
          
            Retrieves subtotals setting of the range.
            




void setColumnWidth(int column, double width) 
          
            Sets the width of the specified column in normal view.
            




void setColumnWidthInch(int column, double inches) 
          
            Sets column width in unit of inches  in normal view.
            




void setColumnWidthPixel(int column, int pixels) 
          
            Sets column width in unit of pixels in normal view.
            




void setRowHeight(int row, double height) 
          
            Sets the height of the specified row.
            




void setRowHeightInch(int row, double inches) 
          
            Sets row height in unit of inches.
            




void setRowHeightPixel(int row, int pixels) 
          
            Sets row height in unit of pixels.
            




void setViewColumnWidthPixel(int column, int pixels) 
          
            Sets the width of the column in different view.
            




void showGroupDetail(boolean isVertical, int index) 
          
            Expands the grouped rows/columns. 
            




void subtotal(CellArea ca, int groupBy, int function, int[] totalList) 
          
            Creates subtotals for the range.
            




void subtotal(CellArea ca, int groupBy, int function, int[] totalList, boolean replace, boolean pageBreaks, boolean summaryBelowData) 
          
            Creates subtotals for the range.
            




void textToColumns(int row, int column, int totalRows, TxtLoadOptions options) 
          
            Splits the text in the column to columns.
            




void ungroupColumns(int firstIndex, int lastIndex) 
          
            Ungroups columns.
            




void ungroupRows(int firstIndex, int lastIndex) 
          
            Ungroups rows.
            




void ungroupRows(int firstIndex, int lastIndex, boolean isAll) 
          
            Ungroups rows.
            




void unhideColumn(int column, double width) 
          
            Unhides a column
            




void unhideColumns(int column, int totalColumns, double width) 
          
            Unhide multiple columns.
            




void unhideRow(int row, double height) 
          
            Unhides a row.
            




void unhideRows(int row, int totalRows, double height) 
          
            Unhides the hidden rows.
            




void unMerge(int firstRow, int firstColumn, int totalRows, int totalColumns) 
          
            Unmerges a specified range of merged cells. 		
            

 








Property Getters/Setters Detail



getOdsCellFields 
public OdsCellFieldCollection getOdsCellFields()


            Gets the list of fields of ods.
            



getCount 
public int getCount()


            Gets the total count of instantiated Cell objects.
            



getCountLarge 
public long getCountLarge()


            Gets the total count of instantiated Cell objects.
            



getRows 
public RowCollection getRows()


            Gets the collection of Row objects that represents the individual rows in this worksheet.
            



getMergedCells 
public java.util.ArrayList getMergedCells()


            Gets the collection of merged cells.
            
In this collection, each item is a CellArea structure which represents an area of merged cells.



getMultiThreadReading/setMultiThreadReading 
public boolean getMultiThreadReading() / public void setMultiThreadReading(boolean value)


            Gets or sets whether the cells data model should support Multi-Thread reading.
            Default value of this property is false.
            

            If there are multiple threads to read Row/Cell objects in this collection concurrently,
            this property should be set as true, otherwise unexpected result may be produced.
            Supporting Multi-Thread reading may degrade the performance for accessing Row/Cell objects from this collection.
            Please note, some features cannot support Multi-Thread reading,
            such as formatting values(by Cell.StringValue, Cell.DisplayStringValue, .etc.).
            So, even with this property being set as true, those APIs still may give unexpected result for Multi-Thread reading.
            



setMultiThreadReading 
public void setMultiThreadReading(boolean value)


            Gets or sets whether the cells data model should support Multi-Thread reading.
            Default value of this property is false.
            

            If there are multiple threads to read Row/Cell objects in this collection concurrently,
            this property should be set as true, otherwise unexpected result may be produced.
            Supporting Multi-Thread reading may degrade the performance for accessing Row/Cell objects from this collection.
            Please note, some features cannot support Multi-Thread reading,
            such as formatting values(by Cell.StringValue, Cell.DisplayStringValue, .etc.).
            So, even with this property being set as true, those APIs still may give unexpected result for Multi-Thread reading.
            




getMemorySetting/setMemorySetting 
public int getMemorySetting() / public void setMemorySetting(int value)


            Gets or sets the memory usage option for this cells.
            The value of the property is MemorySetting integer constant.



setMemorySetting 
public void setMemorySetting(int value)


            Gets or sets the memory usage option for this cells.
            The value of the property is MemorySetting integer constant.




getStyle/setStyle 
public Style getStyle() / public void setStyle(Style value)


            Gets and sets the default style.
            



setStyle 
public void setStyle(Style value)


            Gets and sets the default style.
            




getStandardWidthInch/setStandardWidthInch 
public double getStandardWidthInch() / public void setStandardWidthInch(double value)


             Gets or sets the default column width in the worksheet, in unit of inches.
            



setStandardWidthInch 
public void setStandardWidthInch(double value)


             Gets or sets the default column width in the worksheet, in unit of inches.
            




getStandardWidthPixels/setStandardWidthPixels 
public int getStandardWidthPixels() / public void setStandardWidthPixels(int value)


             Gets or sets the default column width in the worksheet, in unit of pixels.
            



setStandardWidthPixels 
public void setStandardWidthPixels(int value)


             Gets or sets the default column width in the worksheet, in unit of pixels.
            




getStandardWidth/setStandardWidth 
public double getStandardWidth() / public void setStandardWidth(double value)


            Gets or sets the default column width in the worksheet, in unit of characters.
            



setStandardWidth 
public void setStandardWidth(double value)


            Gets or sets the default column width in the worksheet, in unit of characters.
            




getStandardHeight/setStandardHeight 
public double getStandardHeight() / public void setStandardHeight(double value)


            Gets or sets the default row height in this worksheet, in unit of points.
            



setStandardHeight 
public void setStandardHeight(double value)


            Gets or sets the default row height in this worksheet, in unit of points.
            




getStandardHeightPixels/setStandardHeightPixels 
public int getStandardHeightPixels() / public void setStandardHeightPixels(int value)


            Gets or sets the default row height in this worksheet, in unit of pixels.
            



setStandardHeightPixels 
public void setStandardHeightPixels(int value)


            Gets or sets the default row height in this worksheet, in unit of pixels.
            




getStandardHeightInch/setStandardHeightInch 
public double getStandardHeightInch() / public void setStandardHeightInch(double value)


            Gets or sets the default row height in this worksheet, in unit of inches.
            



setStandardHeightInch 
public void setStandardHeightInch(double value)


            Gets or sets the default row height in this worksheet, in unit of inches.
            




getPreserveString/setPreserveString 
public boolean getPreserveString() / public void setPreserveString(boolean value)


            Gets or sets a value indicating whether all worksheet values are preserved as strings. 
            Default is false.
            



setPreserveString 
public void setPreserveString(boolean value)


            Gets or sets a value indicating whether all worksheet values are preserved as strings. 
            Default is false.
            




getMinRow 
public int getMinRow()


            Minimum row index of cell which contains data or style.
            



getMaxRow 
public int getMaxRow()


            Maximum row index of cell which contains data or style.
            

            Return -1 if there is no cell which contains data or style in the worksheet.
            



getMinColumn 
public int getMinColumn()


            Minimum column index of those cells that have been instantiated in the collection(does not include the column
            where style is defined for the whole column but no cell has been instantiated in it).
            



getMaxColumn 
public int getMaxColumn()


            Minimum column index of those cells that have been instantiated in the collection(does not include the column
            where style is defined for the whole column but no cell has been instantiated in it).
            

            Return -1 if there is no cell.
            



getMinDataRow 
public int getMinDataRow()


            Minimum row index of cell which contains data.
            



getMaxDataRow 
public int getMaxDataRow()


            Maximum row index of cell which contains data.
            

            Return -1 if there is no cell which contains data.
            



getMinDataColumn 
public int getMinDataColumn()


            Minimum column index of cell which contains data.
            

            -1 will be returned if there is no cell which contains data.
            This property needs to iterate and check all cells in a worksheet,
            so it is a time-consumed progress and should not be invoked repeatedly.



getMaxDataColumn 
public int getMaxDataColumn()


            Maximum column index of cell which contains data.
            

            -1 will be returned if there is no cell which contains data.
            This property needs to iterate and check all cells in a worksheet,
            so it is a time-consumed progress and should not be invoked repeatedly.



isDefaultRowHeightMatched/setDefaultRowHeightMatched 
public boolean isDefaultRowHeightMatched() / public void setDefaultRowHeightMatched(boolean value)


            Indicates that row height and default font height matches
            



setDefaultRowHeightMatched 
public void setDefaultRowHeightMatched(boolean value)


            Indicates that row height and default font height matches
            




isDefaultRowHidden/setDefaultRowHidden 
public boolean isDefaultRowHidden() / public void setDefaultRowHidden(boolean value)


            Indicates whether the row is default hidden.
            



setDefaultRowHidden 
public void setDefaultRowHidden(boolean value)


            Indicates whether the row is default hidden.
            




getColumns 
public ColumnCollection getColumns()


            Gets the collection of Column objects that represents the individual columns in this worksheet.
            



getRanges 
public RangeCollection getRanges()


            Gets the collection of Range objects created at run time.
            



getLastCell 
public Cell getLastCell()


            Gets the last cell in this worksheet.
            

            Returns null if there is no data in the worksheet.
            



getMaxDisplayRange 
public Range getMaxDisplayRange()


            Gets the max range which includes data, merged cells and shapes.
            

            Reutrns null if the worksheet is empty since Aspose.Cells 21.5.2.
            



getFirstCell 
public Cell getFirstCell()


            Gets the first cell in this worksheet.
            

            Returns null if there is no data in the worksheet.
            



get 
public Cell get(int index)


            Gets Cell item within the worksheet
            
The element at the specified index.NOTE: This member is now obsolete. 
            Instead, please use Cells.GetEnumerator() method to iterate all cells in this worksheet.
            This property will be removed 12 months later since February 2015. 
            Aspose apologizes for any inconvenience you may have experienced.Parameters:
index - The zero based index of the element.



get 
public Cell get(int row, int column)


            Gets the Cell element at the specified cell row index and column index.
            
Parameters:
row - Row index.
column - Column index.
Returns:
The Cell object.
Example:
Cells cells = excel.getWorksheets().get(0).getCells();
Cell cell = cells.get(0, 0);    //Gets the cell at "A1"



get 
public Cell get(java.lang.String cellName)


            Gets the Cell element at the specified cell name.
            
Parameters:
cellName - Cell name,including its column letter and row number, for example A5.
Returns:
A Cell object
Example:
Cells cells = excel.getWorksheets().get(0).getCells();
Cell cell = cells.get("A1");    //Gets the cell at "A1"







Method Detail



linkToXmlMap 
public void linkToXmlMap(java.lang.String mapName, int row, int column, java.lang.String path)
                 throws java.lang.Exception

             Link to a xml map.
             
             e.g. A xml map element structure:
             
                         -RootElement
                             |-Attribute1
                             |-SubElement
                                 |-Attribute2
                                 |-Attribute3
            
             To link "Attribute1", path is "/RootElement/Attribute1"
             To link "Attribute2", path is "/RootElement/SubElement/Attribute2"
             To link whole "SubElement", path is "/RootElement/SubElement"
        Parameters:
mapName - name of xml map
row - row of the destination cell
column - column of the destination cell
path - path of xml element in xml map




findFormula 
public Cell findFormula(java.lang.String formula, Cell previousCell)

            Finds the cell with the input string.
            
Returns null (Nothing) if no cell is found.
            NOTE: This member is now obsolete. Instead, 
            please use Cells.Find(object,Cell,FindOptions) method with LookInType as LookInType.OnlyFormulas
            and LookAtType as LookAtType.EntireContent. 
            This member will be removed 12 months later since November 2018. 
            Aspose apologizes for any inconvenience you may have experienced.Parameters:
formula - The formula to search for.
previousCell - Previous cell with the same formula. This parameter can be set to null if searching from the start.
Returns:
Cell object.




findFormulaContains 
public Cell findFormulaContains(java.lang.String formula, Cell previousCell)

            Finds the cell with formula which contains the input string.
            
Returns null (Nothing) if no cell is found.
            NOTE: This member is now obsolete. Instead, 
            please use Cells.Find(object,Cell,FindOptions) method with LookInType as LookInType.OnlyFormulas
            and LookAtType as LookAtType.Contains. 
            This member will be removed 12 months later since November 2018. 
            Aspose apologizes for any inconvenience you may have experienced.Parameters:
formula - The formula to search for.
previousCell - Previous cell with the same formula. This parameter can be set to null if searching from the start.
Returns:
Cell object.




find 
public Cell find(java.lang.Object what, Cell previousCell)

            Finds the cell containing with the input object.
            
Returns null (Nothing) if no cell is found.Parameters:
what - The object to search for.
            The type should be int,double,DateTime,string,bool.
            
previousCell - Previous cell with the same object. 
            This parameter can be set to null if searching from the start.
Returns:
Cell object.




find 
public Cell find(java.lang.Object what, Cell previousCell, FindOptions findOptions)

            Finds the cell containing with the input object.
            
Returns null (Nothing) if no cell is found.Parameters:
what - The object to search for.
            The type should be int,double,DateTime,string,bool.
            
previousCell - Previous cell with the same object. 
            This parameter can be set to null if searching from the start.
findOptions - Find options
Returns:
Cell object.




endCellInRow 
public Cell endCellInRow(int rowIndex)

            Gets the last cell in this row.
            
Parameters:
rowIndex - Row index.
Returns:
Cell object.




endCellInColumn 
public Cell endCellInColumn(short columnIndex)

            Gets the last cell in this column.
            
Parameters:
columnIndex - Column index.
Returns:
Cell object.




endCellInColumn 
public Cell endCellInColumn(int startRow, int endRow, short startColumn, short endColumn)

            Gets the last cell with maximum column index in this range.
            
Parameters:
startRow - Start row index.
endRow - End row index.
startColumn - Start column index.
endColumn - End column index.
Returns:
Cell object.




endCellInRow 
public Cell endCellInRow(int startRow, int endRow, int startColumn, int endColumn)

            Gets the last cell with maximum row index in this range.
            
Parameters:
startRow - Start row index.
endRow - End row index.
startColumn - Start column index.
endColumn - End column index.
Returns:
Cell object.




moveRange 
public void moveRange(CellArea sourceArea, int destRow, int destColumn)

            Moves the range.
            
Parameters:
sourceArea - The range which should be moved.
destRow - The dest row.
destColumn - The dest column.




insertCutCells 
public void insertCutCells(Range cutRange, int row, int column, int shiftType)
                   throws java.lang.Exception

            Insert cut range.
            
Parameters:
cutRange - The cut range.
row - The row.
column - The column.
shiftType - A ShiftType value. The shift type .




insertRange 
public void insertRange(CellArea area, int shiftNumber, int shiftType, boolean updateReference)

            Inserts a range of cells and shift cells according to the shift option.
            
Parameters:
area - Shift area.
shiftNumber - Number of rows or columns to be inserted.
shiftType - A ShiftType value. Shift cells option.
updateReference - Indicates if update references in other worksheets.




insertRange 
public void insertRange(CellArea area, int shiftType)

            Inserts a range of cells and shift cells according to the shift option.
            
Parameters:
area - Shift area.
shiftType - A ShiftType value. Shift cells option.




insertRange 
public void insertRange(CellArea area, int shiftNumber, int shiftType)

            Inserts a range of cells and shift cells according to the shift option.
            
Parameters:
area - Shift area.
shiftNumber - Number of rows or columns to be inserted.
shiftType - A ShiftType value. Shift cells option.




deleteRange 
public void deleteRange(int startRow, int startColumn, int endRow, int endColumn, int shiftType)

            Deletes a range of cells and shift cells according to the shift option.
            
Parameters:
startRow - Start row index.
startColumn - Start column index.
endRow - End row index.
endColumn - End column index.
shiftType - A ShiftType value. Shift cells option.




exportArray 
public java.lang.Object[][] exportArray(int firstRow, int firstColumn, int totalRows, int totalColumns)

            Exports data in the Cells collection to a two-dimension array object.
            
Parameters:
firstRow - The row number of the first cell to export out.
firstColumn - The column number of the first cell to export out.
totalRows - Number of rows to be exported
totalColumns - Number of columns to be exported
Returns:
Exported cell value array object.




exportTypeArray 
public int[][] exportTypeArray(int firstRow, int firstColumn, int totalRows, int totalColumns)

            Exports cell value type in the Cells collection to a two-dimension array object.
            
Parameters:
firstRow - The row number of the first cell to export out.
firstColumn - The column number of the first cell to export out.
totalRows - Number of rows to be exported.
totalColumns - Number of columns to be exported.
Returns:
Exported CellValueType array object.




importCustomObjects 
public int importCustomObjects(java.util.Collection list, java.lang.String[] propertyNames, boolean isPropertyNameShown, int firstRow, int firstColumn, int rowNumber, boolean insertRows, java.lang.String dateFormatString, boolean convertStringToNumber)
                       throws java.lang.Exception

            Imports custom objects.
            
The custom objects should be the same type.Parameters:
list - The custom object
propertyNames - The property names.If it is null,we will import all properties of the object.
isPropertyNameShown - 
            Indicates whether the property name will be imported to the first row.
            
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
rowNumber - Number of rows to be imported.
insertRows - Indicates whether extra rows are added to fit data.
dateFormatString - Date format string for cells.
convertStringToNumber - Indicates if this method will try to convert string to number.
Returns:
Total number of rows imported.




importCustomObjects 
public int importCustomObjects(java.util.Collection list, int firstRow, int firstColumn, ImportTableOptions options)
                       throws java.lang.Exception

            Imports custom objects.
            
The custom objects should be the same type.Parameters:
list - The custom object
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
options -  The import options.
Returns:
Total number of rows imported.




retrieveSubtotalSetting 
public SubtotalSetting retrieveSubtotalSetting(CellArea ca)

            Retrieves subtotals setting of the range.
            
Parameters:
ca - The range
Returns:





subtotal 
public void subtotal(CellArea ca, int groupBy, int function, int[] totalList)

            Creates subtotals for the range.
            
Parameters:
ca - The range
groupBy - The field to group by, as a zero-based integer offset
function - A ConsolidationFunction value. The subtotal function.
totalList - An array of zero-based field offsets, indicating the fields to which the subtotals are added.




subtotal 
public void subtotal(CellArea ca, int groupBy, int function, int[] totalList, boolean replace, boolean pageBreaks, boolean summaryBelowData)

            Creates subtotals for the range.
            
Parameters:
ca - The range
groupBy - The field to group by, as a zero-based integer offset
function - A ConsolidationFunction value. The subtotal function.
totalList - An array of zero-based field offsets, indicating the fields to which the subtotals are added.
replace - Indicates whether replace the current subtotals
pageBreaks - Indicates whether add page break between groups
summaryBelowData - Indicates whether add summary below data.




removeFormulas 
public void removeFormulas()

            Removes all formula and replaces with the value of the formula.
            




removeDuplicates 
public void removeDuplicates()
                     throws java.lang.Exception

            Removes duplicate rows in the sheet.
            




removeDuplicates 
public void removeDuplicates(int startRow, int startColumn, int endRow, int endColumn)
                     throws java.lang.Exception

            Removes duplicate values in the range.
            
Parameters:
startRow - The start row.
startColumn - The start column
endRow - The end row index.
endColumn - The end column index.




removeDuplicates 
public void removeDuplicates(int startRow, int startColumn, int endRow, int endColumn, boolean hasHeaders, int[] columnOffsets)
                     throws java.lang.Exception

            Removes duplicate data of the range.
            
Parameters:
startRow - The start row.
startColumn - The start column
endRow - The end row index.
endColumn - The end column index.
hasHeaders - Indicates whether the range contains headers.
columnOffsets - The column offsets.




convertStringToNumericValue 
public void convertStringToNumericValue()

            Converts string data in cells to numeric value if possible.
            




getDependents 
public com.aspose.cells.Cell[] getDependents(boolean isAll, int row, int column)

            Get all cells which refer to the specific cell.
            
Parameters:
isAll - Indicates whether check other worksheets
row - The row index.
column - The column index.
Returns:





getCellStyle 
public Style getCellStyle(int row, int column)

            Get the style of given cell.
            
Parameters:
row - row index
column - column
Returns:
the style of given cell.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, ImportTableOptions options)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
startCell - name of start cell to insert the resultset, such as "A1".
options - The import options
Returns:
how many rows actually imported.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, ImportTableOptions options)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
rowIndex - start row index in the worksheet.
columnIndex - start column index in the worksheet.
options - The import options
Returns:
how many rows actually imported.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, int rowNum, int columnNum, boolean isFieldNameShown)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
rowIndex - start row index in the worksheet.
columnIndex - start column index in the worksheet.
rowNum - number of rows to import. -1 to import all records in given resultset.
columnNum - number of columns to import. -1 to import all columns in given resultset.
isFieldNameShown - Indicates whether the field name of the resultset will be imported to the first row.
Returns:
how many rows actually imported.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, int rowNum, int columnNum, boolean isFieldNameShown)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
startCell - name of start cell to insert the resultset, such as "A1".
rowNum - number of rows to import. -1 to import all records in given resultset.
columnNum - number of columns to import. -1 to import all columns in given resultset.
isFieldNameShown - Indicates whether the field name of the resultset will be imported to the first row.
Returns:
how many rows actually imported.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, boolean isFieldNameShown)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
rowIndex - start row index in the worksheet.
columnIndex - start column index in the worksheet.
isFieldNameShown - Indicates whether the field name of the resultset will be imported to the first row.
Returns:
how many rows actually imported.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, java.lang.String startCell, boolean isFieldNameShown)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
startCell - name of start cell to insert the resultset, such as "A1".
isFieldNameShown - Indicates whether the field name of the resultset will be imported to the first row.
Returns:
how many rows actually imported.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, int rowNum, int columnNum, boolean isFieldNameShown, java.lang.String customDateFormatString, boolean convertStringToNumber)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
rowIndex - start row index in the worksheet.
columnIndex - start column index in the worksheet.
rowNum - number of rows to import. -1 to import all records in given resultset.
columnNum - number of columns to import. -1 to import all columns in given resultset.
isFieldNameShown - Indicates whether the field name of the resultset will be imported to the first row.
customDateFormatString - Date format string for cells which contain date value.
convertStringToNumber - Indicates if this method will try to convert string to number.
Returns:
how many rows actually imported.




importResultSet 
public int importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, boolean isFieldNameShown, java.lang.String customDateFormatString, boolean convertStringToNumber)
                   throws java.lang.Exception

            Imports data in a ResultSet object to the worksheet.
            
Parameters:
rs - the ResultSet object to import from.
rowIndex - start row index in the worksheet.
columnIndex - start column index in the worksheet.
isFieldNameShown - Indicates whether the field name of the resultset will be imported to the first row.
customDateFormatString - Date format string for cells which contain date value.
convertStringToNumber - Indicates if this method will try to convert string to number.
Returns:
how many rows actually imported.




importCSV 
public void importCSV(java.io.InputStream stream, TxtLoadOptions options, int firstRow, int firstColumn)
              throws java.lang.Exception

            Import a CSV file to the cells.
            
Parameters:
stream - The CSV file stream.
options - The load options for reading text file
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




merge 
public void merge(int firstRow, int firstColumn, int totalRows, int totalColumns)

            Merges a specified range of cells into a single cell. 		
            

            Reference the merged cell via the address of the upper-left cell in the range. 
            Parameters:
firstRow - First row of this range(zero based)
firstColumn - First column of this range(zero based)
totalRows - Number of rows(one based)
totalColumns - Number of columns(one based)




merge 
public void merge(int firstRow, int firstColumn, int totalRows, int totalColumns, boolean mergeConflict)

            Merges a specified range of cells into a single cell. 		
            

            Reference the merged cell via the address of the upper-left cell in the range. 
            If mergeConflict is true and the merged range conflicts with other merged cells,
            other merged cells will be  automatically removed.
            Parameters:
firstRow - First row of this range(zero based)
firstColumn - First column of this range(zero based)
totalRows - Number of rows(one based)
totalColumns - Number of columns(one based)
mergeConflict - Merge conflict merged ranges.




merge 
public void merge(int firstRow, int firstColumn, int totalRows, int totalColumns, boolean checkConflict, boolean mergeConflict)

            Merges a specified range of cells into a single cell. 		
            

            Reference the merged cell via the address of the upper-left cell in the range. 
            If mergeConflict is true and the merged range conflicts with other merged cells,
            other merged cells will be  automatically removed.
            Parameters:
firstRow - First row of this range(zero based)
firstColumn - First column of this range(zero based)
totalRows - Number of rows(one based)
totalColumns - Number of columns(one based)
checkConflict - Indicates whether check the merged cells intersects other merged cells
mergeConflict - Merge conflict merged ranges.




unMerge 
public void unMerge(int firstRow, int firstColumn, int totalRows, int totalColumns)

            Unmerges a specified range of merged cells. 		
            
Parameters:
firstRow - First row of this range(zero based)
firstColumn - First column of this range(zero based)
totalRows - Number of rows(one based)
totalColumns - Number of columns(one based)




clearMergedCells 
public void clearMergedCells()

            Clears all merged ranges.
            




hideRow 
public void hideRow(int row)

            Hides a row.
            
Parameters:
row - Row index.




unhideRow 
public void unhideRow(int row, double height)

            Unhides a row.
            
Parameters:
row - Row index.
height - Row height. The row's height will be changed only when the row is hidden and given height value is positive.




hideRows 
public void hideRows(int row, int totalRows)

            Hides multiple rows.
            
Parameters:
row - The row index.
totalRows - The row number.




unhideRows 
public void unhideRows(int row, int totalRows, double height)

            Unhides the hidden rows.
            
Parameters:
row - The row index.
totalRows - The row number.
height - Row height. The row's height will be changed only when the row is hidden and given height value is positive.




setRowHeightPixel 
public void setRowHeightPixel(int row, int pixels)

            Sets row height in unit of pixels.
            
Parameters:
row - Row index.
pixels - Number of pixels.




setRowHeightInch 
public void setRowHeightInch(int row, double inches)

            Sets row height in unit of inches.
            
Parameters:
row - Row index.
inches - Number of inches. It should be between 0 and 409.5/72.




setRowHeight 
public void setRowHeight(int row, double height)

            Sets the height of the specified row.
            
Parameters:
row - Row index.
height - Height of row.In unit of point It should be between 0 and 409.5.




getRowOriginalHeightPoint 
public double getRowOriginalHeightPoint(int row)

            Gets original row's height in unit of point if the row is hidden 
            
Parameters:
row - The row index.
Returns:





hideColumn 
public void hideColumn(int column)

            Hides a column.
            
Parameters:
column - Column index.




unhideColumn 
public void unhideColumn(int column, double width)

            Unhides a column
            
Parameters:
column - Column index.
width - Column width.




hideColumns 
public void hideColumns(int column, int totalColumns)

            Hide multiple columns.
            
Parameters:
column - Column index.
totalColumns - Column number.




unhideColumns 
public void unhideColumns(int column, int totalColumns, double width)

            Unhide multiple columns.
            

            Only applies the column width to the hidden columns.
            Parameters:
column - Column index.
totalColumns - Column number
width - Column width.




getRowHeight 
public double getRowHeight(int row)

            Gets the height of a specified row.
            
Parameters:
row - Row index
Returns:
Height of row




getViewRowHeight 
public double getViewRowHeight(int row)

            Gets the height of a specified row.
            
Parameters:
row - Row index
Returns:
Height of row




getRowHeightPixel 
public int getRowHeightPixel(int row)

            Gets the height of a specified row in unit of pixel.
            
Parameters:
row - Row index
Returns:
Height of row




getRowHeightInch 
public double getRowHeightInch(int row)

            Gets the height of a specified row in unit of inches.
            
Parameters:
row - Row index
Returns:
Height of row




getViewRowHeightInch 
public double getViewRowHeightInch(int row)

            Gets the height of a specified row in unit of inches.
            
Parameters:
row - Row index
Returns:
Height of row




setColumnWidthPixel 
public void setColumnWidthPixel(int column, int pixels)

            Sets column width in unit of pixels in normal view.
            
Parameters:
column - Column index.
pixels - Number of pixels.




setColumnWidthInch 
public void setColumnWidthInch(int column, double inches)

            Sets column width in unit of inches  in normal view.
            
Parameters:
column - Column index.
inches - Number of inches.




setColumnWidth 
public void setColumnWidth(int column, double width)

            Sets the width of the specified column in normal view.
            
To hide a column, sets column width to zero.Parameters:
column - Column index.
width - Width of column.Column width must be between 0 and 255.




getColumnWidthPixel 
public int getColumnWidthPixel(int column)

            Gets the width of the specified column in normal view, in units of pixel.
            
Parameters:
column - Column index
Returns:
Width of column in normal view.




getColumnWidthInch 
public double getColumnWidthInch(int column)

            Gets the width of the specified column in normal view, in units of inches.
            
Parameters:
column - Column index
Returns:
Width of column




getColumnWidth 
public double getColumnWidth(int column)

            Gets the width of the specified column in normal view
            
Parameters:
column - Column index
Returns:
Width of column




getViewColumnWidthPixel 
public int getViewColumnWidthPixel(int column)

            Get the width in different view type.
            
Parameters:
column - The column index.
Returns:
the column width in unit of pixels




setViewColumnWidthPixel 
public void setViewColumnWidthPixel(int column, int pixels)

            Sets the width of the column in different view.
            

            If the current view type is ViewType.PAGE_LAYOUT_VIEW, the column's width is same as printed width.
            Parameters:
column - The column index.
pixels - The width in unit of pixels.




getLastDataRow 
public int getLastDataRow(int column)

            Gets the last row index of cell which contains data in the specified column.
            
Parameters:
column - Column index.
Returns:
last row index.




applyColumnStyle 
public void applyColumnStyle(int column, Style style, StyleFlag flag)

            Applies formats for a whole column.
            
Parameters:
column - The column index.
style - The style object which will be applied.
flag - Flags which indicates applied formatting properties.




applyRowStyle 
public void applyRowStyle(int row, Style style, StyleFlag flag)

            Applies formats for a whole row.
            
Parameters:
row - The row index.
style - The style object which will be applied.
flag - Flags which indicates applied formatting properties.




applyStyle 
public void applyStyle(Style style, StyleFlag flag)

            Applies formats for a whole worksheet.
            
Parameters:
style - The style object which will be applied.
flag - Flags which indicates applied formatting properties.




copyColumns 
public void copyColumns(Cells sourceCells0, int sourceColumnIndex, int destinationColumnIndex, int columnNumber, PasteOptions pasteOptions)
                throws java.lang.Exception

            Copies data and formats of a whole column.
            
Parameters:
sourceCells0 - Source Cells object contains data and formats to copy.
sourceColumnIndex - Source column index.
destinationColumnIndex - Destination column index.
columnNumber - The copied column number.
pasteOptions - the options of pasting.




copyColumn 
public void copyColumn(Cells sourceCells, int sourceColumnIndex, int destinationColumnIndex)
               throws java.lang.Exception

            Copies data and formats of a whole column.
            
Parameters:
sourceCells - Source Cells object contains data and formats to copy.
sourceColumnIndex - Source column index.
destinationColumnIndex - Destination column index.




copyColumns 
public void copyColumns(Cells sourceCells0, int sourceColumnIndex, int destinationColumnIndex, int columnNumber)
                throws java.lang.Exception

            Copies data and formats of a whole column.
            
Parameters:
sourceCells0 - Source Cells object contains data and formats to copy.
sourceColumnIndex - Source column index.
destinationColumnIndex - Destination column index.
columnNumber - The copied column number.




copyColumns 
public void copyColumns(Cells sourceCells, int sourceColumnIndex, int sourceTotalColumns, int destinationColumnIndex, int destinationTotalColumns)
                throws java.lang.Exception

            Copies data and formats of the whole columns.
            
Parameters:
sourceCells - Source Cells object contains data and formats to copy.
sourceColumnIndex - Source column index.
sourceTotalColumns - The number of the source columns.
destinationColumnIndex - Destination column index.
destinationTotalColumns - The number of the destination columns.




copyRow 
public void copyRow(Cells sourceCells, int sourceRowIndex, int destinationRowIndex)
            throws java.lang.Exception

            Copies data and formats of a whole row.
            
Parameters:
sourceCells - Source Cells object contains data and formats to copy.
sourceRowIndex - Source row index.
destinationRowIndex - Destination row index.




copyRows 
public void copyRows(Cells sourceCells, int sourceRowIndex, int destinationRowIndex, int rowNumber)
             throws java.lang.Exception

            Copies data and formats of some whole rows.
            
Parameters:
sourceCells - Source Cells object contains data and formats to copy.
sourceRowIndex - Source row index.
destinationRowIndex - Destination row index.
rowNumber - The copied row number.




copyRows 
public void copyRows(Cells sourceCells0, int sourceRowIndex, int destinationRowIndex, int rowNumber, CopyOptions copyOptions)
             throws java.lang.Exception

            Copies data and formats of some whole rows.
            
Parameters:
sourceCells0 - Source Cells object contains data and formats to copy.
sourceRowIndex - Source row index.
destinationRowIndex - Destination row index.
rowNumber - The copied row number.
copyOptions - The copy options.




copyRows 
public void copyRows(Cells sourceCells0, int sourceRowIndex, int destinationRowIndex, int rowNumber, CopyOptions copyOptions, PasteOptions pasteOptions)
             throws java.lang.Exception

            Copies data and formats of some whole rows.
            
Parameters:
sourceCells0 - Source Cells object contains data and formats to copy.
sourceRowIndex - Source row index.
destinationRowIndex - Destination row index.
rowNumber - The copied row number.
copyOptions - The copy options.
pasteOptions - the options of pasting.




getGroupedRowOutlineLevel 
public int getGroupedRowOutlineLevel(int rowIndex)

            Gets the outline level (zero-based) of the row.
            
If the row is not grouped, returns zero.Parameters:
rowIndex - The row index.
Returns:
The outline level (zero-based) of the row.




getGroupedColumnOutlineLevel 
public int getGroupedColumnOutlineLevel(int columnIndex)

            Gets the outline level (zero-based) of the column.
            
If the column is not grouped, returns zero.Parameters:
columnIndex - The column index
Returns:
The outline level of the column




getMaxGroupedColumnOutlineLevel 
public int getMaxGroupedColumnOutlineLevel()

            Gets the max grouped column outline level (zero-based).
            
Returns:
 The max grouped column outline level (zero-based)




getMaxGroupedRowOutlineLevel 
public int getMaxGroupedRowOutlineLevel()

            Gets the max grouped row outline level (zero-based).
            
Returns:
 The max grouped row outline level (zero-based)




showGroupDetail 
public void showGroupDetail(boolean isVertical, int index)

            Expands the grouped rows/columns. 
            
Parameters:
isVertical - True, expands the grouped rows.
index - The row/column index




hideGroupDetail 
public void hideGroupDetail(boolean isVertical, int index)

            Collapses the grouped rows/columns. 
            
Parameters:
isVertical - True, collapse the grouped rows.
index - The row/column index




ungroupColumns 
public void ungroupColumns(int firstIndex, int lastIndex)

            Ungroups columns.
            
Parameters:
firstIndex - The first column index to be ungrouped.
lastIndex - The last column index to be ungrouped.




groupColumns 
public void groupColumns(int firstIndex, int lastIndex)

            Groups columns.
            
Parameters:
firstIndex - The first column index to be grouped.
lastIndex - The last column index to be grouped.




groupColumns 
public void groupColumns(int firstIndex, int lastIndex, boolean isHidden)

            Groups columns.
            
Parameters:
firstIndex - The first column index to be grouped.
lastIndex - The last column index to be grouped.
isHidden - Specifies if the grouped columns are hidden.




ungroupRows 
public void ungroupRows(int firstIndex, int lastIndex, boolean isAll)

            Ungroups rows.
            
Parameters:
firstIndex - The first row index to be ungrouped.
lastIndex - The last row index to be ungrouped.
isAll - True, removes all grouped info.Otherwise, remove the outer group info.




ungroupRows 
public void ungroupRows(int firstIndex, int lastIndex)

            Ungroups rows.
            

            Only removes outer group info.
            Parameters:
firstIndex - The first row index to be ungrouped.
lastIndex - The last row index to be ungrouped.




groupRows 
public void groupRows(int firstIndex, int lastIndex, boolean isHidden)

            Groups rows.
            
Parameters:
firstIndex - The first row index to be grouped.
lastIndex - The last row index to be grouped.
isHidden - Specifies if the grouped columns are hidden.




groupRows 
public void groupRows(int firstIndex, int lastIndex)

            Groups rows.
            
Parameters:
firstIndex - The first row index to be grouped.
lastIndex - The last row index to be grouped.




deleteColumn 
public void deleteColumn(int columnIndex, boolean updateReference)

            Deletes a column.
            
Parameters:
columnIndex - Column index.
updateReference - Indicates if update references in other worksheets.




deleteColumn 
public void deleteColumn(int columnIndex)

            Deletes a column.
            
Parameters:
columnIndex - Column index.




deleteColumns 
public void deleteColumns(int columnIndex, int totalColumns, boolean updateReference)

            Deletes several columns.
            
Parameters:
columnIndex - Column index.
totalColumns - Number of columns to be deleted.
updateReference - Indicates if update references in other worksheets.




isDeletingRangeEnabled 
public boolean isDeletingRangeEnabled(int startRow, int startColumn, int totalRows, int totalColumns)

            Check whether the range could be deleted.
            
Parameters:
startRow - The start row index of the range.
startColumn - The start column index of the range.
totalRows - The number of the rows in the range.
totalColumns - The number of the columns in the range.
Returns:





deleteRows 
public boolean deleteRows(int rowIndex, int totalRows)

            Deletes several rows.
            

            If the deleted range contains the top part(not whole) of the table(ListObject),
            the ranged could not be deleted and nothing will be done.It works as MS Excel.
            Parameters:
rowIndex - The first row index to be deleted.
totalRows - Number of rows to be deleted.




deleteRow 
public void deleteRow(int rowIndex)

            Deletes a row.
            
Parameters:
rowIndex - Row index.




deleteRows 
public boolean deleteRows(int rowIndex, int totalRows, boolean updateReference)

            Deletes multiple rows in the worksheet.
            
Parameters:
rowIndex - Row index.
totalRows - Number of rows to be deleted.
updateReference - Indicates if update references in other worksheets.
Returns:





deleteBlankColumns 
public void deleteBlankColumns()

            Delete all blank columns which do not contain any data.
            




deleteBlankColumns 
public void deleteBlankColumns(DeleteOptions options)

            Delete all blank columns which do not contain any data.
            
Parameters:
options - The options of deleting range.




isBlankColumn 
public boolean isBlankColumn(int columnIndex)

            Checks whether given column is blank(does not contain any data).
            
Parameters:
columnIndex - the column index
Returns:
true if given column does not contain any data




deleteBlankRows 
public void deleteBlankRows()

            Delete all blank rows which do not contain any data.
            




deleteBlankRows 
public void deleteBlankRows(DeleteOptions options)

            Delete all blank rows which do not contain any data.
            
Parameters:
options - The options of deleting range.




insertColumns 
public void insertColumns(int columnIndex, int totalColumns)

            Inserts some columns into the worksheet.
            
Parameters:
columnIndex - Column index.
totalColumns - The number of columns.




insertColumns 
public void insertColumns(int columnIndex, int totalColumns, boolean updateReference)

            Inserts some columns into the worksheet.
            
Parameters:
columnIndex - Column index.
totalColumns - The number of columns.
updateReference - Indicates if references in other worksheets will be updated.




insertColumn 
public void insertColumn(int columnIndex, boolean updateReference)

            Inserts a new column into the worksheet.
            
Parameters:
columnIndex - Column index.
updateReference - Indicates if references in other worksheets will be updated.




insertColumn 
public void insertColumn(int columnIndex)

            Inserts a new column into the worksheet.
            
Parameters:
columnIndex - Column index.




insertRows 
public void insertRows(int rowIndex, int totalRows, boolean updateReference)

            Inserts multiple rows into the worksheet.
            
Parameters:
rowIndex - Row index.
totalRows - Number of rows to be inserted.
updateReference - Indicates if references in other worksheets will be updated.




insertRows 
public void insertRows(int rowIndex, int totalRows, InsertOptions options)

            Inserts multiple rows into the worksheet.
            
Parameters:
rowIndex - Row index.
totalRows - Number of rows to be inserted.
options - Indicates if references in other worksheets will be updated.




insertRows 
public void insertRows(int rowIndex, int totalRows)

            Inserts multiple rows into the worksheet.
            
Parameters:
rowIndex - Row index.
totalRows - Number of rows to be inserted.




insertRow 
public void insertRow(int rowIndex)

            Inserts a new row into the worksheet.
            
Parameters:
rowIndex - Row index.




clearRange 
public void clearRange(CellArea range)

            Clears contents and formatting of a range.
            
Parameters:
range - Range to be cleared.




clearRange 
public void clearRange(int startRow, int startColumn, int endRow, int endColumn)

            Clears contents and formatting of a range.
            
Parameters:
startRow - Start row index.
startColumn - Start column index.
endRow - End row index.
endColumn - End column index.




clearContents 
public void clearContents(CellArea range)

            Clears contents of a range.
            
Parameters:
range - Range to be cleared.




clearContents 
public void clearContents(int startRow, int startColumn, int endRow, int endColumn)

            Clears contents of a range.
            
Parameters:
startRow - Start row index.
startColumn - Start column index.
endRow - End row index.
endColumn - End column index.




clearFormats 
public void clearFormats(CellArea range)

            Clears formatting of a range.
            
Parameters:
range - Range to be cleared.




clearFormats 
public void clearFormats(int startRow, int startColumn, int endRow, int endColumn)

            Clears formatting of a range.
            
Parameters:
startRow - Start row index.
startColumn - Start column index.
endRow - End row index.
endColumn - End column index.




dispose 
public void dispose()

            Performs application-defined tasks associated with freeing, releasing, or
            resetting unmanaged resources.
            




iterator 
public java.util.Iterator iterator()

            Gets the cells enumerator.
            
When traversing elements by the returned Enumerator, the cells collection
            should not be modified(such as operations that will cause new Cell/Row be instantiated or existing Cell/Row be deleted).
            Otherwise the enumerator may not be able to traverse all cells correctly(some elements may be traversed repeatedly or skipped).Returns:
The cells enumerator




getRowEnumerator 
public java.util.Iterator getRowEnumerator()

            Gets the rows enumerator.
            
Returns:
The rows enumerator.
See Also:
RowCollection.iterator()




getCell 
public Cell getCell(int row, int column)

            Gets the Cell element at the specified cell row index and column index.
            

            NOTE: This member is now obsolete. Instead, 
            please use Cells.Get(int,int) method.
            This method will be removed 12 months later since JANUARY 2012. 
            Aspose apologizes for any inconvenience you may have experienced.Parameters:
row - Row index
column - Column index
Returns:
Return Cell object.
            




getRow 
public Row getRow(int row)

             Gets the Row element or at the specified cell row index.
            

            NOTE: This member is now obsolete. Instead, 
            please use RowCollection[int] method.
            This method will be removed 12 months later since JANUARY 2010. 
            Aspose apologizes for any inconvenience you may have experienced.Parameters:
row - Row index
Returns:

            return the row object.
            




getColumn 
public Column getColumn(int columnIndex)

            Gets the Column element or at the specified cell row index.
            

            NOTE: This member is now obsolete. Instead, 
            please use ColumnCollection[int] method.
            This method will be removed 12 months later since JANUARY 2010. 
            Aspose apologizes for any inconvenience you may have experienced.Parameters:
columnIndex - The column index.
Returns:





checkCell 
public Cell checkCell(int row, int column)

            Gets the Cell element or null at the specified cell row index and column index.
            
Parameters:
row - Row index
column - Column index
Returns:
Return Cell object if a Cell object exists.
            Return null if the cell does not exist.
            




checkRow 
public Row checkRow(int row)

             Gets the Row element or at the specified cell row index.
            
Parameters:
row - Row index
Returns:

            If the row object does exist return Row object, otherwise return null.
            




checkColumn 
public Column checkColumn(int columnIndex)

             Gets the Column element or null at the specified column index.
            
Parameters:
columnIndex - The column index.
Returns:
The Column object.




isRowHidden 
public boolean isRowHidden(int rowIndex)

            Checks whether a row at given index is hidden.
            
Parameters:
rowIndex - row index
Returns:
true if the row is hidden




isColumnHidden 
public boolean isColumnHidden(int columnIndex)

            Checks whether a column at given index is hidden.
            
Parameters:
columnIndex - column index
Returns:
true if the column is hidden.




addRange 
public void addRange(Range rangeObject)

            Adds a range object reference to cells
            
Parameters:
rangeObject - The range object will be contained in the cells




createRange 
public Range createRange(java.lang.String upperLeftCell, java.lang.String lowerRightCell)

            Creates a Range object from a range of cells.
            
Parameters:
upperLeftCell - Upper left cell name.
lowerRightCell - Lower right cell name.
Returns:
A Range object




createRange 
public Range createRange(int firstRow, int firstColumn, int totalRows, int totalColumns)

            Creates a Range object from a range of cells.
            
Parameters:
firstRow - First row of this range
firstColumn - First column of this range
totalRows - Number of rows
totalColumns - Number of columns
Returns:
A Range object




createRange 
public Range createRange(java.lang.String address)

             Creates a Range object from an address of the range.
            
Parameters:
address - The address of the range.
Returns:
A Range object




createRange 
public Range createRange(int firstIndex, int number, boolean isVertical)

            Creates a Range object from rows of cells or columns of cells.
            
Parameters:
firstIndex - First row index or first column index, zero based.
number - Total number of rows or columns, one based.
isVertical - True - Range created from columns of cells. False - Range created from rows of cells. 
Returns:
A Range object.




clear 
public void clear()

            Clears all cell and row objects.
            




importData 
public int importData(ICellsDataTable table, int firstRow, int firstColumn, ImportTableOptions options)
              throws java.lang.Exception

            Import data from custom data table.
            
Parameters:
table - The custom data table.
firstRow - First row index.
firstColumn - First column index.
options - The import options
Returns:





importTwoDimensionArray 
public void importTwoDimensionArray(java.lang.Object[][] objArray, int firstRow, int firstColumn)

            Imports a two-dimension array of data into a worksheet.
            
Parameters:
objArray - Two-dimension data array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




importTwoDimensionArray 
public void importTwoDimensionArray(java.lang.Object[][] objArray, int firstRow, int firstColumn, boolean convertStringToNumber)

            Imports a two-dimension array of data into a worksheet.
            
Parameters:
objArray - Two-dimension data array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
convertStringToNumber - Indicates if this method will try to convert string to number.




importTwoDimensionArray 
public void importTwoDimensionArray(java.lang.Object[][] objArray, java.lang.Object[][] styles, int firstRow, int firstColumn, boolean convertStringToNumber)

            Imports a two-dimension array of data into a worksheet.
            
Parameters:
objArray - Two-dimension data array.
styles - Two-dimension data style.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
convertStringToNumber - Indicates if this method will try to convert string to number.




importTwoDimensionArray 
public void importTwoDimensionArray(java.lang.Object[][] objArray, java.lang.Object[][] styles, int firstRow, int firstColumn, TxtLoadOptions opts)

            Imports a two-dimension array of data into a worksheet.
            
Parameters:
objArray - Two-dimension data array.
styles - Two-dimension data style.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
opts - Options for converting string values




importObjectArray 
public void importObjectArray(java.lang.Object[] objArray, int firstRow, int firstColumn, boolean isVertical)
                      throws java.lang.Exception

            Imports an array of data into a worksheet.
            
Parameters:
objArray - Data array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
isVertical - Specifies to import data vertically or horizontally.




importArrayList 
public void importArrayList(java.util.ArrayList arrayList, int firstRow, int firstColumn, boolean isVertical)
                    throws java.lang.Exception

            Imports an arraylist of data into a worksheet.
            
Parameters:
arrayList - Data arraylist.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
isVertical - Specifies to import data vertically or horizontally.




importObjectArray 
public void importObjectArray(java.lang.Object[] objArray, int firstRow, int firstColumn, boolean isVertical, int skip)

            Imports an array of data into a worksheet.
            
Parameters:
objArray - Data array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
isVertical - Specifies to import data vertically or horizontally.
skip - Skipped number of rows or columns.




importArray 
public void importArray(java.lang.String[][] stringArray, int firstRow, int firstColumn)
                throws java.lang.Exception

            Imports a two-dimension array of string into a worksheet.
            
Parameters:
stringArray - Two-dimension string array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




importFormulaArray 
public void importFormulaArray(java.lang.String[] stringArray, int firstRow, int firstColumn, boolean isVertical)

            Imports an array of formula into a worksheet.
            
Parameters:
stringArray - Formula array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
isVertical - Specifies to import data vertically or horizontally.




importArray 
public void importArray(java.lang.String[] stringArray, int firstRow, int firstColumn, boolean isVertical)
                throws java.lang.Exception

            Imports an array of string into a worksheet.
            
Parameters:
stringArray - String array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
isVertical - Specifies to import data vertically or horizontally.




importArray 
public void importArray(int[][] intArray, int firstRow, int firstColumn)
                throws java.lang.Exception

            Imports a two-dimension array of integer into a worksheet.
            
Parameters:
intArray - Two-dimension integer array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




importArray 
public void importArray(int[] intArray, int firstRow, int firstColumn, boolean isVertical)
                throws java.lang.Exception

            Imports an array of integer into a worksheet.
            
Parameters:
intArray - Integer array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
isVertical - Specifies to import data vertically or horizontally.




importArray 
public void importArray(double[][] doubleArray, int firstRow, int firstColumn)
                throws java.lang.Exception

            Imports a two-dimension array of double into a worksheet.
            
Parameters:
doubleArray - Two-dimension double array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




importArray 
public void importArray(double[] doubleArray, int firstRow, int firstColumn, boolean isVertical)
                throws java.lang.Exception

            Imports an array of double into a worksheet.
            
Parameters:
doubleArray - Double array.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.
isVertical - Specifies to import data vertically or horizontally.




textToColumns 
public void textToColumns(int row, int column, int totalRows, TxtLoadOptions options)
                  throws java.lang.Exception

            Splits the text in the column to columns.
            
Parameters:
row - The row index.
column - The column index.
totalRows - The number of rows.
options - The split options.




importCSV 
public void importCSV(java.lang.String fileName, java.lang.String splitter, boolean convertNumericData, int firstRow, int firstColumn)
              throws java.lang.Exception

            Import a CSV file to the cells.
            
Parameters:
fileName - The CSV file name.
splitter - The splitter
convertNumericData -  Whether the string in text file is converted to numeric data.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




importCSV 
public void importCSV(java.io.InputStream stream, java.lang.String splitter, boolean convertNumericData, int firstRow, int firstColumn)
              throws java.lang.Exception

            Import a CSV file to the cells.
            
Parameters:
stream - The CSV file stream.
splitter - The splitter
convertNumericData -  Whether the string in text file is converted to numeric data.
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




importCSV 
public void importCSV(java.lang.String fileName, TxtLoadOptions options, int firstRow, int firstColumn)
              throws java.lang.Exception

            Import a CSV file to the cells.
            
Parameters:
fileName - The CSV file name.
options - The load options for reading text file
firstRow - The row number of the first cell to import in.
firstColumn - The column number of the first cell to import in.




See Also:


          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.

          Aspose.Cells Support Forum - our preferred method of support.
We guarantee a prompt response to any inquiry!
© 2003-2022 Aspose Pty Ltd. All rights reserved.

Property Getters/Setters Summary
`ColumnCollection`	`getColumns()`
	Gets the collection of Column objects that represents the individual columns in this worksheet.
`int`	`getCount()`
	Gets the total count of instantiated Cell objects.
`long`	`getCountLarge()`
	Gets the total count of instantiated Cell objects.
`Cell`	`getFirstCell()`
	Gets the first cell in this worksheet.
`boolean`	`isDefaultRowHeightMatched()`
`void`	`setDefaultRowHeightMatched(boolean)`
	Indicates that row height and default font height matches
`boolean`	`isDefaultRowHidden()`
`void`	`setDefaultRowHidden(boolean)`
	Indicates whether the row is default hidden.
`Cell`	`getLastCell()`
	Gets the last cell in this worksheet.
`int`	`getMaxColumn()`
	Minimum column index of those cells that have been instantiated in the collection(does not include the column where style is defined for the whole column but no cell has been instantiated in it).
`int`	`getMaxDataColumn()`
	Maximum column index of cell which contains data.
`int`	`getMaxDataRow()`
	Maximum row index of cell which contains data.
`Range`	`getMaxDisplayRange()`
	Gets the max range which includes data, merged cells and shapes.
`int`	`getMaxRow()`
	Maximum row index of cell which contains data or style.
`int`	`getMemorySetting()`
`void`	`setMemorySetting(int)`
	Gets or sets the memory usage option for this cells. The value of the property is MemorySetting integer constant.
`java.util.ArrayList`	`getMergedCells()`
	Gets the collection of merged cells.
`int`	`getMinColumn()`
	Minimum column index of those cells that have been instantiated in the collection(does not include the column where style is defined for the whole column but no cell has been instantiated in it).
`int`	`getMinDataColumn()`
	Minimum column index of cell which contains data.
`int`	`getMinDataRow()`
	Minimum row index of cell which contains data.
`int`	`getMinRow()`
	Minimum row index of cell which contains data or style.
`boolean`	`getMultiThreadReading()`
`void`	`setMultiThreadReading(boolean)`
	Gets or sets whether the cells data model should support Multi-Thread reading. Default value of this property is false.
`OdsCellFieldCollection`	`getOdsCellFields()`
	Gets the list of fields of ods.
`boolean`	`getPreserveString()`
`void`	`setPreserveString(boolean)`
	Gets or sets a value indicating whether all worksheet values are preserved as strings. Default is false.
`RangeCollection`	`getRanges()`
	Gets the collection of Range objects created at run time.
`RowCollection`	`getRows()`
	Gets the collection of Row objects that represents the individual rows in this worksheet.
`double`	`getStandardHeight()`
`void`	`setStandardHeight(double)`
	Gets or sets the default row height in this worksheet, in unit of points.
`double`	`getStandardHeightInch()`
`void`	`setStandardHeightInch(double)`
	Gets or sets the default row height in this worksheet, in unit of inches.
`int`	`getStandardHeightPixels()`
`void`	`setStandardHeightPixels(int)`
	Gets or sets the default row height in this worksheet, in unit of pixels.
`double`	`getStandardWidth()`
`void`	`setStandardWidth(double)`
	Gets or sets the default column width in the worksheet, in unit of characters.
`double`	`getStandardWidthInch()`
`void`	`setStandardWidthInch(double)`
	Gets or sets the default column width in the worksheet, in unit of inches.
`int`	`getStandardWidthPixels()`
`void`	`setStandardWidthPixels(int)`
	Gets or sets the default column width in the worksheet, in unit of pixels.
`Style`	`getStyle()`
`void`	`setStyle(Style)`
	Gets and sets the default style.
`Cell`	`get(int)`
	Gets Cell item within the worksheet
`Cell`	`get(int, int)`
	Gets the Cell element at the specified cell row index and column index.
`Cell`	`get(java.lang.String)`
	Gets the Cell element at the specified cell name.

Method Summary
`void`	`addRange(Range rangeObject)`
`void`	Adds a range object reference to cells
`void`	`applyColumnStyle(int column, Style style, StyleFlag flag)`
`void`	Applies formats for a whole column.
`void`	`applyRowStyle(int row, Style style, StyleFlag flag)`
`void`	Applies formats for a whole row.
`void`	`applyStyle(Style style, StyleFlag flag)`
`void`	Applies formats for a whole worksheet.
`Cell`	`checkCell(int row, int column)`
`Cell`	Gets the Cell element or null at the specified cell row index and column index.
`Column`	`checkColumn(int columnIndex)`
`Column`	Gets the Column element or null at the specified column index.
`Row`	`checkRow(int row)`
`Row`	Gets the Row element or at the specified cell row index.
`void`	`clear()`
`void`	Clears all cell and row objects.
`void`	`clearContents(CellArea range)`
`void`	Clears contents of a range.
`void`	`clearContents(int startRow, int startColumn, int endRow, int endColumn)`
`void`	Clears contents of a range.
`void`	`clearFormats(CellArea range)`
`void`	Clears formatting of a range.
`void`	`clearFormats(int startRow, int startColumn, int endRow, int endColumn)`
`void`	Clears formatting of a range.
`void`	`clearMergedCells()`
`void`	Clears all merged ranges.
`void`	`clearRange(CellArea range)`
`void`	Clears contents and formatting of a range.
`void`	`clearRange(int startRow, int startColumn, int endRow, int endColumn)`
`void`	Clears contents and formatting of a range.
`void`	`convertStringToNumericValue()`
`void`	Converts string data in cells to numeric value if possible.
`void`	`copyColumn(Cells sourceCells, int sourceColumnIndex, int destinationColumnIndex)`
`void`	Copies data and formats of a whole column.
`void`	`copyColumns(Cells sourceCells0, int sourceColumnIndex, int destinationColumnIndex, int columnNumber)`
`void`	Copies data and formats of a whole column.
`void`	`copyColumns(Cells sourceCells0, int sourceColumnIndex, int destinationColumnIndex, int columnNumber, PasteOptions pasteOptions)`
`void`	Copies data and formats of a whole column.
`void`	`copyColumns(Cells sourceCells, int sourceColumnIndex, int sourceTotalColumns, int destinationColumnIndex, int destinationTotalColumns)`
`void`	Copies data and formats of the whole columns.
`void`	`copyRow(Cells sourceCells, int sourceRowIndex, int destinationRowIndex)`
`void`	Copies data and formats of a whole row.
`void`	`copyRows(Cells sourceCells, int sourceRowIndex, int destinationRowIndex, int rowNumber)`
`void`	Copies data and formats of some whole rows.
`void`	`copyRows(Cells sourceCells0, int sourceRowIndex, int destinationRowIndex, int rowNumber, CopyOptions copyOptions)`
`void`	Copies data and formats of some whole rows.
`void`	`copyRows(Cells sourceCells0, int sourceRowIndex, int destinationRowIndex, int rowNumber, CopyOptions copyOptions, PasteOptions pasteOptions)`
`void`	Copies data and formats of some whole rows.
`Range`	`createRange(int firstIndex, int number, boolean isVertical)`
`Range`	Creates a Range object from rows of cells or columns of cells.
`Range`	`createRange(int firstRow, int firstColumn, int totalRows, int totalColumns)`
`Range`	Creates a Range object from a range of cells.
`Range`	`createRange(java.lang.String address)`
`Range`	Creates a Range object from an address of the range.
`Range`	`createRange(java.lang.String upperLeftCell, java.lang.String lowerRightCell)`
`Range`	Creates a Range object from a range of cells.
`void`	`deleteBlankColumns()`
`void`	Delete all blank columns which do not contain any data.
`void`	`deleteBlankColumns(DeleteOptions options)`
`void`	Delete all blank columns which do not contain any data.
`void`	`deleteBlankRows()`
`void`	Delete all blank rows which do not contain any data.
`void`	`deleteBlankRows(DeleteOptions options)`
`void`	Delete all blank rows which do not contain any data.
`void`	`deleteColumn(int columnIndex)`
`void`	Deletes a column.
`void`	`deleteColumn(int columnIndex, boolean updateReference)`
`void`	Deletes a column.
`void`	`deleteColumns(int columnIndex, int totalColumns, boolean updateReference)`
`void`	Deletes several columns.
`void`	`deleteRange(int startRow, int startColumn, int endRow, int endColumn, int shiftType)`
`void`	Deletes a range of cells and shift cells according to the shift option.
`void`	`deleteRow(int rowIndex)`
`void`	Deletes a row.
`boolean`	`deleteRows(int rowIndex, int totalRows)`
`boolean`	Deletes several rows.
`boolean`	`deleteRows(int rowIndex, int totalRows, boolean updateReference)`
`boolean`	Deletes multiple rows in the worksheet.
`void`	`dispose()`
`void`	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
`Cell`	`endCellInColumn(int startRow, int endRow, short startColumn, short endColumn)`
`Cell`	Gets the last cell with maximum column index in this range.
`Cell`	`endCellInColumn(short columnIndex)`
`Cell`	Gets the last cell in this column.
`Cell`	`endCellInRow(int rowIndex)`
`Cell`	Gets the last cell in this row.
`Cell`	`endCellInRow(int startRow, int endRow, int startColumn, int endColumn)`
`Cell`	Gets the last cell with maximum row index in this range.
`java.lang.Object[][]`	`exportArray(int firstRow, int firstColumn, int totalRows, int totalColumns)`
`java.lang.Object[][]`	Exports data in the Cells collection to a two-dimension array object.
`int[][]`	`exportTypeArray(int firstRow, int firstColumn, int totalRows, int totalColumns)`
`int[][]`	Exports cell value type in the Cells collection to a two-dimension array object.
`Cell`	`find(java.lang.Object what, Cell previousCell)`
`Cell`	Finds the cell containing with the input object.
`Cell`	`find(java.lang.Object what, Cell previousCell, FindOptions findOptions)`
`Cell`	Finds the cell containing with the input object.
`Cell`	`findFormula(java.lang.String formula, Cell previousCell)`
`Cell`	Finds the cell with the input string.
`Cell`	`findFormulaContains(java.lang.String formula, Cell previousCell)`
`Cell`	Finds the cell with formula which contains the input string.
`Cell`	`getCell(int row, int column)`
`Cell`	Gets the Cell element at the specified cell row index and column index.
`Style`	`getCellStyle(int row, int column)`
`Style`	Get the style of given cell.
`Column`	`getColumn(int columnIndex)`
`Column`	Gets the Column element or at the specified cell row index.
`double`	`getColumnWidth(int column)`
`double`	Gets the width of the specified column in normal view
`double`	`getColumnWidthInch(int column)`
`double`	Gets the width of the specified column in normal view, in units of inches.
`int`	`getColumnWidthPixel(int column)`
`int`	Gets the width of the specified column in normal view, in units of pixel.
`com.aspose.cells.Cell[]`	`getDependents(boolean isAll, int row, int column)`
`com.aspose.cells.Cell[]`	Get all cells which refer to the specific cell.
`int`	`getGroupedColumnOutlineLevel(int columnIndex)`
`int`	Gets the outline level (zero-based) of the column.
`int`	`getGroupedRowOutlineLevel(int rowIndex)`
`int`	Gets the outline level (zero-based) of the row.
`int`	`getLastDataRow(int column)`
`int`	Gets the last row index of cell which contains data in the specified column.
`int`	`getMaxGroupedColumnOutlineLevel()`
`int`	Gets the max grouped column outline level (zero-based).
`int`	`getMaxGroupedRowOutlineLevel()`
`int`	Gets the max grouped row outline level (zero-based).
`Row`	`getRow(int row)`
`Row`	Gets the Row element or at the specified cell row index.
`java.util.Iterator`	`getRowEnumerator()`
`java.util.Iterator`	Gets the rows enumerator.
`double`	`getRowHeight(int row)`
`double`	Gets the height of a specified row.
`double`	`getRowHeightInch(int row)`
`double`	Gets the height of a specified row in unit of inches.
`int`	`getRowHeightPixel(int row)`
`int`	Gets the height of a specified row in unit of pixel.
`double`	`getRowOriginalHeightPoint(int row)`
`double`	Gets original row's height in unit of point if the row is hidden
`int`	`getViewColumnWidthPixel(int column)`
`int`	Get the width in different view type.
`double`	`getViewRowHeight(int row)`
`double`	Gets the height of a specified row.
`double`	`getViewRowHeightInch(int row)`
`double`	Gets the height of a specified row in unit of inches.
`void`	`groupColumns(int firstIndex, int lastIndex)`
`void`	Groups columns.
`void`	`groupColumns(int firstIndex, int lastIndex, boolean isHidden)`
`void`	Groups columns.
`void`	`groupRows(int firstIndex, int lastIndex)`
`void`	Groups rows.
`void`	`groupRows(int firstIndex, int lastIndex, boolean isHidden)`
`void`	Groups rows.
`void`	`hideColumn(int column)`
`void`	Hides a column.
`void`	`hideColumns(int column, int totalColumns)`
`void`	Hide multiple columns.
`void`	`hideGroupDetail(boolean isVertical, int index)`
`void`	Collapses the grouped rows/columns.
`void`	`hideRow(int row)`
`void`	Hides a row.
`void`	`hideRows(int row, int totalRows)`
`void`	Hides multiple rows.
`void`	`importArray(double[] doubleArray, int firstRow, int firstColumn, boolean isVertical)`
`void`	Imports an array of double into a worksheet.
`void`	`importArray(double[][] doubleArray, int firstRow, int firstColumn)`
`void`	Imports a two-dimension array of double into a worksheet.
`void`	`importArray(int[] intArray, int firstRow, int firstColumn, boolean isVertical)`
`void`	Imports an array of integer into a worksheet.
`void`	`importArray(int[][] intArray, int firstRow, int firstColumn)`
`void`	Imports a two-dimension array of integer into a worksheet.
`void`	`importArray(java.lang.String[] stringArray, int firstRow, int firstColumn, boolean isVertical)`
`void`	Imports an array of string into a worksheet.
`void`	`importArray(java.lang.String[][] stringArray, int firstRow, int firstColumn)`
`void`	Imports a two-dimension array of string into a worksheet.
`void`	`importArrayList(java.util.ArrayList arrayList, int firstRow, int firstColumn, boolean isVertical)`
`void`	Imports an arraylist of data into a worksheet.
`void`	`importCSV(java.io.InputStream stream, TxtLoadOptions options, int firstRow, int firstColumn)`
`void`	Import a CSV file to the cells.
`void`	`importCSV(java.io.InputStream stream, java.lang.String splitter, boolean convertNumericData, int firstRow, int firstColumn)`
`void`	Import a CSV file to the cells.
`void`	`importCSV(java.lang.String fileName, TxtLoadOptions options, int firstRow, int firstColumn)`
`void`	Import a CSV file to the cells.
`void`	`importCSV(java.lang.String fileName, java.lang.String splitter, boolean convertNumericData, int firstRow, int firstColumn)`
`void`	Import a CSV file to the cells.
`int`	`importCustomObjects(java.util.Collection list, int firstRow, int firstColumn, ImportTableOptions options)`
`int`	Imports custom objects.
`int`	`importCustomObjects(java.util.Collection list, java.lang.String[] propertyNames, boolean isPropertyNameShown, int firstRow, int firstColumn, int rowNumber, boolean insertRows, java.lang.String dateFormatString, boolean convertStringToNumber)`
`int`	Imports custom objects.
`int`	`importData(ICellsDataTable table, int firstRow, int firstColumn, ImportTableOptions options)`
`int`	Import data from custom data table.
`void`	`importFormulaArray(java.lang.String[] stringArray, int firstRow, int firstColumn, boolean isVertical)`
`void`	Imports an array of formula into a worksheet.
`void`	`importObjectArray(java.lang.Object[] objArray, int firstRow, int firstColumn, boolean isVertical)`
`void`	Imports an array of data into a worksheet.
`void`	`importObjectArray(java.lang.Object[] objArray, int firstRow, int firstColumn, boolean isVertical, int skip)`
`void`	Imports an array of data into a worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, boolean isFieldNameShown)`
`int`	Imports data in a ResultSet object to the worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, boolean isFieldNameShown, java.lang.String customDateFormatString, boolean convertStringToNumber)`
`int`	Imports data in a ResultSet object to the worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, ImportTableOptions options)`
`int`	Imports data in a ResultSet object to the worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, int rowNum, int columnNum, boolean isFieldNameShown)`
`int`	Imports data in a ResultSet object to the worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, int rowIndex, int columnIndex, int rowNum, int columnNum, boolean isFieldNameShown, java.lang.String customDateFormatString, boolean convertStringToNumber)`
`int`	Imports data in a ResultSet object to the worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, java.lang.String startCell, boolean isFieldNameShown)`
`int`	Imports data in a ResultSet object to the worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, java.lang.String startCell, ImportTableOptions options)`
`int`	Imports data in a ResultSet object to the worksheet.
`int`	`importResultSet(java.sql.ResultSet rs, java.lang.String startCell, int rowNum, int columnNum, boolean isFieldNameShown)`
`int`	Imports data in a ResultSet object to the worksheet.
`void`	`importTwoDimensionArray(java.lang.Object[][] objArray, int firstRow, int firstColumn)`
`void`	Imports a two-dimension array of data into a worksheet.
`void`	`importTwoDimensionArray(java.lang.Object[][] objArray, int firstRow, int firstColumn, boolean convertStringToNumber)`
`void`	Imports a two-dimension array of data into a worksheet.
`void`	`importTwoDimensionArray(java.lang.Object[][] objArray, java.lang.Object[][] styles, int firstRow, int firstColumn, boolean convertStringToNumber)`
`void`	Imports a two-dimension array of data into a worksheet.
`void`	`importTwoDimensionArray(java.lang.Object[][] objArray, java.lang.Object[][] styles, int firstRow, int firstColumn, TxtLoadOptions opts)`
`void`	Imports a two-dimension array of data into a worksheet.
`void`	`insertColumn(int columnIndex)`
`void`	Inserts a new column into the worksheet.
`void`	`insertColumn(int columnIndex, boolean updateReference)`
`void`	Inserts a new column into the worksheet.
`void`	`insertColumns(int columnIndex, int totalColumns)`
`void`	Inserts some columns into the worksheet.
`void`	`insertColumns(int columnIndex, int totalColumns, boolean updateReference)`
`void`	Inserts some columns into the worksheet.
`void`	`insertCutCells(Range cutRange, int row, int column, int shiftType)`
`void`	Insert cut range.
`void`	`insertRange(CellArea area, int shiftType)`
`void`	Inserts a range of cells and shift cells according to the shift option.
`void`	`insertRange(CellArea area, int shiftNumber, int shiftType)`
`void`	Inserts a range of cells and shift cells according to the shift option.
`void`	`insertRange(CellArea area, int shiftNumber, int shiftType, boolean updateReference)`
`void`	Inserts a range of cells and shift cells according to the shift option.
`void`	`insertRow(int rowIndex)`
`void`	Inserts a new row into the worksheet.
`void`	`insertRows(int rowIndex, int totalRows)`
`void`	Inserts multiple rows into the worksheet.
`void`	`insertRows(int rowIndex, int totalRows, boolean updateReference)`
`void`	Inserts multiple rows into the worksheet.
`void`	`insertRows(int rowIndex, int totalRows, InsertOptions options)`
`void`	Inserts multiple rows into the worksheet.
`boolean`	`isBlankColumn(int columnIndex)`
`boolean`	Checks whether given column is blank(does not contain any data).
`boolean`	`isColumnHidden(int columnIndex)`
`boolean`	Checks whether a column at given index is hidden.
`boolean`	`isDeletingRangeEnabled(int startRow, int startColumn, int totalRows, int totalColumns)`
`boolean`	Check whether the range could be deleted.
`boolean`	`isRowHidden(int rowIndex)`
`boolean`	Checks whether a row at given index is hidden.
`java.util.Iterator`	`iterator()`
`java.util.Iterator`	Gets the cells enumerator.
`void`	`linkToXmlMap(java.lang.String mapName, int row, int column, java.lang.String path)`
`void`	Link to a xml map.
`void`	`merge(int firstRow, int firstColumn, int totalRows, int totalColumns)`
`void`	Merges a specified range of cells into a single cell.
`void`	`merge(int firstRow, int firstColumn, int totalRows, int totalColumns, boolean mergeConflict)`
`void`	Merges a specified range of cells into a single cell.
`void`	`merge(int firstRow, int firstColumn, int totalRows, int totalColumns, boolean checkConflict, boolean mergeConflict)`
`void`	Merges a specified range of cells into a single cell.
`void`	`moveRange(CellArea sourceArea, int destRow, int destColumn)`
`void`	Moves the range.
`void`	`removeDuplicates()`
`void`	Removes duplicate rows in the sheet.
`void`	`removeDuplicates(int startRow, int startColumn, int endRow, int endColumn)`
`void`	Removes duplicate values in the range.
`void`	`removeDuplicates(int startRow, int startColumn, int endRow, int endColumn, boolean hasHeaders, int[] columnOffsets)`
`void`	Removes duplicate data of the range.
`void`	`removeFormulas()`
`void`	Removes all formula and replaces with the value of the formula.
`SubtotalSetting`	`retrieveSubtotalSetting(CellArea ca)`
`SubtotalSetting`	Retrieves subtotals setting of the range.
`void`	`setColumnWidth(int column, double width)`
`void`	Sets the width of the specified column in normal view.
`void`	`setColumnWidthInch(int column, double inches)`
`void`	Sets column width in unit of inches in normal view.
`void`	`setColumnWidthPixel(int column, int pixels)`
`void`	Sets column width in unit of pixels in normal view.
`void`	`setRowHeight(int row, double height)`
`void`	Sets the height of the specified row.
`void`	`setRowHeightInch(int row, double inches)`
`void`	Sets row height in unit of inches.
`void`	`setRowHeightPixel(int row, int pixels)`
`void`	Sets row height in unit of pixels.
`void`	`setViewColumnWidthPixel(int column, int pixels)`
`void`	Sets the width of the column in different view.
`void`	`showGroupDetail(boolean isVertical, int index)`
`void`	Expands the grouped rows/columns.
`void`	`subtotal(CellArea ca, int groupBy, int function, int[] totalList)`
`void`	Creates subtotals for the range.
`void`	`subtotal(CellArea ca, int groupBy, int function, int[] totalList, boolean replace, boolean pageBreaks, boolean summaryBelowData)`
`void`	Creates subtotals for the range.
`void`	`textToColumns(int row, int column, int totalRows, TxtLoadOptions options)`
`void`	Splits the text in the column to columns.
`void`	`ungroupColumns(int firstIndex, int lastIndex)`
`void`	Ungroups columns.
`void`	`ungroupRows(int firstIndex, int lastIndex)`
`void`	Ungroups rows.
`void`	`ungroupRows(int firstIndex, int lastIndex, boolean isAll)`
`void`	Ungroups rows.
`void`	`unhideColumn(int column, double width)`
`void`	Unhides a column
`void`	`unhideColumns(int column, int totalColumns, double width)`
`void`	Unhide multiple columns.
`void`	`unhideRow(int row, double height)`
`void`	Unhides a row.
`void`	`unhideRows(int row, int totalRows, double height)`
`void`	Unhides the hidden rows.
`void`	`unMerge(int firstRow, int firstColumn, int totalRows, int totalColumns)`
`void`	Unmerges a specified range of merged cells.

getOdsCellFields
public OdsCellFieldCollection getOdsCellFields()

getMergedCells
public java.util.ArrayList getMergedCells()

getMultiThreadReading/setMultiThreadReading
public boolean getMultiThreadReading() / public void setMultiThreadReading(boolean value)

setMultiThreadReading
public void setMultiThreadReading(boolean value)

getMemorySetting/setMemorySetting
public int getMemorySetting() / public void setMemorySetting(int value)

getStyle/setStyle
public Style getStyle() / public void setStyle(Style value)

getStandardWidthInch/setStandardWidthInch
public double getStandardWidthInch() / public void setStandardWidthInch(double value)

setStandardWidthInch
public void setStandardWidthInch(double value)

getStandardWidthPixels/setStandardWidthPixels
public int getStandardWidthPixels() / public void setStandardWidthPixels(int value)

setStandardWidthPixels
public void setStandardWidthPixels(int value)

getStandardWidth/setStandardWidth
public double getStandardWidth() / public void setStandardWidth(double value)

setStandardWidth
public void setStandardWidth(double value)

getStandardHeight/setStandardHeight
public double getStandardHeight() / public void setStandardHeight(double value)

setStandardHeight
public void setStandardHeight(double value)

getStandardHeightPixels/setStandardHeightPixels
public int getStandardHeightPixels() / public void setStandardHeightPixels(int value)

setStandardHeightPixels
public void setStandardHeightPixels(int value)

getStandardHeightInch/setStandardHeightInch
public double getStandardHeightInch() / public void setStandardHeightInch(double value)

setStandardHeightInch
public void setStandardHeightInch(double value)

getPreserveString/setPreserveString
public boolean getPreserveString() / public void setPreserveString(boolean value)

com.aspose.cells.Cells.html Maven / Gradle / Ivy

com.aspose.cells Class Cells

getOdsCellFields

getCount

getCountLarge

getRows

getMergedCells

getMultiThreadReading/setMultiThreadReading

setMultiThreadReading

getMemorySetting/setMemorySetting

setMemorySetting

getStyle/setStyle

setStyle

getStandardWidthInch/setStandardWidthInch

setStandardWidthInch

getStandardWidthPixels/setStandardWidthPixels

setStandardWidthPixels

getStandardWidth/setStandardWidth

setStandardWidth

getStandardHeight/setStandardHeight

setStandardHeight

getStandardHeightPixels/setStandardHeightPixels

setStandardHeightPixels

getStandardHeightInch/setStandardHeightInch

setStandardHeightInch

getPreserveString/setPreserveString

setPreserveString

getMinRow

getMaxRow

getMinColumn

getMaxColumn

getMinDataRow

getMaxDataRow

getMinDataColumn

getMaxDataColumn

isDefaultRowHeightMatched/setDefaultRowHeightMatched

setDefaultRowHeightMatched

isDefaultRowHidden/setDefaultRowHidden

setDefaultRowHidden

getColumns

getRanges

getLastCell

getMaxDisplayRange

getFirstCell

get

get

get

linkToXmlMap

findFormula

findFormulaContains

find

find

endCellInRow

endCellInColumn

endCellInColumn

endCellInRow

moveRange

insertCutCells

insertRange

insertRange

insertRange

deleteRange

exportArray

exportTypeArray

importCustomObjects

importCustomObjects

retrieveSubtotalSetting

subtotal

subtotal

removeFormulas

removeDuplicates

removeDuplicates

removeDuplicates

convertStringToNumericValue

getDependents

getCellStyle

importResultSet

importResultSet

importResultSet

importResultSet

com.aspose.cells
Class Cells

setPreserveString
public void setPreserveString(boolean value)

isDefaultRowHeightMatched/setDefaultRowHeightMatched
public boolean isDefaultRowHeightMatched() / public void setDefaultRowHeightMatched(boolean value)

setDefaultRowHeightMatched
public void setDefaultRowHeightMatched(boolean value)

isDefaultRowHidden/setDefaultRowHidden
public boolean isDefaultRowHidden() / public void setDefaultRowHidden(boolean value)

setDefaultRowHidden
public void setDefaultRowHidden(boolean value)

linkToXmlMap
public void linkToXmlMap(java.lang.String mapName, int row, int column, java.lang.String path) throws java.lang.Exception

findFormula
public Cell findFormula(java.lang.String formula, Cell previousCell)

findFormulaContains
public Cell findFormulaContains(java.lang.String formula, Cell previousCell)

find
public Cell find(java.lang.Object what, Cell previousCell)

endCellInColumn
public Cell endCellInColumn(short columnIndex)