Aspose::Cells::ICells Class Reference

Encapsulates a collection of ICell objects. More...

Inherits IEnumerable, IDisposable, and Object.

Public Member Functions
virtual void	Dispose ()=0
	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. More...
virtual Aspose::Cells::Systems::Int32	GetCount ()=0
	Gets the total count of instantiated Cell objects. More...
virtual Aspose::Cells::Systems::Int64	GetCountLarge ()=0
	Gets the total count of instantiated Cell objects. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	GetObjectByIndex (Aspose::Cells::Systems::Int32 index)=0
	Gets Cell item within the worksheet 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::IRowCollection >	GetIRows ()=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::ICell >	GetICell (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::IRow >	GetIRow (Aspose::Cells::Systems::Int32 row)=0
	Gets the IRow element at the specified cell row index. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	CheckICell (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::IRow >	CheckIRow (Aspose::Cells::Systems::Int32 row)=0
	Gets the IRow element or at the specified cell row index. More...
virtual intrusive_ptr< Aspose::Cells::IColumn >	CheckIColumn (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::IRange >	CreateIRange (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::IRange >	CreateIRange (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::IRange >	CreateIRange (intrusive_ptr< Aspose::Cells::Systems::String > address)=0
	Creates an IRange object from an address of the range. More...
virtual intrusive_ptr< Aspose::Cells::IRange >	CreateIRange (Aspose::Cells::Systems::Int32 firstIndex, Aspose::Cells::Systems::Int32 number, bool isVertical)=0
	Creates a IRange object from rows of cells or columns of cells. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	GetObjectByIndex (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::ICell >	GetObjectByIndex (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::IStyle >	GetIStyle ()=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 Aspose::Cells::Systems::Double	GetStandardHeightInch ()=0
	Gets the default row height in this worksheet, in unit of inches. More...
virtual void	SetStandardHeightInch (Aspose::Cells::Systems::Double value)=0
	Sets the default row height in this worksheet, in unit of inches. 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 > splitter, 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 > splitter, 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	ClearMergedCells ()=0
	Clears all merged ranges. 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	GetRowOriginalHeightPoint (Aspose::Cells::Systems::Int32 row)=0
	Gets original row's height in unit of point if the row is hidden 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 multiple columns. More...
virtual void	UnhideColumns (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Int32 totalColumns, Aspose::Cells::Systems::Double width)=0
	Unhide multiple columns. More...
virtual Aspose::Cells::Systems::Double	GetRowHeight (Aspose::Cells::Systems::Int32 row)=0
	Gets the height of a specified row. More...
virtual Aspose::Cells::Systems::Double	GetViewRowHeight (Aspose::Cells::Systems::Int32 row)=0
	Gets the height of a specified row. 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 Aspose::Cells::Systems::Double	GetViewRowHeightInch (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 pixels)=0
	Sets column width in unit of pixels in normal view. More...
virtual void	SetColumnWidthInch (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Double inches)=0
	Sets column width in unit of inches in normal view. More...
virtual void	SetColumnWidth (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Double width)=0
	Sets the width of the specified column in normal view. More...
virtual Aspose::Cells::Systems::Int32	GetColumnWidthPixel (Aspose::Cells::Systems::Int32 column)=0
	Gets the width of the specified column in normal view, 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 normal view, in units of inches. More...
virtual Aspose::Cells::Systems::Double	GetColumnWidth (Aspose::Cells::Systems::Int32 column)=0
	Gets the width of the specified column in normal view More...
virtual Aspose::Cells::Systems::Int32	GetViewColumnWidthPixel (Aspose::Cells::Systems::Int32 column)=0
	Get the width in different view type. More...
virtual void	SetViewColumnWidthPixel (Aspose::Cells::Systems::Int32 column, Aspose::Cells::Systems::Int32 pixels)=0
	Sets the width of the column in different view. 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 those cells that have been instantiated in the collection(does not include the column where style is defined for the whole column but no cell has been instantiated in it). More...
virtual Aspose::Cells::Systems::Int32	GetMaxColumn ()=0
	Minimum column index of those cells that have been instantiated in the collection(does not include the column where style is defined for the whole column but no cell has been instantiated in it). 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::IColumnCollection >	GetIColumns ()=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 formats 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 formats for a whole row. More...
virtual void	ApplyIStyle (intrusive_ptr< Aspose::Cells::IStyle > style, intrusive_ptr< Aspose::Cells::IStyleFlag > flag)=0
	Applies formats for a whole worksheet. More...
virtual void	CopyIColumns (intrusive_ptr< Aspose::Cells::ICells > sourceCells0, Aspose::Cells::Systems::Int32 sourceColumnIndex, Aspose::Cells::Systems::Int32 destinationColumnIndex, Aspose::Cells::Systems::Int32 columnNumber, intrusive_ptr< Aspose::Cells::IPasteOptions > pasteOptions)=0
	Copies data and formats of a whole column. More...
virtual void	CopyIColumn (intrusive_ptr< Aspose::Cells::ICells > sourceCells, Aspose::Cells::Systems::Int32 sourceColumnIndex, Aspose::Cells::Systems::Int32 destinationColumnIndex)=0
	Copies data and formats of a whole column. More...
virtual void	CopyIColumns (intrusive_ptr< Aspose::Cells::ICells > sourceCells0, Aspose::Cells::Systems::Int32 sourceColumnIndex, Aspose::Cells::Systems::Int32 destinationColumnIndex, Aspose::Cells::Systems::Int32 columnNumber)=0
	Copies data and formats 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 formats 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 formats 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 formats of some whole rows. More...
virtual void	CopyIRows (intrusive_ptr< Aspose::Cells::ICells > sourceCells0, 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 formats of some whole rows. More...
virtual void	CopyIRows (intrusive_ptr< Aspose::Cells::ICells > sourceCells0, Aspose::Cells::Systems::Int32 sourceRowIndex, Aspose::Cells::Systems::Int32 destinationRowIndex, Aspose::Cells::Systems::Int32 rowNumber, intrusive_ptr< Aspose::Cells::ICopyOptions > copyOptions, intrusive_ptr< Aspose::Cells::IPasteOptions > pasteOptions)=0
	Copies data and formats 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
	Uncollapses 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::IRangeCollection >	GetIRanges ()=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::ICell >	GetLastICell ()=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::IRange >	GetMaxDisplayIRange ()=0
	Gets the max range which includes data, merged cells and shapes. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	GetFirstICell ()=0
	Gets the first cell in this worksheet. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	FindFormula (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::ICell >	FindFormulaContains (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::ICell >	Find (intrusive_ptr< Aspose::Cells::Systems::Object > what, intrusive_ptr< Aspose::Cells::ICell > previousCell)=0
	Finds the cell containing with the input object. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	Find (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::ICell >	EndICellInRow (Aspose::Cells::Systems::Int32 rowIndex)=0
	Gets the last cell in this row. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	EndICellInColumn (Aspose::Cells::Systems::Int16 columnIndex)=0
	Gets the last cell in this column. More...
virtual intrusive_ptr< Aspose::Cells::ICell >	EndICellInColumn (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::ICell >	EndICellInRow (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. More...
virtual void	InsertCutCells (intrusive_ptr< Aspose::Cells::IRange > cutRange, Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column, Aspose::Cells::ShiftType shiftType)=0
	Insert cut range. 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 ()=0
	Removes duplicate rows in the sheet. 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
	Removes duplicate values in the range. More...
virtual void	RemoveDuplicates (Aspose::Cells::Systems::Int32 startRow, Aspose::Cells::Systems::Int32 startColumn, Aspose::Cells::Systems::Int32 endRow, Aspose::Cells::Systems::Int32 endColumn, bool hasHeaders, intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >> columnOffsets)=0
	Removes duplicate data of 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::Systems::Collections::IEnumerator >	GetDependentsInCalculation (Aspose::Cells::Systems::Int32 row, Aspose::Cells::Systems::Int32 column, bool recursive)=0
	Gets all cells whose calculated result depends on specific cell. More...
virtual intrusive_ptr< Aspose::Cells::IStyle >	GetCellIStyle (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

rangeObject

The 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 formats for a whole column.

Parameters

column	The column index.
style	The style object which will be applied.
flag	Flags which indicates applied formatting properties.

ApplyIStyle()

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

pure virtual

Applies formats for a whole worksheet.

Parameters

style	The style object which will be applied.
flag	Flags 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 formats for a whole row.

Parameters

row	The row index.
style	The style object which will be applied.
flag	Flags which indicates applied formatting properties.

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

row	Row index
column	Column 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

columnIndex

The 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

row

Row 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

range

Range 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

startRow	Start row index.
startColumn	Start column index.
endRow	End row index.
endColumn	End 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

range

Range 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

startRow	Start row index.
startColumn	Start column index.
endRow	End row index.
endColumn	End column index.

ClearMergedCells()

virtual void Aspose::Cells::ICells::ClearMergedCells ( )

pure virtual

Clears all merged ranges.

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

range

Range 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

startRow	Start row index.
startColumn	Start column index.
endRow	End row index.
endColumn	End 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 formats of a whole column.

Parameters

sourceCells	Source Cells object contains data and formats to copy.
sourceColumnIndex	Source column index.
destinationColumnIndex	Destination column index.

CopyIColumns() [1/3]

virtual void Aspose::Cells::ICells::CopyIColumns ( intrusive_ptr< Aspose::Cells::ICells >  sourceCells0, Aspose::Cells::Systems::Int32  sourceColumnIndex, Aspose::Cells::Systems::Int32  destinationColumnIndex, Aspose::Cells::Systems::Int32  columnNumber, intrusive_ptr< Aspose::Cells::IPasteOptions >  pasteOptions  )

pure virtual

Copies data and formats of a whole column.

Parameters

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

CopyIColumns() [2/3]

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

pure virtual

Copies data and formats of a whole column.

Parameters

sourceCells0	Source Cells object contains data and formats to copy.
sourceColumnIndex	Source column index.
destinationColumnIndex	Destination column index.
columnNumber	The copied column number.

CopyIColumns() [3/3]

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 formats of the whole columns.

Parameters

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

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 formats of a whole row.

Parameters

sourceCells	Source Cells object contains data and formats to copy.
sourceRowIndex	Source row index.
destinationRowIndex	Destination row index.

CopyIRows() [1/3]

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 formats of some whole rows.

Parameters

sourceCells	Source Cells object contains data and formats to copy.
sourceRowIndex	Source row index.
destinationRowIndex	Destination row index.
rowNumber	The copied row number.

CopyIRows() [2/3]

virtual void Aspose::Cells::ICells::CopyIRows ( intrusive_ptr< Aspose::Cells::ICells >  sourceCells0, 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 formats of some whole rows.

Parameters

sourceCells0	Source Cells object contains data and formats to copy.
sourceRowIndex	Source row index.
destinationRowIndex	Destination row index.
rowNumber	The copied row number.
copyOptions	The copy options.

CopyIRows() [3/3]

virtual void Aspose::Cells::ICells::CopyIRows ( intrusive_ptr< Aspose::Cells::ICells >  sourceCells0, Aspose::Cells::Systems::Int32  sourceRowIndex, Aspose::Cells::Systems::Int32  destinationRowIndex, Aspose::Cells::Systems::Int32  rowNumber, intrusive_ptr< Aspose::Cells::ICopyOptions >  copyOptions, intrusive_ptr< Aspose::Cells::IPasteOptions >  pasteOptions  )

pure virtual

Copies data and formats of some whole rows.

Parameters

sourceCells0	Source Cells object contains data and formats to copy.
sourceRowIndex	Source row index.
destinationRowIndex	Destination row index.
rowNumber	The copied row number.
copyOptions	The copy options.
pasteOptions	the options of pasting.

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

upperLeftCell	Upper left cell name.
lowerRightCell	Lower 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

firstRow	First row of this range
firstColumn	First column of this range
totalRows	Number of rows
totalColumns	Number 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

address

The 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 a IRange object from rows of cells or columns of cells.

Parameters

firstIndex	First row index or first column index, zero based.
number	Total number of rows or columns, one based.
isVertical	True - Range created from columns of cells. False - Range created from rows of cells.

Returns

A 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

columnIndex	Column index.
updateReference	Indicates 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

columnIndex

Column 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

columnIndex	Column index.
totalColumns	Number of columns to be deleted.
updateReference	Indicates 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

startRow	Start row index.
startColumn	Start column index.
endRow	End row index.
endColumn	End column index.
shiftType	Shift cells option.

DeleteRow()

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

pure virtual

Deletes a row.

Parameters

rowIndex

Row 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

rowIndex	The first row index to be deleted.
totalRows	Number 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

rowIndex	Row index.
totalRows	Number of rows to be deleted.
updateReference	Indicates if update references in other worksheets.

Returns

Dispose()

virtual void Aspose::Cells::ICells::Dispose ( )

pure virtual

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

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

columnIndex

Column 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

startRow	Start row index.
endRow	End row index.
startColumn	Start column index.
endColumn	End 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

rowIndex

Row 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

startRow	Start row index.
endRow	End row index.
startColumn	Start column index.
endColumn	End 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

firstRow	The row number of the first cell to export out.
firstColumn	The column number of the first cell to export out.
totalRows	Number of rows to be exported
totalColumns	Number of columns to be exported

Returns

Exported cell value array object.

ExportTypeArray()

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

firstRow	The row number of the first cell to export out.
firstColumn	The column number of the first cell to export out.
totalRows	Number of rows to be exported.
totalColumns	Number of columns to be exported.

Returns

Exported CellValuetype array object.

Find() [1/2]

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

pure virtual

Finds the cell containing with the input object.

Parameters

what	The object to search for. The type should be int,double,DateTime,string,bool.
previousCell	Previous cell with the same object. This parameter can be set to null if searching from the start.

Returns

Cell object.

Returns null (Nothing) if no cell is found.

Find() [2/2]

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

what	The object to search for. The type should be int,double,DateTime,string,bool.
previousCell	Previous cell with the same object. This parameter can be set to null if searching from the start.
findOptions	Find options

Returns

Cell object.

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

formula	The formula to search for.
previousCell	Previous cell with the same formula. This parameter can be set to null if searching from the start.

Returns

Cell object.

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

formula	The formula to search for.
previousCell	Previous cell with the same formula. This parameter can be set to null if searching from the start.

Returns

Cell object.

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

row	row index
column	column

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 in normal view

Parameters

column

Column 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 normal view, in units of inches.

Parameters

column

Column 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 normal view, in units of pixel.

Parameters

column

Column index

Returns

Width of column in normal view.

GetCount()

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

pure virtual

Gets the total count of instantiated Cell objects.

GetCountLarge()

virtual Aspose::Cells::Systems::Int64 Aspose::Cells::ICells::GetCountLarge ( )

pure virtual

Gets the total count of instantiated Cell objects.

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

isAll	Indicates whether check other worksheets
row	The row index.
column	The column index.

Returns

GetDependentsInCalculation()

virtual intrusive_ptr<Aspose::Cells::Systems::Collections::IEnumerator> Aspose::Cells::ICells::GetDependentsInCalculation ( Aspose::Cells::Systems::Int32  row, Aspose::Cells::Systems::Int32  column, bool  recursive  )

pure virtual

Gets all cells whose calculated result depends on specific cell.

Parameters

row	Row index of the specific cell
column	Column index of the specific cell.
recursive	Whether returns those dependents which do not reference to the specific cell directly but reference to other leafs of that cell.

Returns

Enumerator to enumerate all dependents(Cell objects)

GetEnumerator()

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

pure virtual

Gets the cells enumerator.

GetFirstICell()

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

pure virtual

Gets the first cell in this worksheet.

Returns null if there is no data in the 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

columnIndex

The 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

rowIndex

The 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

row	Row index
column	Column 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

row

Row 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

column

Column 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.

Returns null if there is no data in the worksheet.

GetMaxColumn()

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

pure virtual

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

Return -1 if there is no cell.

GetMaxDataColumn()

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

pure virtual

Maximum column index of cell which contains data.

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

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 those cells that have been instantiated in the collection(does not include the column where style is defined for the whole column but no cell has been instantiated in it).

GetMinDataColumn()

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

pure virtual

Minimum column index of cell which contains data.

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

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 Cell item within the worksheet

Parameters

index

The zero based index of the element.

The element at the specified index.

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

row	Row index.
column	Column 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

cellName

Cell 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

row

Row 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

row

Row 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

row

Row index

Returns

Height of row

GetRowOriginalHeightPoint()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetRowOriginalHeightPoint ( Aspose::Cells::Systems::Int32  row )

pure virtual

Gets original row's height in unit of point if the row is hidden

Parameters

row	The row index.

Returns

GetStandardHeight()

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

pure virtual

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

GetStandardHeightInch()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetStandardHeightInch ( )

pure virtual

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

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.

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

column

The column index.

Returns

the column width in unit of pixels

GetViewRowHeight()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetViewRowHeight ( Aspose::Cells::Systems::Int32  row )

pure virtual

Gets the height of a specified row.

Parameters

row

Row index

Returns

Height of row

GetViewRowHeightInch()

virtual Aspose::Cells::Systems::Double Aspose::Cells::ICells::GetViewRowHeightInch ( Aspose::Cells::Systems::Int32  row )

pure virtual

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

Parameters

row

Row index

Returns

Height of row

GroupColumns() [1/2]

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

pure virtual

Groups columns.

Parameters

firstIndex	The first column index to be grouped.
lastIndex	The 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

firstIndex	The first column index to be grouped.
lastIndex	The last column index to be grouped.
isHidden	Specifies 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

firstIndex	The first row index to be grouped.
lastIndex	The last row index to be grouped.
isHidden	Specifies if the grouped columns are hidden.

GroupRows() [2/2]

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

pure virtual

Groups rows.

Parameters

firstIndex	The first row index to be grouped.
lastIndex	The last row index to be grouped.

HideColumn()

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

pure virtual

Hides a column.

Parameters

column

Column index.

HideColumns()

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

pure virtual

Hide multiple columns.

Parameters

column	Column index.
totalColumns	Column number.

HideGroupDetail()

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

pure virtual

Collapses the grouped rows/columns.

Parameters

isVertical	True, collapse the grouped rows.
index	The row/column index

HideRow()

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

pure virtual

Hides a row.

Parameters

row	Row index.

HideRows()

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

pure virtual

Hides multiple rows.

Parameters

row	The row index.
totalRows	The 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

stringArray	Two-dimension string array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.

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

stringArray	String array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.
isVertical	Specifies to import data vertically or horizontally.

ImportArray() [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

intArray	Two-dimension integer array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.

ImportArray() [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

intArray	Integer array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.
isVertical	Specifies to import data vertically or horizontally.

ImportArray() [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

doubleArray	Two-dimension double array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.

ImportArray() [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

doubleArray	Double array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.
isVertical	Specifies to import data vertically or horizontally.

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

arrayList	Data arraylist.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.
isVertical	Specifies to import data vertically or horizontally.

ImportCSV() [1/4]

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

pure virtual

Import a CSV file to the cells.

Parameters

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

ImportCSV() [2/4]

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

pure virtual

Import a CSV file to the cells.

Parameters

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

ImportCSV() [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

fileName	The CSV file name.
options	The load options for reading text file
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.

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

stream	The CSV file stream.
options	The load options for reading text file
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.

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

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

Returns

Total number of rows imported.

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

stringArray	Formula array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.
isVertical	Specifies to import data vertically or horizontally.

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

objArray	Data array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.
isVertical	Specifies to import data vertically or horizontally.

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

objArray	Data array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.
isVertical	Specifies to import data vertically or horizontally.
skip	Skipped number of rows or columns.

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

objArray	Two-dimension data array.
firstRow	The row number of the first cell to import in.
firstColumn	The column number of the first cell to import in.

ImportTwoDimensionArray() [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

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

ImportTwoDimensionArray() [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

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

ImportTwoDimensionArray() [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

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

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

columnIndex	Column index.
updateReference	Indicates 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

columnIndex

Column 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

columnIndex	Column index.
totalColumns	The 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

columnIndex	Column index.
totalColumns	The number of columns.
updateReference	Indicates if references in other worksheets will be updated.

InsertCutCells()

virtual void Aspose::Cells::ICells::InsertCutCells ( intrusive_ptr< Aspose::Cells::IRange >  cutRange, Aspose::Cells::Systems::Int32  row, Aspose::Cells::Systems::Int32  column, Aspose::Cells::ShiftType  shiftType  )

pure virtual

Insert cut range.

Parameters

cutRange	The cut range.
row	The row.
column	The column.
shiftType	The shift type .

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

area	Shift area.
shiftNumber	Number of rows or columns to be inserted.
shiftType	Shift cells option.
updateReference	Indicates 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

area	Shift area.
shiftType	Shift 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

area	Shift area.
shiftNumber	Number of rows or columns to be inserted.
shiftType	Shift cells option.

InsertRow()

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

pure virtual

Inserts a new row into the worksheet.

Parameters

rowIndex

Row 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

rowIndex	Row index.
totalRows	Number of rows to be inserted.
updateReference	Indicates 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

rowIndex	Row index.
totalRows	Number 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

columnIndex

the 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

columnIndex

column 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

startRow	The start row index of the range.
startColumn	The start column index of the range.
totalRows	The number of the rows in the range.
totalColumns	The number of the columns in the range.

Returns

IsRowHidden()

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

pure virtual

Checks whether a row at given index is hidden.

Parameters

rowIndex

row 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

mapName	name of xml map
row	row of the destination cell
column	column of the destination cell
path	path of xml element in xml map

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

firstRow	First row of this range(zero based)
firstColumn	First column of this range(zero based)
totalRows	Number of rows(one based)
totalColumns	Number of columns(one based)

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

firstRow	First row of this range(zero based)
firstColumn	First column of this range(zero based)
totalRows	Number of rows(one based)
totalColumns	Number of columns(one based)
mergeConflict	Merge conflict merged ranges.

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

firstRow	First row of this range(zero based)
firstColumn	First column of this range(zero based)
totalRows	Number of rows(one based)
totalColumns	Number of columns(one based)
checkConflict	Indicates whether check the merged cells intersects other merged cells
mergeConflict	Merge conflict merged ranges.

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.

Parameters

sourceArea	The range which should be moved.
destRow	The dest row.
destColumn	The dest column.

release_ref()

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

inlinevirtual

RemoveDuplicates() [1/3]

virtual void Aspose::Cells::ICells::RemoveDuplicates ( )

pure virtual

Removes duplicate rows in the sheet.

RemoveDuplicates() [2/3]

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

Removes duplicate values in the range.

Parameters

startRow	The start row.
startColumn	The start column
endRow	The end row index.
endColumn	The end column index.

RemoveDuplicates() [3/3]

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, bool  hasHeaders, intrusive_ptr< Aspose::Cells::Systems::Array1D< Aspose::Cells::Systems::Int32 >>  columnOffsets  )

pure virtual

Removes duplicate data of the range.

Parameters

startRow	The start row.
startColumn	The start column
endRow	The end row index.
endColumn	The end column index.
hasHeaders	Indicates whether the range contains headers.
columnOffsets	The column offsets.

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 in normal view.

Parameters

column	Column index.
width	Width 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 in normal view.

Parameters

column	Column index.
inches	Number of inches.

SetColumnWidthPixel()

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

pure virtual

Sets column width in unit of pixels in normal view.

Parameters

column	Column index.
pixels	Number 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

row	Row index.
height	Height 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

row	Row index.
inches	Number 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

row	Row index.
pixels	Number 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.

SetStandardHeightInch()

virtual void Aspose::Cells::ICells::SetStandardHeightInch ( Aspose::Cells::Systems::Double  value )

pure virtual

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

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.

SetViewColumnWidthPixel()

virtual void Aspose::Cells::ICells::SetViewColumnWidthPixel ( Aspose::Cells::Systems::Int32  column, Aspose::Cells::Systems::Int32  pixels  )

pure virtual

Sets the width of the column in different view.

Parameters

column	The column index.
pixels	The width in unit of pixels.

If the current view type is ViewType.PageLayoutView , the column's width is same as printed width.

ShowGroupDetail()

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

pure virtual

Uncollapses the grouped rows/columns.

Parameters

isVertical	True, uncollapses the grouped rows.
index	The 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

ca	The range
groupBy	The field to group by, as a zero-based integer offset
function	The subtotal function.
totalList	An 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

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

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

row	The row index.
column	The column index.
totalRows	The number of rows.
options	The split options.

UngroupColumns()

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

pure virtual

Ungroups columns.

Parameters

firstIndex	The first column index to be ungrouped.
lastIndex	The 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

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

UngroupRows() [2/2]

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

pure virtual

Ungroups rows.

Parameters

firstIndex	The first row index to be ungrouped.
lastIndex	The last row index to be ungrouped.

Only removes outer 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

column	Column index.
width	Column width.

UnhideColumns()

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

pure virtual

Unhide multiple columns.

Parameters

column	Column index.
totalColumns	Column number
width	Column 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

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

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

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

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

firstRow	First row of this range(zero based)
firstColumn	First column of this range(zero based)
totalRows	Number of rows(one based)
totalColumns	Number of columns(one based)