Aspose::Cells::ICells Class Referenceabstract

Encapsulates a collection of ICell objects. More...

Inherits IEnumerable, and Object.

Public Member Functions

virtual Aspose::Cells::Systems::Int32 GetCount ()=0
 Gets the number of cells. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Collections::IEnumerator > GetEnumerator ()=0
 Gets the cells enumerator. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Collections::IEnumerator > GetRowEnumerator ()=0
 Gets the rows enumerator More...
 
virtual intrusive_ptr< Aspose::Cells::IRowCollectionGetIRows ()=0
 Gets the collection of IRow objects that represents the individual rows in this worksheet. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList > GetMergedCells ()=0
 Gets the collection of merged cells. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetICell (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column)=0
 Gets the ICell element or null at the specified cell row index and column index. More...
 
virtual intrusive_ptr< Aspose::Cells::IRowGetIRow (Aspose::Cells::Systems::Int32 row)=0
 Gets the IRow element at the specified cell row index. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellCheckICell (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column)=0
 Gets the ICell element or null at the specified cell row index and column index. More...
 
virtual intrusive_ptr< Aspose::Cells::IRowCheckIRow (Aspose::Cells::Systems::Int32 row)=0
 Gets the IRow element or at the specified cell row index. More...
 
virtual intrusive_ptr< Aspose::Cells::IColumnCheckIColumn (Aspose::Cells::Systems::Int32 columnIndex)=0
 Gets the IColumn element or null at the specified column index. More...
 
virtual bool IsRowHidden (Aspose::Cells::Systems::Int32 rowIndex)=0
 Checks whether a row at given index is hidden. More...
 
virtual bool IsColumnHidden (Aspose::Cells::Systems::Int32 columnIndex)=0
 Checks whether a column at given index is hidden. More...
 
virtual void AddIRange (intrusive_ptr< Aspose::Cells::IRange > rangeObject)=0
 Adds a range object reference to cells. More...
 
virtual intrusive_ptr< Aspose::Cells::IRangeCreateIRange (intrusive_ptr< Aspose::Cells::Systems::String > upperLeftCell, intrusive_ptr< Aspose::Cells::Systems::String > lowerRightCell)=0
 Creates an IRange object from a range of cells. More...
 
virtual intrusive_ptr< Aspose::Cells::IRangeCreateIRange (Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns)=0
 Creates an IRange object from a range of cells. More...
 
virtual intrusive_ptr< Aspose::Cells::IRangeCreateIRange (intrusive_ptr< Aspose::Cells::Systems::String > address)=0
 Creates an IRange object from an address of the range. More...
 
virtual intrusive_ptr< Aspose::Cells::IRangeCreateIRange (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 number, bool isVertical)=0
 Creates an IRange object from rows of cells or columns of cells. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetObjectByIndex (Aspose::Cells::Systems::Int32 index)=0
 Gets ICell item within the worksheet. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetObjectByIndex (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column)=0
 Gets the ICell element at the specified cell row index and column index. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetObjectByIndex (intrusive_ptr< Aspose::Cells::Systems::String > cellName)=0
 Gets the ICell element at the specified cell name. More...
 
virtual bool GetMultiThreadReading ()=0
 Gets whether the cells data model should support Multi-Thread reading. Default value is false. If there are multiple threads to read Row/Cell objects in this collection concurrently, this method 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. More...
 
virtual void SetMultiThreadReading (bool value)=0
 Sets whether the cells data model should support Multi-Thread reading. Default value is false. If there are multiple threads to read Row/Cell objects in this collection concurrently, this method 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. More...
 
virtual Aspose::Cells::MemorySetting GetMemorySetting ()=0
 Gets the memory usage option for this cells. More...
 
virtual void SetMemorySetting (Aspose::Cells::MemorySetting value)=0
 Sets the memory usage option for this cells. More...
 
virtual void Clear ()=0
 Clear all cell objects. More...
 
virtual intrusive_ptr< Aspose::Cells::IStyleGetIStyle ()=0
 Gets the default style. More...
 
virtual void SetIStyle (intrusive_ptr< Aspose::Cells::IStyle > value)=0
 Sets the default style. More...
 
virtual Aspose::Cells::Systems::Double GetStandardWidthInch ()=0
 Gets the default column width in the worksheet, in unit of inches. More...
 
virtual void SetStandardWidthInch (Aspose::Cells::Systems::Double value)=0
 Sets the default column width in the worksheet, in unit of inches. More...
 
virtual Aspose::Cells::Systems::Int32 GetStandardWidthPixels ()=0
 Gets the default column width in the worksheet, in unit of pixels. More...
 
virtual void SetStandardWidthPixels (Aspose::Cells::Systems::Int32 value)=0
 Sets the default column width in the worksheet, in unit of pixels. More...
 
virtual Aspose::Cells::Systems::Double GetStandardWidth ()=0
 Gets the default column width in the worksheet, in unit of characters. More...
 
virtual void SetStandardWidth (Aspose::Cells::Systems::Double value)=0
 Sets the default column width in the worksheet, in unit of characters. More...
 
virtual Aspose::Cells::Systems::Double GetStandardHeight ()=0
 Gets the default row height in this worksheet, in unit of points. More...
 
virtual void SetStandardHeight (Aspose::Cells::Systems::Double value)=0
 Sets the default row height in this worksheet, in unit of points. More...
 
virtual Aspose::Cells::Systems::Int32 GetStandardHeightPixels ()=0
 Gets the default row height in this worksheet, in unit of pixels. More...
 
virtual void SetStandardHeightPixels (Aspose::Cells::Systems::Int32 value)=0
 Sets the default row height in this worksheet, in unit of pixels. More...
 
virtual void ImportTwoDimensionArray (intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>> objArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Imports a two-dimension array of data into a worksheet. More...
 
virtual void ImportTwoDimensionArray (intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>> objArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool convertStringToNumber)=0
 Imports a two-dimension array of data into a worksheet. More...
 
virtual void ImportTwoDimensionArray (intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>> objArray, intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>> styles, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool convertStringToNumber)=0
 Imports a two-dimension array of data into a worksheet. More...
 
virtual void ImportTwoDimensionArray (intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>> objArray, intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>> styles, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, intrusive_ptr< Aspose::Cells::ITxtLoadOptions > opts)=0
 Imports a two-dimension array of data into a worksheet. More...
 
virtual void ImportObjectArray (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Object *>> objArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool isVertical)=0
 Imports an array of data into a worksheet. More...
 
virtual void ImportArrayList (intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList > arrayList, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool isVertical)=0
 Imports an arraylist of data into a worksheet. More...
 
virtual void ImportObjectArray (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Object *>> objArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool isVertical, Aspose::Cells::Systems::Int32 skip)=0
 Imports an array of data into a worksheet. More...
 
virtual void ImportArray (intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::String *>> stringArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Imports a two-dimension array of string into a worksheet. More...
 
virtual void ImportFormulaArray (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> stringArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool isVertical)=0
 Imports an array of formula into a worksheet. More...
 
virtual void ImportArray (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> stringArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool isVertical)=0
 Imports an array of string into a worksheet. More...
 
virtual void ImportArray (intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Int32 >> intArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Imports a two-dimension array of integer into a worksheet. More...
 
virtual void ImportArray (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >> intArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool isVertical)=0
 Imports an array of integer into a worksheet. More...
 
virtual void ImportArray (intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Double >> doubleArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Imports a two-dimension array of double into a worksheet. More...
 
virtual void ImportArray (intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Double >> doubleArray, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, bool isVertical)=0
 Imports an array of double into a worksheet. More...
 
virtual void TextToColumns (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Int32 totalRows, intrusive_ptr< Aspose::Cells::ITxtLoadOptions > options)=0
 Splits the text in the column to columns. More...
 
virtual void ImportCSV (intrusive_ptr< Aspose::Cells::Systems::String > fileName, intrusive_ptr< Aspose::Cells::Systems::String > spliter, bool convertNumericData, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Import a CSV file to the cells. More...
 
virtual void ImportCSV (intrusive_ptr< Aspose::Cells::Systems::IO::Stream > stream, intrusive_ptr< Aspose::Cells::Systems::String > spliter, bool convertNumericData, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Import a CSV file to the cells. More...
 
virtual void ImportCSV (intrusive_ptr< Aspose::Cells::Systems::String > fileName, intrusive_ptr< Aspose::Cells::ITxtLoadOptions > options, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Import a CSV file to the cells. More...
 
virtual void ImportCSV (intrusive_ptr< Aspose::Cells::Systems::IO::Stream > stream, intrusive_ptr< Aspose::Cells::ITxtLoadOptions > options, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn)=0
 Import a CSV file to the cells. More...
 
virtual bool GetPreserveString ()=0
 Gets or sets a value indicating whether all worksheet values are preserved as strings. Default is false. More...
 
virtual void SetPreserveString (bool value)=0
 Gets or sets a value indicating whether all worksheet values are preserved as strings. Default is false. More...
 
virtual void Merge (Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns)=0
 Merges a specified range of cells into a single cell.
More...
 
virtual void Merge (Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns, bool mergeConflict)=0
 Merges a specified range of cells into a single cell.
More...
 
virtual void Merge (Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns, bool checkConflict, bool mergeConflict)=0
 Merges a specified range of cells into a single cell.
More...
 
virtual void UnMerge (Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns)=0
 Unmerges a specified range of merged cells.
More...
 
virtual void HideRow (Aspose::Cells::Systems::Int32 row)=0
 Hides a row. More...
 
virtual void UnhideRow (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Double height)=0
 Unhides a row. More...
 
virtual void HideRows (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 totalRows)=0
 Hides multiple rows. More...
 
virtual void UnhideRows (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Double height)=0
 Unhides the hidden rows. More...
 
virtual void SetRowHeightPixel (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 pixels)=0
 Sets row height in unit of pixels. More...
 
virtual void SetRowHeightInch (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Double inches)=0
 Sets row height in unit of inches. More...
 
virtual void SetRowHeight (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Double height)=0
 Sets the height of the specified row. More...
 
virtual Aspose::Cells::Systems::Double GetRowHeight (Aspose::Cells::Systems::Int32 row)=0
 Gets the height of a specified row. More...
 
virtual void HideColumn (Aspose::Cells::Systems::Int32 column)=0
 Hides a column. More...
 
virtual void UnhideColumn (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Double width)=0
 Unhides a column. More...
 
virtual void HideColumns (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Int32 totalColumns)=0
 Hide mutiple columns. More...
 
virtual void UnhideColumns (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Int32 totlaColumns, Aspose::Cells::Systems::Double width)=0
 Unhide mutiple columns. More...
 
virtual Aspose::Cells::Systems::Int32 GetRowHeightPixel (Aspose::Cells::Systems::Int32 row)=0
 Gets the height of a specified row in unit of pixel. More...
 
virtual Aspose::Cells::Systems::Double GetRowHeightInch (Aspose::Cells::Systems::Int32 row)=0
 Gets the height of a specified row in unit of inches. More...
 
virtual void SetColumnWidthPixel (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Int32 pixel)=0
 Sets column width in unit of pixels. More...
 
virtual void SetColumnWidthInch (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Double inches)=0
 Sets column width in unit of inches. More...
 
virtual void SetColumnWidth (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Double width)=0
 Sets the width of the specified column. More...
 
virtual Aspose::Cells::Systems::Int32 GetViewColumnWidthPixel (Aspose::Cells::Systems::Int32 column)=0
 Get the width in different view type. More...
 
virtual Aspose::Cells::Systems::Int32 GetColumnWidthPixel (Aspose::Cells::Systems::Int32 column)=0
 Gets the width of the specified column, in units of pixel. More...
 
virtual Aspose::Cells::Systems::Double GetColumnWidthInch (Aspose::Cells::Systems::Int32 column)=0
 Gets the width of the specified column, in units of inches. More...
 
virtual Aspose::Cells::Systems::Double GetColumnWidth (Aspose::Cells::Systems::Int32 column)=0
 Gets the width of the specified column More...
 
virtual Aspose::Cells::Systems::Int32 GetMinRow ()=0
 Minimum row index of cell which contains data or style. More...
 
virtual Aspose::Cells::Systems::Int32 GetMaxRow ()=0
 Maximum row index of cell which contains data or style. More...
 
virtual Aspose::Cells::Systems::Int32 GetMinColumn ()=0
 Minimum column index of cell which contains data or style. More...
 
virtual Aspose::Cells::Systems::Int32 GetMaxColumn ()=0
 Maximum column index of cell which contains data or style. More...
 
virtual Aspose::Cells::Systems::Int32 GetMinDataRow ()=0
 Minimum row index of cell which contains data. More...
 
virtual Aspose::Cells::Systems::Int32 GetMaxDataRow ()=0
 Maximum row index of cell which contains data. More...
 
virtual Aspose::Cells::Systems::Int32 GetMinDataColumn ()=0
 Minimum column index of cell which contains data. More...
 
virtual Aspose::Cells::Systems::Int32 GetMaxDataColumn ()=0
 Maximum column index of cell which contains data. More...
 
virtual Aspose::Cells::Systems::Int32 GetLastDataRow (Aspose::Cells::Systems::Int32 column)=0
 Gets the last row index of cell which contains data in the specified column. More...
 
virtual bool IsDefaultRowHeightMatched ()=0
 Indicates that row height and default font height matches More...
 
virtual void SetDefaultRowHeightMatched (bool value)=0
 Indicates that row height and default font height matches More...
 
virtual bool IsDefaultRowHidden ()=0
 Indicates whether the row is default hidden. More...
 
virtual void SetDefaultRowHidden (bool value)=0
 Indicates whether the row is default hidden. More...
 
virtual intrusive_ptr< Aspose::Cells::IColumnCollectionGetIColumns ()=0
 Gets the collection of IColumn objects that represents the individual columns in this worksheet. More...
 
virtual void ApplyColumnIStyle (Aspose::Cells::Systems::Int32 column, intrusive_ptr< Aspose::Cells::IStyle > style, intrusive_ptr< Aspose::Cells::IStyleFlag > flag)=0
 Applies formatting for a whole column. More...
 
virtual void ApplyRowIStyle (Aspose::Cells::Systems::Int32 row, intrusive_ptr< Aspose::Cells::IStyle > style, intrusive_ptr< Aspose::Cells::IStyleFlag > flag)=0
 Applies formatting for a whole row. More...
 
virtual void ApplyIStyle (intrusive_ptr< Aspose::Cells::IStyle > style, intrusive_ptr< Aspose::Cells::IStyleFlag > flag)=0
 Applies formatting for a whole worksheet. More...
 
virtual void CopyIColumn (intrusive_ptr< Aspose::Cells::ICells > sourceCells, Aspose::Cells::Systems::Int32 sourceColumnIndex, Aspose::Cells::Systems::Int32 destinationColumnIndex)=0
 Copies data and formatting of a whole column. More...
 
virtual void CopyIColumns (intrusive_ptr< Aspose::Cells::ICells > sourceCells, Aspose::Cells::Systems::Int32 sourceColumnIndex, Aspose::Cells::Systems::Int32 destinationColumnIndex, Aspose::Cells::Systems::Int32 columnNumber)=0
 Copies data and formatting of a whole column. More...
 
virtual void CopyIColumns (intrusive_ptr< Aspose::Cells::ICells > sourceCells, Aspose::Cells::Systems::Int32 sourceColumnIndex, Aspose::Cells::Systems::Int32 sourceTotalColumns, Aspose::Cells::Systems::Int32 destinationColumnIndex, Aspose::Cells::Systems::Int32 destinationTotalColumns)=0
 Copies data and formatting of the whole columns. More...
 
virtual void CopyIRow (intrusive_ptr< Aspose::Cells::ICells > sourceCells, Aspose::Cells::Systems::Int32 sourceRowIndex, Aspose::Cells::Systems::Int32 destinationRowIndex)=0
 Copies data and formatting of a whole row. More...
 
virtual void CopyIRows (intrusive_ptr< Aspose::Cells::ICells > sourceCells, Aspose::Cells::Systems::Int32 sourceRowIndex, Aspose::Cells::Systems::Int32 destinationRowIndex, Aspose::Cells::Systems::Int32 rowNumber)=0
 Copies data and formatting of some whole rows. More...
 
virtual void CopyIRows (intrusive_ptr< Aspose::Cells::ICells > sourceCells, Aspose::Cells::Systems::Int32 sourceRowIndex, Aspose::Cells::Systems::Int32 destinationRowIndex, Aspose::Cells::Systems::Int32 rowNumber, intrusive_ptr< Aspose::Cells::ICopyOptions > copyOptions)=0
 Copies data and formatting of some whole rows. More...
 
virtual Aspose::Cells::Systems::Int32 GetGroupedRowOutlineLevel (Aspose::Cells::Systems::Int32 rowIndex)=0
 Gets the outline level (zero-based) of the row. More...
 
virtual Aspose::Cells::Systems::Int32 GetGroupedColumnOutlineLevel (Aspose::Cells::Systems::Int32 columnIndex)=0
 Gets the outline level (zero-based) of the column. More...
 
virtual Aspose::Cells::Systems::Int32 GetMaxGroupedColumnOutlineLevel ()=0
 Gets the max grouped column outline level (zero-based). More...
 
virtual Aspose::Cells::Systems::Int32 GetMaxGroupedRowOutlineLevel ()=0
 Gets the max grouped row outline level (zero-based). More...
 
virtual void ShowGroupDetail (bool isVertical, Aspose::Cells::Systems::Int32 index)=0
 Unclasps the grouped rows/columns. More...
 
virtual void HideGroupDetail (bool isVertical, Aspose::Cells::Systems::Int32 index)=0
 Collapses the grouped rows/columns. More...
 
virtual void UngroupColumns (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 lastIndex)=0
 Ungroups columns. More...
 
virtual void GroupColumns (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 lastIndex)=0
 Groups columns. More...
 
virtual void GroupColumns (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 lastIndex, bool isHidden)=0
 Groups columns. More...
 
virtual void UngroupRows (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 lastIndex, bool isAll)=0
 Ungroups rows. More...
 
virtual void UngroupRows (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 lastIndex)=0
 Ungroups rows. More...
 
virtual void GroupRows (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 lastIndex, bool isHidden)=0
 Groups rows. More...
 
virtual void GroupRows (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 lastIndex)=0
 Groups rows. More...
 
virtual void DeleteColumn (Aspose::Cells::Systems::Int32 columnIndex, bool updateReference)=0
 Deletes a column. More...
 
virtual void DeleteColumn (Aspose::Cells::Systems::Int32 columnIndex)=0
 Deletes a column. More...
 
virtual void DeleteColumns (Aspose::Cells::Systems::Int32 columnIndex, Aspose::Cells::Systems::Int32 totalColumns, bool updateReference)=0
 Deletes several columns. More...
 
virtual bool IsDeletingRangeEnabled (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns)=0
 Check whether the range could be deleted. More...
 
virtual bool DeleteRows (Aspose::Cells::Systems::Int32 rowIndex, Aspose::Cells::Systems::Int32 totalRows)=0
 Deletes several rows. More...
 
virtual void DeleteRow (Aspose::Cells::Systems::Int32 rowIndex)=0
 Deletes a row. More...
 
virtual bool DeleteRows (Aspose::Cells::Systems::Int32 rowIndex, Aspose::Cells::Systems::Int32 totalRows, bool updateReference)=0
 Deletes multiple rows in the worksheet. More...
 
virtual void DeleteBlankColumns ()=0
 Delete all blank columns which do not contain any data. More...
 
virtual bool IsBlankColumn (Aspose::Cells::Systems::Int32 columnIndex)=0
 Checks whether given column is blank (does not contain any data). More...
 
virtual void DeleteBlankRows ()=0
 Delete all blank rows which do not contain any data. More...
 
virtual void InsertColumns (Aspose::Cells::Systems::Int32 columnIndex, Aspose::Cells::Systems::Int32 totalColumns)=0
 Inserts some columns into the worksheet. More...
 
virtual void InsertColumns (Aspose::Cells::Systems::Int32 columnIndex, Aspose::Cells::Systems::Int32 totalColumns, bool updateReference)=0
 Inserts some columns into the worksheet. More...
 
virtual void InsertColumn (Aspose::Cells::Systems::Int32 columnIndex, bool updateReference)=0
 Inserts a new column into the worksheet. More...
 
virtual void InsertColumn (Aspose::Cells::Systems::Int32 columnIndex)=0
 Inserts a new column into the worksheet. More...
 
virtual void InsertRows (Aspose::Cells::Systems::Int32 rowIndex, Aspose::Cells::Systems::Int32 totalRows, bool updateReference)=0
 Inserts multiple rows into the worksheet. More...
 
virtual void InsertRows (Aspose::Cells::Systems::Int32 rowIndex, Aspose::Cells::Systems::Int32 totalRows)=0
 Inserts multiple rows into the worksheet. More...
 
virtual void InsertRow (Aspose::Cells::Systems::Int32 rowIndex)=0
 Inserts a new row into the worksheet. More...
 
virtual intrusive_ptr< Aspose::Cells::IRangeCollectionGetIRanges ()=0
 Gets the collection of IRange objects created at run time. More...
 
virtual void ClearRange (intrusive_ptr< Aspose::Cells::ICellArea > range)=0
 Clears contents and formatting of a range. More...
 
virtual void ClearRange (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int32 endColumn)=0
 Clears contents and formatting of a range. More...
 
virtual void ClearContents (intrusive_ptr< Aspose::Cells::ICellArea > range)=0
 Clears contents of a range. More...
 
virtual void ClearContents (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int32 endColumn)=0
 Clears contents of a range. More...
 
virtual void ClearFormats (intrusive_ptr< Aspose::Cells::ICellArea > range)=0
 Clears formatting of a range. More...
 
virtual void ClearFormats (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int32 endColumn)=0
 Clears formatting of a range. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetEndICell ()=0
 Gets the last cell in this worksheet. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetLastICell ()=0
 Gets the last cell in this worksheet. More...
 
virtual void LinkToXmlMap (intrusive_ptr< Aspose::Cells::Systems::String > mapName, Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column, intrusive_ptr< Aspose::Cells::Systems::String > path)=0
 Link to a xml map. More...
 
virtual intrusive_ptr< Aspose::Cells::IRangeGetMaxDisplayIRange ()=0
 Gets the max range which includes data, merged cells and shapes. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetStartICell ()=0
 Gets the first cell in this worksheet. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellGetFirstICell ()=0
 Gets the first cell in this worksheet. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindFormula (intrusive_ptr< Aspose::Cells::Systems::String > formula, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindFormulaContains (intrusive_ptr< Aspose::Cells::Systems::String > formula, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell with formula which contains the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindString (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindString (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell, intrusive_ptr< Aspose::Cells::ICellArea > area)=0
 Finds the cell with the input string in the specified area. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindString (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell, intrusive_ptr< Aspose::Cells::ICellArea > area, bool upDown)=0
 Finds the cell with the input string in the specified area. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindString (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell, bool upDown)=0
 Finds the cell with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindString (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell, intrusive_ptr< Aspose::Cells::IFindOptions > findOptions)=0
 Finds the cell with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindStringStartsWith (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell starting with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindStringEndsWith (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell ending with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindStringContains (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell containing with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindStringContains (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell, bool isCaseSensitive, intrusive_ptr< Aspose::Cells::ICellArea > area)=0
 Finds the cell containing with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindStringContains (intrusive_ptr< Aspose::Cells::Systems::String > inputString, intrusive_ptr< Aspose::Cells::ICell > previousCell, bool isCaseSensitive)=0
 Finds the cell containing with the input string. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindNumber (Aspose::Cells::Systems::Int32 inputNumber, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell with the input integer. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFindNumber (Aspose::Cells::Systems::Double inputNumber, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
 Finds the cell with the input double. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellFind (intrusive_ptr< Aspose::Cells::Systems::Object > what, intrusive_ptr< Aspose::Cells::ICell > previousCell, intrusive_ptr< Aspose::Cells::IFindOptions > findOptions)=0
 Finds the cell containing with the input object. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellEndICellInRow (Aspose::Cells::Systems::Int32 rowIndex)=0
 Gets the last cell in this row. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellEndICellInColumn (Aspose::Cells::Systems::Int16 columnIndex)=0
 Gets the last cell in this column. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellEndICellInColumn (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int16 startColumn, Aspose::Cells::Systems::Int16 endColumn)=0
 Gets the last cell with maximum column index in this range. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellEndICellInRow (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 endColumn)=0
 Gets the last cell with maximum row index in this range. More...
 
virtual void MoveIRange (intrusive_ptr< Aspose::Cells::ICellArea > sourceArea, Aspose::Cells::Systems::Int32 destRow, Aspose::Cells::Systems::Int32 destColumn)=0
 Moves the range to destination postion. More...
 
virtual void InsertIRange (intrusive_ptr< Aspose::Cells::ICellArea > area, Aspose::Cells::Systems::Int32 shiftNumber, Aspose::Cells::ShiftType shiftType, bool updateReference)=0
 Inserts a range of cells and shift cells according to the shift option. More...
 
virtual void InsertIRange (intrusive_ptr< Aspose::Cells::ICellArea > area, Aspose::Cells::ShiftType shiftType)=0
 Inserts a range of cells and shift cells according to the shift option. More...
 
virtual void InsertIRange (intrusive_ptr< Aspose::Cells::ICellArea > area, Aspose::Cells::Systems::Int32 shiftNumber, Aspose::Cells::ShiftType shiftType)=0
 Inserts a range of cells and shift cells according to the shift option. More...
 
virtual void DeleteRange (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int32 endColumn, Aspose::Cells::ShiftType shiftType)=0
 Deletes a range of cells and shift cells according to the shift option. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object * > > ExportArray (Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns)=0
 Exports data in the ICells collection to a two-dimension array object. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::CellValueType > > ExportTypeArray (Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 totalRows, Aspose::Cells::Systems::Int32 totalColumns)=0
 Exports cell value type in the ICells collection to a two-dimension array object. More...
 
virtual Aspose::Cells::Systems::Int32 ImportCustomObjects (intrusive_ptr< Aspose::Cells::Systems::Collections::ICollection > list, intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>> propertyNames, bool isPropertyNameShown, Aspose::Cells::Systems::Int32 firstRow, Aspose::Cells::Systems::Int32 firstColumn, Aspose::Cells::Systems::Int32 rowNumber, bool insertRows, intrusive_ptr< Aspose::Cells::Systems::String > dateFormatString, bool convertStringToNumber)=0
 Imports custom objects. More...
 
virtual void Subtotal (intrusive_ptr< Aspose::Cells::ICellArea > ca, Aspose::Cells::Systems::Int32 groupBy, Aspose::Cells::ConsolidationFunction function, intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >> totalList)=0
 Creates subtotals for the range. More...
 
virtual void Subtotal (intrusive_ptr< Aspose::Cells::ICellArea > ca, Aspose::Cells::Systems::Int32 groupBy, Aspose::Cells::ConsolidationFunction function, intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >> totalList, bool replace, bool pageBreaks, bool summaryBelowData)=0
 Creates subtotals for the range. More...
 
virtual void RemoveFormulas ()=0
 Removes all formula and replaces with the value of the formula. More...
 
virtual void RemoveDuplicates (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int32 endColumn)=0
 Remove duplicate values in the range. More...
 
virtual void ConvertStringToNumericValue ()=0
 Converts string data in cells to numeric value if possible. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::ICell * > > GetDependentICells (bool isAll, Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column)=0
 Get all cells which refer to the specific cell. More...
 
virtual intrusive_ptr< Aspose::Cells::IStyleGetCellIStyle (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column)=0
 Get the style of given cell. More...
 
virtual void add_ref ()
 
virtual int release_ref ()
 

Detailed Description

Encapsulates a collection of ICell objects.

[C++]
intrusive_ptr<IWorkbook> excel = Factory::CreateIWorkbook();
intrusive_ptr<ICells> cells = excel->GetIWorksheets()->GetObjectByIndex(0)->GetICells();
//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);

Member Function Documentation

◆ add_ref()

virtual void Aspose::Cells::ICells::add_ref ( )
inlinevirtual

◆ AddIRange()

virtual void Aspose::Cells::ICells::AddIRange ( intrusive_ptr< Aspose::Cells::IRange rangeObject)
pure virtual

Adds a range object reference to cells.

Parameters
rangeObjectThe range object will be contained in the cells

◆ ApplyColumnIStyle()

virtual void Aspose::Cells::ICells::ApplyColumnIStyle ( Aspose::Cells::Systems::Int32  column,
intrusive_ptr< Aspose::Cells::IStyle style,
intrusive_ptr< Aspose::Cells::IStyleFlag flag 
)
pure virtual

Applies formatting for a whole column.

Parameters
columnThe column index.
IstyleThe style object which will be applied.
flagFlags which indicates applied formatting properties.

◆ ApplyIStyle()

virtual void Aspose::Cells::ICells::ApplyIStyle ( intrusive_ptr< Aspose::Cells::IStyle style,
intrusive_ptr< Aspose::Cells::IStyleFlag flag 
)
pure virtual

Applies formatting for a whole worksheet.

Parameters
IstyleThe style object which will be applied.
flagFlags which indicates applied formatting properties.

◆ ApplyRowIStyle()

virtual void Aspose::Cells::ICells::ApplyRowIStyle ( Aspose::Cells::Systems::Int32  row,
intrusive_ptr< Aspose::Cells::IStyle style,
intrusive_ptr< Aspose::Cells::IStyleFlag flag 
)
pure virtual

Applies formatting for a whole row.

Parameters
rowThe row index.
IstyleThe style object which will be applied.
flagFlags which indicates applied formatting properties.

◆ CheckICell()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::CheckICell ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  column 
)
pure virtual

Gets the ICell element or null at the specified cell row index and column index.

Parameters
rowRow index
columnColumn index
Returns
Return Cell object if a Cell object exists. Return null if the cell does not exist.

◆ CheckIColumn()

virtual intrusive_ptr<Aspose::Cells::IColumn> Aspose::Cells::ICells::CheckIColumn ( Aspose::Cells::Systems::Int32  columnIndex)
pure virtual

Gets the IColumn element or null at the specified column index.

Parameters
columnIndexThe column index.
Returns
The Column object.

◆ CheckIRow()

virtual intrusive_ptr<Aspose::Cells::IRow> Aspose::Cells::ICells::CheckIRow ( Aspose::Cells::Systems::Int32  row)
pure virtual

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

Parameters
rowRow index
Returns
If the row object does exist return Row object, otherwise return null.

◆ Clear()

virtual void Aspose::Cells::ICells::Clear ( )
pure virtual

Clear all cell objects.

◆ ClearContents() [1/2]

virtual void Aspose::Cells::ICells::ClearContents ( intrusive_ptr< Aspose::Cells::ICellArea range)
pure virtual

Clears contents of a range.

Parameters
rangeRange to be cleared.

◆ ClearContents() [2/2]

virtual void Aspose::Cells::ICells::ClearContents ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  startColumn,
Aspose::Cells::Systems::Int32  endRow,
Aspose::Cells::Systems::Int32  endColumn 
)
pure virtual

Clears contents of a range.

Parameters
startRowStart row index.
startColumnStart column index.
endRowEnd row index.
endColumnEnd column index.

◆ ClearFormats() [1/2]

virtual void Aspose::Cells::ICells::ClearFormats ( intrusive_ptr< Aspose::Cells::ICellArea range)
pure virtual

Clears formatting of a range.

Parameters
rangeRange to be cleared.

◆ ClearFormats() [2/2]

virtual void Aspose::Cells::ICells::ClearFormats ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  startColumn,
Aspose::Cells::Systems::Int32  endRow,
Aspose::Cells::Systems::Int32  endColumn 
)
pure virtual

Clears formatting of a range.

Parameters
startRowStart row index.
startColumnStart column index.
endRowEnd row index.
endColumnEnd column index.

◆ ClearRange() [1/2]

virtual void Aspose::Cells::ICells::ClearRange ( intrusive_ptr< Aspose::Cells::ICellArea range)
pure virtual

Clears contents and formatting of a range.

Parameters
rangeRange to be cleared.

◆ ClearRange() [2/2]

virtual void Aspose::Cells::ICells::ClearRange ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  startColumn,
Aspose::Cells::Systems::Int32  endRow,
Aspose::Cells::Systems::Int32  endColumn 
)
pure virtual

Clears contents and formatting of a range.

Parameters
startRowStart row index.
startColumnStart column index.
endRowEnd row index.
endColumnEnd column index.

◆ ConvertStringToNumericValue()

virtual void Aspose::Cells::ICells::ConvertStringToNumericValue ( )
pure virtual

Converts string data in cells to numeric value if possible.

◆ CopyIColumn()

virtual void Aspose::Cells::ICells::CopyIColumn ( intrusive_ptr< Aspose::Cells::ICells sourceCells,
Aspose::Cells::Systems::Int32  sourceColumnIndex,
Aspose::Cells::Systems::Int32  destinationColumnIndex 
)
pure virtual

Copies data and formatting of a whole column.

Parameters
sourceCellsSource Cells object contains data and formatting to copy.
sourceColumnIndexSource column index.
destinationColumnIndexDestination column index.

◆ CopyIColumns() [1/2]

virtual void Aspose::Cells::ICells::CopyIColumns ( intrusive_ptr< Aspose::Cells::ICells sourceCells,
Aspose::Cells::Systems::Int32  sourceColumnIndex,
Aspose::Cells::Systems::Int32  destinationColumnIndex,
Aspose::Cells::Systems::Int32  columnNumber 
)
pure virtual

Copies data and formatting of a whole column.

Parameters
sourceCellsSource Cells object contains data and formatting to copy.
sourceColumnIndexSource column index.
destinationColumnIndexDestination column index.
columnNumberThe copied column number.

◆ CopyIColumns() [2/2]

virtual void Aspose::Cells::ICells::CopyIColumns ( intrusive_ptr< Aspose::Cells::ICells sourceCells,
Aspose::Cells::Systems::Int32  sourceColumnIndex,
Aspose::Cells::Systems::Int32  sourceTotalColumns,
Aspose::Cells::Systems::Int32  destinationColumnIndex,
Aspose::Cells::Systems::Int32  destinationTotalColumns 
)
pure virtual

Copies data and formatting of the whole columns.

Parameters
sourceCellsSource Cells object contains data and formatting to copy.
sourceColumnIndexSource column index.
sourceTotalColumnsThe number of the source columns.
destinationColumnIndexDestination column index.
destinationTotalColumnsThe number of the destination columns.

◆ CopyIRow()

virtual void Aspose::Cells::ICells::CopyIRow ( intrusive_ptr< Aspose::Cells::ICells sourceCells,
Aspose::Cells::Systems::Int32  sourceRowIndex,
Aspose::Cells::Systems::Int32  destinationRowIndex 
)
pure virtual

Copies data and formatting of a whole row.

Parameters
sourceCellsSource Cells object contains data and formatting to copy.
sourceRowIndexSource row index.
destinationRowIndexDestination row index.

◆ CopyIRows() [1/2]

virtual void Aspose::Cells::ICells::CopyIRows ( intrusive_ptr< Aspose::Cells::ICells sourceCells,
Aspose::Cells::Systems::Int32  sourceRowIndex,
Aspose::Cells::Systems::Int32  destinationRowIndex,
Aspose::Cells::Systems::Int32  rowNumber 
)
pure virtual

Copies data and formatting of some whole rows.

Parameters
sourceCellsSource Cells object contains data and formatting to copy.
sourceRowIndexSource row index.
destinationRowIndexDestination row index.
rowNumberThe copied row number.

◆ CopyIRows() [2/2]

virtual void Aspose::Cells::ICells::CopyIRows ( intrusive_ptr< Aspose::Cells::ICells sourceCells,
Aspose::Cells::Systems::Int32  sourceRowIndex,
Aspose::Cells::Systems::Int32  destinationRowIndex,
Aspose::Cells::Systems::Int32  rowNumber,
intrusive_ptr< Aspose::Cells::ICopyOptions copyOptions 
)
pure virtual

Copies data and formatting of some whole rows.

Parameters
sourceCellsSource Cells object contains data and formatting to copy.
sourceRowIndexSource row index.
destinationRowIndexDestination row index.
rowNumberThe copied row number.
copyOptionsThe copy options.

◆ CreateIRange() [1/4]

virtual intrusive_ptr<Aspose::Cells::IRange> Aspose::Cells::ICells::CreateIRange ( intrusive_ptr< Aspose::Cells::Systems::String >  upperLeftCell,
intrusive_ptr< Aspose::Cells::Systems::String >  lowerRightCell 
)
pure virtual

Creates an IRange object from a range of cells.

Parameters
upperLeftCellUpper left cell name.
lowerRightCellLower right cell name.
Returns
A IRange object

◆ CreateIRange() [2/4]

virtual intrusive_ptr<Aspose::Cells::IRange> Aspose::Cells::ICells::CreateIRange ( Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Creates an IRange object from a range of cells.

Parameters
firstRowFirst row of this range
firstColumnFirst column of this range
totalRowsNumber of rows
totalColumnsNumber of columns
Returns
An IRange object

◆ CreateIRange() [3/4]

virtual intrusive_ptr<Aspose::Cells::IRange> Aspose::Cells::ICells::CreateIRange ( intrusive_ptr< Aspose::Cells::Systems::String >  address)
pure virtual

Creates an IRange object from an address of the range.

Parameters
addressThe address of the range.
Returns
An IRange object

◆ CreateIRange() [4/4]

virtual intrusive_ptr<Aspose::Cells::IRange> Aspose::Cells::ICells::CreateIRange ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  number,
bool  isVertical 
)
pure virtual

Creates an IRange object from rows of cells or columns of cells.

Parameters
firstIndexFirst row index or first column index, zero based.
numberTotal number of rows or columns, one based.
isVerticalTrue - Range created from columns of cells. False - Range created from rows of cells.
Returns
An IRange object.

◆ DeleteBlankColumns()

virtual void Aspose::Cells::ICells::DeleteBlankColumns ( )
pure virtual

Delete all blank columns which do not contain any data.

◆ DeleteBlankRows()

virtual void Aspose::Cells::ICells::DeleteBlankRows ( )
pure virtual

Delete all blank rows which do not contain any data.

◆ DeleteColumn() [1/2]

virtual void Aspose::Cells::ICells::DeleteColumn ( Aspose::Cells::Systems::Int32  columnIndex,
bool  updateReference 
)
pure virtual

Deletes a column.

Parameters
columnIndexColumn index.
updateReferenceIndicates if update references in other worksheets.

◆ DeleteColumn() [2/2]

virtual void Aspose::Cells::ICells::DeleteColumn ( Aspose::Cells::Systems::Int32  columnIndex)
pure virtual

Deletes a column.

Parameters
columnIndexColumn index.

◆ DeleteColumns()

virtual void Aspose::Cells::ICells::DeleteColumns ( Aspose::Cells::Systems::Int32  columnIndex,
Aspose::Cells::Systems::Int32  totalColumns,
bool  updateReference 
)
pure virtual

Deletes several columns.

Parameters
columnIndexColumn index.
totalColumnsNumber of columns to be deleted.
updateReferenceIndicates if update references in other worksheets.

◆ DeleteRange()

virtual void Aspose::Cells::ICells::DeleteRange ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  startColumn,
Aspose::Cells::Systems::Int32  endRow,
Aspose::Cells::Systems::Int32  endColumn,
Aspose::Cells::ShiftType  shiftType 
)
pure virtual

Deletes a range of cells and shift cells according to the shift option.

Parameters
startRowStart row index.
startColumnStart column index.
endRowEnd row index.
endColumnEnd column index.
shiftTypeShift cells option.

◆ DeleteRow()

virtual void Aspose::Cells::ICells::DeleteRow ( Aspose::Cells::Systems::Int32  rowIndex)
pure virtual

Deletes a row.

Parameters
rowIndexRow index.

◆ DeleteRows() [1/2]

virtual bool Aspose::Cells::ICells::DeleteRows ( Aspose::Cells::Systems::Int32  rowIndex,
Aspose::Cells::Systems::Int32  totalRows 
)
pure virtual

Deletes several rows.

Parameters
rowIndexThe first row index to be deleted.
totalRowsNumber of rows to be deleted.

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.

◆ DeleteRows() [2/2]

virtual bool Aspose::Cells::ICells::DeleteRows ( Aspose::Cells::Systems::Int32  rowIndex,
Aspose::Cells::Systems::Int32  totalRows,
bool  updateReference 
)
pure virtual

Deletes multiple rows in the worksheet.

Parameters
rowIndexRow index.
totalRowsNumber of rows to be deleted.
updateReferenceIndicates if update references in other worksheets.
Returns

◆ EndICellInColumn() [1/2]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::EndICellInColumn ( Aspose::Cells::Systems::Int16  columnIndex)
pure virtual

Gets the last cell in this column.

Parameters
columnIndexColumn index.
Returns
Cell object.

◆ EndICellInColumn() [2/2]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::EndICellInColumn ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  endRow,
Aspose::Cells::Systems::Int16  startColumn,
Aspose::Cells::Systems::Int16  endColumn 
)
pure virtual

Gets the last cell with maximum column index in this range.

Parameters
startRowStart row index.
endRowEnd row index.
startColumnStart column index.
endColumnEnd column index.
Returns
Cell object.

◆ EndICellInRow() [1/2]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::EndICellInRow ( Aspose::Cells::Systems::Int32  rowIndex)
pure virtual

Gets the last cell in this row.

Parameters
rowIndexRow index.
Returns
Cell object.

◆ EndICellInRow() [2/2]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::EndICellInRow ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  endRow,
Aspose::Cells::Systems::Int32  startColumn,
Aspose::Cells::Systems::Int32  endColumn 
)
pure virtual

Gets the last cell with maximum row index in this range.

Parameters
startRowStart row index.
endRowEnd row index.
startColumnStart column index.
endColumnEnd column index.
Returns
Cell object.

◆ ExportArray()

virtual intrusive_ptr<Aspose::Cells::Systems::Array2D<Aspose::Cells::Systems::Object*> > Aspose::Cells::ICells::ExportArray ( Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Exports data in the ICells collection to a two-dimension array object.

Parameters
firstRowThe row number of the first cell to export out.
firstColumnThe column number of the first cell to export out.
totalRowsNumber of rows to be exported
totalColumnsNumber of columns to be exported
Returns
Exported cell value array object.

◆ ExportTypeArray()

virtual intrusive_ptr<Aspose::Cells::Systems::Array2D<Aspose::Cells::CellValueType> > Aspose::Cells::ICells::ExportTypeArray ( Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Exports cell value type in the ICells collection to a two-dimension array object.

Parameters
firstRowThe row number of the first cell to export out.
firstColumnThe column number of the first cell to export out.
totalRowsNumber of rows to be exported.
totalColumnsNumber of columns to be exported.
Returns
Exported CellValuetype array object.

◆ Find()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::Find ( intrusive_ptr< Aspose::Cells::Systems::Object >  what,
intrusive_ptr< Aspose::Cells::ICell previousCell,
intrusive_ptr< Aspose::Cells::IFindOptions findOptions 
)
pure virtual

Finds the cell containing with the input object.

Parameters
whatThe object to search for. The type should be int,double,DateTime,string,bool.
previousCellPrevious cell with the same object. This parameter can be set to null if searching from the start.
findOptionsFind options
Returns
Cell object.

Returns null (Nothing) if no cell is found.

◆ FindFormula()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindFormula ( intrusive_ptr< Aspose::Cells::Systems::String >  formula,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell with the input string.

Parameters
formulaThe formula to search for.
previousCellPrevious cell with the same formula. This parameter can be set to null if searching from the start.
Returns
Cell object.

This method is supported in Standard and above versions of Aspose.Cells.

◆ FindFormulaContains()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindFormulaContains ( intrusive_ptr< Aspose::Cells::Systems::String >  formula,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell with formula which contains the input string.

Parameters
formulaThe formula to search for.
previousCellPrevious cell with the same formula. This parameter can be set to null if searching from the start.
Returns
Cell object.

This method is supported in Standard and above versions of Aspose.Cells.

◆ FindNumber() [1/2]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindNumber ( Aspose::Cells::Systems::Int32  inputNumber,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell with the input integer.

Parameters
inputNumberThe integer to search for.
previousCellPrevious cell with the same integer. This parameter can be set to null if searching from the start.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindNumber() [2/2]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindNumber ( Aspose::Cells::Systems::Double  inputNumber,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell with the input double.

Parameters
inputNumberThe double to search for.
previousCellPrevious cell with the same double. This parameter can be set to null if searching from the start.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindString() [1/5]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindString ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find(object,Cell,FindOptions) method of ICells.

◆ FindString() [2/5]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindString ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell,
intrusive_ptr< Aspose::Cells::ICellArea area 
)
pure virtual

Finds the cell with the input string in the specified area.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
areaSearched area.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindString() [3/5]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindString ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell,
intrusive_ptr< Aspose::Cells::ICellArea area,
bool  upDown 
)
pure virtual

Finds the cell with the input string in the specified area.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
areaSearched area.
upDownSearch order. True: Up. False: Down.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindString() [4/5]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindString ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell,
bool  upDown 
)
pure virtual

Finds the cell with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
upDownSearch order. True: Up. False: Down.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells .

◆ FindString() [5/5]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindString ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell,
intrusive_ptr< Aspose::Cells::IFindOptions findOptions 
)
pure virtual

Finds the cell with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
findOptionsSets the find options.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindStringContains() [1/3]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindStringContains ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell containing with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindStringContains() [2/3]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindStringContains ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell,
bool  isCaseSensitive,
intrusive_ptr< Aspose::Cells::ICellArea area 
)
pure virtual

Finds the cell containing with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
isCaseSensitiveIndicates if the searched string is case sensitive.
areaSearched area.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindStringContains() [3/3]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindStringContains ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell,
bool  isCaseSensitive 
)
pure virtual

Finds the cell containing with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
isCaseSensitiveIndicates if the searched string is case sensitive.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindStringEndsWith()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindStringEndsWith ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell ending with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells.

◆ FindStringStartsWith()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::FindStringStartsWith ( intrusive_ptr< Aspose::Cells::Systems::String >  inputString,
intrusive_ptr< Aspose::Cells::ICell previousCell 
)
pure virtual

Finds the cell starting with the input string.

Parameters
inputStringThe string to search for.
previousCellPrevious cell with the same string. This parameter can be set to null if searching from the start.
Returns
Cell object.

Returns null (Nothing) if no cell is found. NOTE: This member is now obsolete. Instead, please use Find() method of ICells .

◆ GetCellIStyle()

virtual intrusive_ptr<Aspose::Cells::IStyle> Aspose::Cells::ICells::GetCellIStyle ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  column 
)
pure virtual

Get the style of given cell.

Parameters
rowrow index
columncolumn
Returns
the style of given cell.

◆ GetColumnWidth()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetColumnWidth ( Aspose::Cells::Systems::Int32  column)
pure virtual

Gets the width of the specified column

Parameters
columnColumn index
Returns
Width of column

◆ GetColumnWidthInch()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetColumnWidthInch ( Aspose::Cells::Systems::Int32  column)
pure virtual

Gets the width of the specified column, in units of inches.

Parameters
columnColumn index
Returns
Width of column

◆ GetColumnWidthPixel()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetColumnWidthPixel ( Aspose::Cells::Systems::Int32  column)
pure virtual

Gets the width of the specified column, in units of pixel.

Parameters
columnColumn index
Returns
Width of column in normal view.

◆ GetCount()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetCount ( )
pure virtual

Gets the number of cells.

◆ GetDependentICells()

virtual intrusive_ptr<Aspose::Cells::Systems::Array1D<Aspose::Cells::ICell*> > Aspose::Cells::ICells::GetDependentICells ( bool  isAll,
Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  column 
)
pure virtual

Get all cells which refer to the specific cell.

Parameters
isAllIndicates whether check other worksheets
rowThe row index.
columnThe column index.
Returns

◆ GetEndICell()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetEndICell ( )
pure virtual

Gets the last cell in this worksheet.

NOTE: This member is now obsolete. Instead, please use GetLastICell of ICells. This property will be removed 12 months later since December 2015. Aspose apologizes for any inconvenience you may have experienced.

◆ GetEnumerator()

virtual intrusive_ptr<Aspose::Cells::Systems::Collections::IEnumerator> Aspose::Cells::ICells::GetEnumerator ( )
pure virtual

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

◆ GetFirstICell()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetFirstICell ( )
pure virtual

Gets the first cell in this worksheet.

◆ GetGroupedColumnOutlineLevel()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetGroupedColumnOutlineLevel ( Aspose::Cells::Systems::Int32  columnIndex)
pure virtual

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

Parameters
columnIndexThe column index
Returns
The outline level of the column

If the column is not grouped, returns zero.

◆ GetGroupedRowOutlineLevel()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetGroupedRowOutlineLevel ( Aspose::Cells::Systems::Int32  rowIndex)
pure virtual

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

Parameters
rowIndexThe row index.
Returns
The outline level (zero-based) of the row.

If the row is not grouped, returns zero.

◆ GetICell()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetICell ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  column 
)
pure virtual

Gets the ICell element or null at the specified cell row index and column index.

Parameters
rowRow index
columnColumn index
Returns
Return Cell object if a Cell object exists. Return null if the cell does not exist.

◆ GetIColumns()

virtual intrusive_ptr<Aspose::Cells::IColumnCollection> Aspose::Cells::ICells::GetIColumns ( )
pure virtual

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

◆ GetIRanges()

virtual intrusive_ptr<Aspose::Cells::IRangeCollection> Aspose::Cells::ICells::GetIRanges ( )
pure virtual

Gets the collection of IRange objects created at run time.

◆ GetIRow()

virtual intrusive_ptr<Aspose::Cells::IRow> Aspose::Cells::ICells::GetIRow ( Aspose::Cells::Systems::Int32  row)
pure virtual

Gets the IRow element at the specified cell row index.

Parameters
rowRow index
Returns
If the row object does exist return IRow object, otherwise return null.

◆ GetIRows()

virtual intrusive_ptr<Aspose::Cells::IRowCollection> Aspose::Cells::ICells::GetIRows ( )
pure virtual

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

◆ GetIStyle()

virtual intrusive_ptr<Aspose::Cells::IStyle> Aspose::Cells::ICells::GetIStyle ( )
pure virtual

Gets the default style.

◆ GetLastDataRow()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetLastDataRow ( Aspose::Cells::Systems::Int32  column)
pure virtual

Gets the last row index of cell which contains data in the specified column.

Parameters
columnColumn index.
Returns
last row index.

◆ GetLastICell()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetLastICell ( )
pure virtual

Gets the last cell in this worksheet.

◆ GetMaxColumn()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMaxColumn ( )
pure virtual

Maximum column index of cell which contains data or style.

Return -1 if there is no cell.

◆ GetMaxDataColumn()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMaxDataColumn ( )
pure virtual

Maximum column index of cell which contains data.

Return -1 if there is not cell which contains data. Don't call this property repeatedly. This property will iterate all cells in a worksheet.

◆ GetMaxDataRow()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMaxDataRow ( )
pure virtual

Maximum row index of cell which contains data.

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

◆ GetMaxDisplayIRange()

virtual intrusive_ptr<Aspose::Cells::IRange> Aspose::Cells::ICells::GetMaxDisplayIRange ( )
pure virtual

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

◆ GetMaxGroupedColumnOutlineLevel()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMaxGroupedColumnOutlineLevel ( )
pure virtual

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

Returns
The max grouped column outline level (zero-based)

◆ GetMaxGroupedRowOutlineLevel()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMaxGroupedRowOutlineLevel ( )
pure virtual

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

Returns
The max grouped row outline level (zero-based)

◆ GetMaxRow()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMaxRow ( )
pure virtual

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.

◆ GetMemorySetting()

virtual Aspose::Cells::MemorySetting Aspose::Cells::ICells::GetMemorySetting ( )
pure virtual

Gets the memory usage option for this cells.

◆ GetMergedCells()

virtual intrusive_ptr<Aspose::Cells::Systems::Collections::ArrayList> Aspose::Cells::ICells::GetMergedCells ( )
pure virtual

Gets the collection of merged cells.

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

◆ GetMinColumn()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMinColumn ( )
pure virtual

Minimum column index of cell which contains data or style.

◆ GetMinDataColumn()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMinDataColumn ( )
pure virtual

Minimum column index of cell which contains data.

◆ GetMinDataRow()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMinDataRow ( )
pure virtual

Minimum row index of cell which contains data.

◆ GetMinRow()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetMinRow ( )
pure virtual

Minimum row index of cell which contains data or style.

◆ GetMultiThreadReading()

virtual bool Aspose::Cells::ICells::GetMultiThreadReading ( )
pure virtual

Gets whether the cells data model should support Multi-Thread reading. Default value is false. If there are multiple threads to read Row/Cell objects in this collection concurrently, this method 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.

◆ GetObjectByIndex() [1/3]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetObjectByIndex ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets ICell item within the worksheet.

Parameters
indexThe zero based index of the element.

The element at the specified index.

NOTE: This member is now obsolete. Instead, please use GetEnumerator() method of ICells to iterate all cells in this worksheet. This method will be removed 12 months later since February 2015. Aspose apologizes for any inconvenience you may have experienced.

◆ GetObjectByIndex() [2/3]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetObjectByIndex ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  column 
)
pure virtual

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

Parameters
rowRow index.
columnColumn index.
Returns
The ICell object.
[C++]
intrusive_ptr<ICells> cells = excel->GetIWorksheets()->GetObjectByIndex(0)->GetICells();
intrusive_ptr<ICell> cell = cells->GetObjectByIndex(0, 0); //Gets the cell at "A1"

◆ GetObjectByIndex() [3/3]

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetObjectByIndex ( intrusive_ptr< Aspose::Cells::Systems::String >  cellName)
pure virtual

Gets the ICell element at the specified cell name.

Parameters
cellNameCell name,including its column letter and row number, for example A5.
Returns
A ICell object
[C++]
intrusive_ptr<ICells> cells = excel->GetIWorksheets()->GetObjectByIndex(0)->GetICells();
intrusive_ptr<ICell> cell = cells->GetObjectByIndex(new String("A1")); //Gets the cell at "A1"

◆ GetPreserveString()

virtual bool Aspose::Cells::ICells::GetPreserveString ( )
pure virtual

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

◆ GetRowEnumerator()

virtual intrusive_ptr<Aspose::Cells::Systems::Collections::IEnumerator> Aspose::Cells::ICells::GetRowEnumerator ( )
pure virtual

Gets the rows enumerator

Returns
The rows enuerator.

◆ GetRowHeight()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetRowHeight ( Aspose::Cells::Systems::Int32  row)
pure virtual

Gets the height of a specified row.

Parameters
rowRow index
Returns
Height of row

◆ GetRowHeightInch()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetRowHeightInch ( Aspose::Cells::Systems::Int32  row)
pure virtual

Gets the height of a specified row in unit of inches.

Parameters
rowRow index
Returns
Height of row

◆ GetRowHeightPixel()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetRowHeightPixel ( Aspose::Cells::Systems::Int32  row)
pure virtual

Gets the height of a specified row in unit of pixel.

Parameters
rowRow index
Returns
Height of row

◆ GetStandardHeight()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetStandardHeight ( )
pure virtual

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

◆ GetStandardHeightPixels()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetStandardHeightPixels ( )
pure virtual

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

◆ GetStandardWidth()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetStandardWidth ( )
pure virtual

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

◆ GetStandardWidthInch()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetStandardWidthInch ( )
pure virtual

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

◆ GetStandardWidthPixels()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetStandardWidthPixels ( )
pure virtual

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

◆ GetStartICell()

virtual intrusive_ptr<Aspose::Cells::ICell> Aspose::Cells::ICells::GetStartICell ( )
pure virtual

Gets the first cell in this worksheet.

NOTE: This member is now obsolete. Instead, please use GetFirstICell method. This method will be removed 12 months later since June 2010. Aspose apologizes for any inconvenience you may have experienced.

◆ GetViewColumnWidthPixel()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::GetViewColumnWidthPixel ( Aspose::Cells::Systems::Int32  column)
pure virtual

Get the width in different view type.

Parameters
columnThe column index.
Returns
the column width in unit of pixels

◆ GroupColumns() [1/2]

virtual void Aspose::Cells::ICells::GroupColumns ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  lastIndex 
)
pure virtual

Groups columns.

Parameters
firstIndexThe first column index to be grouped.
lastIndexThe last column index to be grouped.

◆ GroupColumns() [2/2]

virtual void Aspose::Cells::ICells::GroupColumns ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  lastIndex,
bool  isHidden 
)
pure virtual

Groups columns.

Parameters
firstIndexThe first column index to be grouped.
lastIndexThe last column index to be grouped.
isHiddenSpecifies if the grouped columns are hidden.

◆ GroupRows() [1/2]

virtual void Aspose::Cells::ICells::GroupRows ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  lastIndex,
bool  isHidden 
)
pure virtual

Groups rows.

Parameters
firstIndexThe first row index to be grouped.
lastIndexThe last row index to be grouped.
isHiddenSpecifies if the grouped columns are hidden.

◆ GroupRows() [2/2]

virtual void Aspose::Cells::ICells::GroupRows ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  lastIndex 
)
pure virtual

Groups rows.

Parameters
firstIndexThe first row index to be grouped.
lastIndexThe last row index to be grouped.

◆ HideColumn()

virtual void Aspose::Cells::ICells::HideColumn ( Aspose::Cells::Systems::Int32  column)
pure virtual

Hides a column.

Parameters
columnColumn index.

◆ HideColumns()

virtual void Aspose::Cells::ICells::HideColumns ( Aspose::Cells::Systems::Int32  column,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Hide mutiple columns.

Parameters
columnColumn index.
totalColumnsColumn number.

◆ HideGroupDetail()

virtual void Aspose::Cells::ICells::HideGroupDetail ( bool  isVertical,
Aspose::Cells::Systems::Int32  index 
)
pure virtual

Collapses the grouped rows/columns.

Parameters
isVerticalTrue, collapse the grouped rows.
indexThe row/column index

◆ HideRow()

virtual void Aspose::Cells::ICells::HideRow ( Aspose::Cells::Systems::Int32  row)
pure virtual

Hides a row.

Parameters
rowRow index.

◆ HideRows()

virtual void Aspose::Cells::ICells::HideRows ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  totalRows 
)
pure virtual

Hides multiple rows.

Parameters
rowThe row index.
totalRowsThe row number.

◆ ImportArray() [1/6]

virtual void Aspose::Cells::ICells::ImportArray ( intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::String *>>  stringArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Imports a two-dimension array of string into a worksheet.

Parameters
stringArrayTwo-dimension string array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportArray() [2/6]

virtual void Aspose::Cells::ICells::ImportArray ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>>  stringArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  isVertical 
)
pure virtual

Imports an array of string into a worksheet.

Parameters
stringArrayString array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
isVerticalSpecifies to import data vertically or horizontally.

◆ ImportArray() [3/6]

virtual void Aspose::Cells::ICells::ImportArray ( intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Int32 >>  intArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Imports a two-dimension array of integer into a worksheet.

Parameters
intArrayTwo-dimension integer array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportArray() [4/6]

virtual void Aspose::Cells::ICells::ImportArray ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >>  intArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  isVertical 
)
pure virtual

Imports an array of integer into a worksheet.

Parameters
intArrayInteger array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
isVerticalSpecifies to import data vertically or horizontally.

◆ ImportArray() [5/6]

virtual void Aspose::Cells::ICells::ImportArray ( intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Double >>  doubleArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Imports a two-dimension array of double into a worksheet.

Parameters
doubleArrayTwo-dimension double array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportArray() [6/6]

virtual void Aspose::Cells::ICells::ImportArray ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Double >>  doubleArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  isVertical 
)
pure virtual

Imports an array of double into a worksheet.

Parameters
doubleArrayDouble array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
isVerticalSpecifies to import data vertically or horizontally.

◆ ImportArrayList()

virtual void Aspose::Cells::ICells::ImportArrayList ( intrusive_ptr< Aspose::Cells::Systems::Collections::ArrayList >  arrayList,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  isVertical 
)
pure virtual

Imports an arraylist of data into a worksheet.

Parameters
arrayListData arraylist.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
isVerticalSpecifies to import data vertically or horizontally.

◆ ImportCSV() [1/4]

virtual void Aspose::Cells::ICells::ImportCSV ( intrusive_ptr< Aspose::Cells::Systems::String >  fileName,
intrusive_ptr< Aspose::Cells::Systems::String >  spliter,
bool  convertNumericData,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Import a CSV file to the cells.

Parameters
fileNameThe CSV file name.
spliterThe spliter
convertNumericDataWhether the string in text file is converted to numeric data.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportCSV() [2/4]

virtual void Aspose::Cells::ICells::ImportCSV ( intrusive_ptr< Aspose::Cells::Systems::IO::Stream >  stream,
intrusive_ptr< Aspose::Cells::Systems::String >  spliter,
bool  convertNumericData,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Import a CSV file to the cells.

Parameters
streamThe CSV file stream.
spliterThe spliter
convertNumericDataWhether the string in text file is converted to numeric data.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportCSV() [3/4]

virtual void Aspose::Cells::ICells::ImportCSV ( intrusive_ptr< Aspose::Cells::Systems::String >  fileName,
intrusive_ptr< Aspose::Cells::ITxtLoadOptions options,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Import a CSV file to the cells.

Parameters
fileNameThe CSV file name.
optionsThe load options for reading text file
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportCSV() [4/4]

virtual void Aspose::Cells::ICells::ImportCSV ( intrusive_ptr< Aspose::Cells::Systems::IO::Stream >  stream,
intrusive_ptr< Aspose::Cells::ITxtLoadOptions options,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Import a CSV file to the cells.

Parameters
streamThe CSV file stream.
optionsThe load options for reading text file
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportCustomObjects()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::ICells::ImportCustomObjects ( intrusive_ptr< Aspose::Cells::Systems::Collections::ICollection >  list,
intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>>  propertyNames,
bool  isPropertyNameShown,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  rowNumber,
bool  insertRows,
intrusive_ptr< Aspose::Cells::Systems::String >  dateFormatString,
bool  convertStringToNumber 
)
pure virtual

Imports custom objects.

Parameters
listThe custom object
propertyNamesThe property names. If it is null, we will import all properties of the object.
isPropertyNameShownIndicates whether the property name will be imported to the first row.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
rowNumberNumber of rows to be imported.
insertRowsIndicates whether extra rows are added to fit data.
dateFormatStringDate format string for cells.
convertStringToNumberIndicates if this method will try to convert string to number.
Returns
Total number of rows imported.

The custom objects should be the same type.

◆ ImportFormulaArray()

virtual void Aspose::Cells::ICells::ImportFormulaArray ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::String *>>  stringArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  isVertical 
)
pure virtual

Imports an array of formula into a worksheet.

Parameters
stringArrayFormula array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
isVerticalSpecifies to import data vertically or horizontally.

◆ ImportObjectArray() [1/2]

virtual void Aspose::Cells::ICells::ImportObjectArray ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Object *>>  objArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  isVertical 
)
pure virtual

Imports an array of data into a worksheet.

Parameters
objArrayData array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
isVerticalSpecifies to import data vertically or horizontally.

◆ ImportObjectArray() [2/2]

virtual void Aspose::Cells::ICells::ImportObjectArray ( intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Object *>>  objArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  isVertical,
Aspose::Cells::Systems::Int32  skip 
)
pure virtual

Imports an array of data into a worksheet.

Parameters
objArrayData array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
isVerticalSpecifies to import data vertically or horizontally.
skipSkipped number of rows or columns.

◆ ImportTwoDimensionArray() [1/4]

virtual void Aspose::Cells::ICells::ImportTwoDimensionArray ( intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>>  objArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn 
)
pure virtual

Imports a two-dimension array of data into a worksheet.

Parameters
objArrayTwo-dimension data array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.

◆ ImportTwoDimensionArray() [2/4]

virtual void Aspose::Cells::ICells::ImportTwoDimensionArray ( intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>>  objArray,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  convertStringToNumber 
)
pure virtual

Imports a two-dimension array of data into a worksheet.

Parameters
objArrayTwo-dimension data array.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
convertStringToNumberIndicates if this method will try to convert string to number.

◆ ImportTwoDimensionArray() [3/4]

virtual void Aspose::Cells::ICells::ImportTwoDimensionArray ( intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>>  objArray,
intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>>  styles,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
bool  convertStringToNumber 
)
pure virtual

Imports a two-dimension array of data into a worksheet.

Parameters
objArrayTwo-dimension data array.
stylesTwo-dimension data style.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
convertStringToNumberIndicates if this method will try to convert string to number.

◆ ImportTwoDimensionArray() [4/4]

virtual void Aspose::Cells::ICells::ImportTwoDimensionArray ( intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>>  objArray,
intrusive_ptr< Aspose::Cells::Systems::Array2D< Aspose::Cells::Systems::Object *>>  styles,
Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
intrusive_ptr< Aspose::Cells::ITxtLoadOptions opts 
)
pure virtual

Imports a two-dimension array of data into a worksheet.

Parameters
objArrayTwo-dimension data array.
stylesTwo-dimension data style.
firstRowThe row number of the first cell to import in.
firstColumnThe column number of the first cell to import in.
optsOptions for converting string values

◆ InsertColumn() [1/2]

virtual void Aspose::Cells::ICells::InsertColumn ( Aspose::Cells::Systems::Int32  columnIndex,
bool  updateReference 
)
pure virtual

Inserts a new column into the worksheet.

Parameters
columnIndexColumn index.
updateReferenceIndicates if references in other worksheets will be updated.

◆ InsertColumn() [2/2]

virtual void Aspose::Cells::ICells::InsertColumn ( Aspose::Cells::Systems::Int32  columnIndex)
pure virtual

Inserts a new column into the worksheet.

Parameters
columnIndexColumn index.

◆ InsertColumns() [1/2]

virtual void Aspose::Cells::ICells::InsertColumns ( Aspose::Cells::Systems::Int32  columnIndex,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Inserts some columns into the worksheet.

Parameters
columnIndexColumn index.
totalColumnsThe number of columns.

◆ InsertColumns() [2/2]

virtual void Aspose::Cells::ICells::InsertColumns ( Aspose::Cells::Systems::Int32  columnIndex,
Aspose::Cells::Systems::Int32  totalColumns,
bool  updateReference 
)
pure virtual

Inserts some columns into the worksheet.

Parameters
columnIndexColumn index.
totalColumnsThe number of columns.
updateReferenceIndicates if references in other worksheets will be updated.

◆ InsertIRange() [1/3]

virtual void Aspose::Cells::ICells::InsertIRange ( intrusive_ptr< Aspose::Cells::ICellArea area,
Aspose::Cells::Systems::Int32  shiftNumber,
Aspose::Cells::ShiftType  shiftType,
bool  updateReference 
)
pure virtual

Inserts a range of cells and shift cells according to the shift option.

Parameters
areaShift area.
shiftNumberNumber of rows or columns to be inserted.
shiftTypeShift cells option.
updateReferenceIndicates if update references in other worksheets.

◆ InsertIRange() [2/3]

virtual void Aspose::Cells::ICells::InsertIRange ( intrusive_ptr< Aspose::Cells::ICellArea area,
Aspose::Cells::ShiftType  shiftType 
)
pure virtual

Inserts a range of cells and shift cells according to the shift option.

Parameters
areaShift area.
shiftTypeShift cells option.

◆ InsertIRange() [3/3]

virtual void Aspose::Cells::ICells::InsertIRange ( intrusive_ptr< Aspose::Cells::ICellArea area,
Aspose::Cells::Systems::Int32  shiftNumber,
Aspose::Cells::ShiftType  shiftType 
)
pure virtual

Inserts a range of cells and shift cells according to the shift option.

Parameters
areaShift area.
shiftNumberNumber of rows or columns to be inserted.
shiftTypeShift cells option.

◆ InsertRow()

virtual void Aspose::Cells::ICells::InsertRow ( Aspose::Cells::Systems::Int32  rowIndex)
pure virtual

Inserts a new row into the worksheet.

Parameters
rowIndexRow index.

◆ InsertRows() [1/2]

virtual void Aspose::Cells::ICells::InsertRows ( Aspose::Cells::Systems::Int32  rowIndex,
Aspose::Cells::Systems::Int32  totalRows,
bool  updateReference 
)
pure virtual

Inserts multiple rows into the worksheet.

Parameters
rowIndexRow index.
totalRowsNumber of rows to be inserted.
updateReferenceIndicates if references in other worksheets will be updated.

◆ InsertRows() [2/2]

virtual void Aspose::Cells::ICells::InsertRows ( Aspose::Cells::Systems::Int32  rowIndex,
Aspose::Cells::Systems::Int32  totalRows 
)
pure virtual

Inserts multiple rows into the worksheet.

Parameters
rowIndexRow index.
totalRowsNumber of rows to be inserted.

◆ IsBlankColumn()

virtual bool Aspose::Cells::ICells::IsBlankColumn ( Aspose::Cells::Systems::Int32  columnIndex)
pure virtual

Checks whether given column is blank (does not contain any data).

Parameters
columnIndexthe column index
Returns
true if given column does not contain any data

◆ IsColumnHidden()

virtual bool Aspose::Cells::ICells::IsColumnHidden ( Aspose::Cells::Systems::Int32  columnIndex)
pure virtual

Checks whether a column at given index is hidden.

Parameters
columnIndexcolumn index
Returns
true if the column is hidden.

◆ IsDefaultRowHeightMatched()

virtual bool Aspose::Cells::ICells::IsDefaultRowHeightMatched ( )
pure virtual

Indicates that row height and default font height matches

◆ IsDefaultRowHidden()

virtual bool Aspose::Cells::ICells::IsDefaultRowHidden ( )
pure virtual

Indicates whether the row is default hidden.

◆ IsDeletingRangeEnabled()

virtual bool Aspose::Cells::ICells::IsDeletingRangeEnabled ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  startColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Check whether the range could be deleted.

Parameters
startRowThe start row index of the range.
startColumnThe start column idnex of the range.
totalRowsThe number of the rows in the range.
totalColumnsThe number of the columns in the range.
Returns

◆ IsRowHidden()

virtual bool Aspose::Cells::ICells::IsRowHidden ( Aspose::Cells::Systems::Int32  rowIndex)
pure virtual

Checks whether a row at given index is hidden.

Parameters
rowIndexrow index
Returns
true if the row is hidden

◆ LinkToXmlMap()

virtual void Aspose::Cells::ICells::LinkToXmlMap ( intrusive_ptr< Aspose::Cells::Systems::String >  mapName,
Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  column,
intrusive_ptr< Aspose::Cells::Systems::String >  path 
)
pure virtual

Link to a xml map.

Parameters
mapNamename of xml map
rowrow of the destination cell
columncolumn of the destination cell
pathpath of xml element in xml map

◆ Merge() [1/3]

virtual void Aspose::Cells::ICells::Merge ( Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Merges a specified range of cells into a single cell.

Parameters
firstRowFirst row of this range(zero based)
firstColumnFirst column of this range(zero based)
totalRowsNumber of rows(one based)
totalColumnsNumber of columns(one based)

Reference the merged cell via the address of the upper-left cell in the range.

◆ Merge() [2/3]

virtual void Aspose::Cells::ICells::Merge ( Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns,
bool  mergeConflict 
)
pure virtual

Merges a specified range of cells into a single cell.

Parameters
firstRowFirst row of this range(zero based)
firstColumnFirst column of this range(zero based)
totalRowsNumber of rows(one based)
totalColumnsNumber of columns(one based)
mergeConflictMerge conflict merged ranges.

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.

◆ Merge() [3/3]

virtual void Aspose::Cells::ICells::Merge ( Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns,
bool  checkConflict,
bool  mergeConflict 
)
pure virtual

Merges a specified range of cells into a single cell.

Parameters
firstRowFirst row of this range(zero based)
firstColumnFirst column of this range(zero based)
totalRowsNumber of rows(one based)
totalColumnsNumber of columns(one based)
checkConflictIndicates whether check the merged cells intersects other merged cells
mergeConflictMerge conflict merged ranges.

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.

◆ MoveIRange()

virtual void Aspose::Cells::ICells::MoveIRange ( intrusive_ptr< Aspose::Cells::ICellArea sourceArea,
Aspose::Cells::Systems::Int32  destRow,
Aspose::Cells::Systems::Int32  destColumn 
)
pure virtual

Moves the range to destination postion.

Parameters
sourceAreaThe range which should be moved.
destRowThe dest row.
destColumnThe dest column.

◆ release_ref()

virtual int Aspose::Cells::ICells::release_ref ( )
inlinevirtual

◆ RemoveDuplicates()

virtual void Aspose::Cells::ICells::RemoveDuplicates ( Aspose::Cells::Systems::Int32  startRow,
Aspose::Cells::Systems::Int32  startColumn,
Aspose::Cells::Systems::Int32  endRow,
Aspose::Cells::Systems::Int32  endColumn 
)
pure virtual

Remove duplicate values in the range.

Parameters
startRowThe start row.
startColumnThe start column
endRowThe end row index.
endColumnThe end column index.

◆ RemoveFormulas()

virtual void Aspose::Cells::ICells::RemoveFormulas ( )
pure virtual

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

◆ SetColumnWidth()

virtual void Aspose::Cells::ICells::SetColumnWidth ( Aspose::Cells::Systems::Int32  column,
Aspose::Cells::Systems::Double  width 
)
pure virtual

Sets the width of the specified column.

Parameters
columnColumn index.
widthWidth of column.Column width must be between 0 and 255.

To hide a column, sets column width to zero.

◆ SetColumnWidthInch()

virtual void Aspose::Cells::ICells::SetColumnWidthInch ( Aspose::Cells::Systems::Int32  column,
Aspose::Cells::Systems::Double  inches 
)
pure virtual

Sets column width in unit of inches.

Parameters
columnColumn index.
inchesNumber of inches.

◆ SetColumnWidthPixel()

virtual void Aspose::Cells::ICells::SetColumnWidthPixel ( Aspose::Cells::Systems::Int32  column,
Aspose::Cells::Systems::Int32  pixel 
)
pure virtual

Sets column width in unit of pixels.

Parameters
columnColumn index.
pixelNumber of pixels.

◆ SetDefaultRowHeightMatched()

virtual void Aspose::Cells::ICells::SetDefaultRowHeightMatched ( bool  value)
pure virtual

Indicates that row height and default font height matches

◆ SetDefaultRowHidden()

virtual void Aspose::Cells::ICells::SetDefaultRowHidden ( bool  value)
pure virtual

Indicates whether the row is default hidden.

◆ SetIStyle()

virtual void Aspose::Cells::ICells::SetIStyle ( intrusive_ptr< Aspose::Cells::IStyle value)
pure virtual

Sets the default style.

◆ SetMemorySetting()

virtual void Aspose::Cells::ICells::SetMemorySetting ( Aspose::Cells::MemorySetting  value)
pure virtual

Sets the memory usage option for this cells.

◆ SetMultiThreadReading()

virtual void Aspose::Cells::ICells::SetMultiThreadReading ( bool  value)
pure virtual

Sets whether the cells data model should support Multi-Thread reading. Default value is false. If there are multiple threads to read Row/Cell objects in this collection concurrently, this method 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.

◆ SetPreserveString()

virtual void Aspose::Cells::ICells::SetPreserveString ( bool  value)
pure virtual

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

◆ SetRowHeight()

virtual void Aspose::Cells::ICells::SetRowHeight ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Double  height 
)
pure virtual

Sets the height of the specified row.

Parameters
rowRow index.
heightHeight of row.In unit of point It should be between 0 and 409.5.

◆ SetRowHeightInch()

virtual void Aspose::Cells::ICells::SetRowHeightInch ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Double  inches 
)
pure virtual

Sets row height in unit of inches.

Parameters
rowRow index.
inchesNumber of inches.It should be between 0 and 409.5/72.

◆ SetRowHeightPixel()

virtual void Aspose::Cells::ICells::SetRowHeightPixel ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  pixels 
)
pure virtual

Sets row height in unit of pixels.

Parameters
rowRow index.
pixelsNumber of pixels.

◆ SetStandardHeight()

virtual void Aspose::Cells::ICells::SetStandardHeight ( Aspose::Cells::Systems::Double  value)
pure virtual

Sets the default row height in this worksheet, in unit of points.

◆ SetStandardHeightPixels()

virtual void Aspose::Cells::ICells::SetStandardHeightPixels ( Aspose::Cells::Systems::Int32  value)
pure virtual

Sets the default row height in this worksheet, in unit of pixels.

◆ SetStandardWidth()

virtual void Aspose::Cells::ICells::SetStandardWidth ( Aspose::Cells::Systems::Double  value)
pure virtual

Sets the default column width in the worksheet, in unit of characters.

◆ SetStandardWidthInch()

virtual void Aspose::Cells::ICells::SetStandardWidthInch ( Aspose::Cells::Systems::Double  value)
pure virtual

Sets the default column width in the worksheet, in unit of inches.

◆ SetStandardWidthPixels()

virtual void Aspose::Cells::ICells::SetStandardWidthPixels ( Aspose::Cells::Systems::Int32  value)
pure virtual

Sets the default column width in the worksheet, in unit of pixels.

◆ ShowGroupDetail()

virtual void Aspose::Cells::ICells::ShowGroupDetail ( bool  isVertical,
Aspose::Cells::Systems::Int32  index 
)
pure virtual

Unclasps the grouped rows/columns.

Parameters
isVerticalTrue, uncollapse the grouped rows.
indexThe row/column index

◆ Subtotal() [1/2]

virtual void Aspose::Cells::ICells::Subtotal ( intrusive_ptr< Aspose::Cells::ICellArea ca,
Aspose::Cells::Systems::Int32  groupBy,
Aspose::Cells::ConsolidationFunction  function,
intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >>  totalList 
)
pure virtual

Creates subtotals for the range.

Parameters
caThe range
groupByThe field to group by, as a zero-based integer offset
functionThe subtotal function.
totalListAn array of zero-based field offsets, indicating the fields to which the subtotals are added.

◆ Subtotal() [2/2]

virtual void Aspose::Cells::ICells::Subtotal ( intrusive_ptr< Aspose::Cells::ICellArea ca,
Aspose::Cells::Systems::Int32  groupBy,
Aspose::Cells::ConsolidationFunction  function,
intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >>  totalList,
bool  replace,
bool  pageBreaks,
bool  summaryBelowData 
)
pure virtual

Creates subtotals for the range.

Parameters
caThe range
groupByThe field to group by, as a zero-based integer offset
functionThe subtotal function.
totalListAn array of zero-based field offsets, indicating the fields to which the subtotals are added.
replaceIndicates whether replace the current subtotals
pageBreaksIndicates whether add page break between groups
summaryBelowDataIndicates whether add summarry below data.

◆ TextToColumns()

virtual void Aspose::Cells::ICells::TextToColumns ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  column,
Aspose::Cells::Systems::Int32  totalRows,
intrusive_ptr< Aspose::Cells::ITxtLoadOptions options 
)
pure virtual

Splits the text in the column to columns.

Parameters
rowThe row index.
columnThe column index.
totalRowsThe number of rows.
optionsThe split options.

◆ UngroupColumns()

virtual void Aspose::Cells::ICells::UngroupColumns ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  lastIndex 
)
pure virtual

Ungroups columns.

Parameters
firstIndexThe first column index to be ungrouped.
lastIndexThe last column index to be ungrouped.

◆ UngroupRows() [1/2]

virtual void Aspose::Cells::ICells::UngroupRows ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  lastIndex,
bool  isAll 
)
pure virtual

Ungroups rows.

Parameters
firstIndexThe first row index to be ungrouped.
lastIndexThe last row index to be ungrouped.
isAllTrue, removes all grouped info.Otherwise, remove the outter group info.

◆ UngroupRows() [2/2]

virtual void Aspose::Cells::ICells::UngroupRows ( Aspose::Cells::Systems::Int32  firstIndex,
Aspose::Cells::Systems::Int32  lastIndex 
)
pure virtual

Ungroups rows.

Parameters
firstIndexThe first row index to be ungrouped.
lastIndexThe last row index to be ungrouped.

Only removes outter group info.

◆ UnhideColumn()

virtual void Aspose::Cells::ICells::UnhideColumn ( Aspose::Cells::Systems::Int32  column,
Aspose::Cells::Systems::Double  width 
)
pure virtual

Unhides a column.

Parameters
columnColumn index.
widthColumn width.

◆ UnhideColumns()

virtual void Aspose::Cells::ICells::UnhideColumns ( Aspose::Cells::Systems::Int32  column,
Aspose::Cells::Systems::Int32  totlaColumns,
Aspose::Cells::Systems::Double  width 
)
pure virtual

Unhide mutiple columns.

Parameters
columnColumn index.
totlaColumnsColumn number
widthColumn width.

Only applies the column width to the hidden columns.

◆ UnhideRow()

virtual void Aspose::Cells::ICells::UnhideRow ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Double  height 
)
pure virtual

Unhides a row.

Parameters
rowRow index.
heightRow height. The row's height will be changed only when the row is hidden and given height value is positive.

◆ UnhideRows()

virtual void Aspose::Cells::ICells::UnhideRows ( Aspose::Cells::Systems::Int32  row,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Double  height 
)
pure virtual

Unhides the hidden rows.

Parameters
rowThe row index.
totalRowsThe row number.
heightRow height. The row's height will be changed only when the row is hidden and given height value is positive.

◆ UnMerge()

virtual void Aspose::Cells::ICells::UnMerge ( Aspose::Cells::Systems::Int32  firstRow,
Aspose::Cells::Systems::Int32  firstColumn,
Aspose::Cells::Systems::Int32  totalRows,
Aspose::Cells::Systems::Int32  totalColumns 
)
pure virtual

Unmerges a specified range of merged cells.

Parameters
firstRowFirst row of this range(zero based)
firstColumnFirst column of this range(zero based)
totalRowsNumber of rows(one based)
totalColumnsNumber of columns(one based)