Cells Class
Contents
[
Hide
]Cells class
Encapsulates a collection of cell relevant objects, such as
type Cells struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| GetOdsCellFields | Gets the list of fields of ods. |
| Dispose | Performs application-defined tasks associated with freeing, releasing, orresetting unmanaged resources. |
| GetCount | Gets the total count of instantiated Cell objects. |
| GetCountLarge | Gets the total count of instantiated Cell objects. |
| GetEnumerator | Gets the cells enumerator. |
| GetRows | Gets the collection of Row objects that represents the individual rows in this worksheet. |
| GetMergedAreas | Gets all merged cells. |
| CheckCell | Gets the Cell element or null at the specified cell row index and column index. |
| CheckRow | Gets the Row element or null at the specified cell row index. |
| CheckColumn | Gets the Column element or null at the specified column index. |
| IsRowHidden | Checks whether a row at given index is hidden. |
| IsColumnHidden | Checks whether a column at given index is hidden. |
| AddRange | Adds a range object reference to cells |
| CreateRange_String_String | Creates a Range object from a range of cells. |
| CreateRange_Int_Int_Int_Int | Creates a Range object from a range of cells. |
| CreateRange_String | Creates a Range object from an address of the range. |
| CreateRange_Int_Int_Bool | Creates a Range object from rows of cells or columns of cells. |
| Get_Int_Int | Gets the Cell element at the specified cell row index and column index. |
| Get_String | Gets the Cell element at the specified cell name. |
| GetMultiThreadReading | Gets or sets whether the cells data model should support Multi-Thread reading.Default value of this property is false. |
| SetMultiThreadReading | Gets or sets whether the cells data model should support Multi-Thread reading.Default value of this property is false. |
| GetMemorySetting | Gets or sets the memory usage option for this cells. |
| SetMemorySetting | Gets or sets the memory usage option for this cells. |
| Clear | Clears all data of the worksheet. |
| GetStyle | Gets and sets the default style of the worksheet. |
| SetStyle | Gets and sets the default style of the worksheet. |
| IsDefaultColumnHidden | |
| SetIsDefaultColumnHidden | |
| GetStandardWidthInch | Gets or sets the default column width in the worksheet, in unit of inches. |
| SetStandardWidthInch | Gets or sets the default column width in the worksheet, in unit of inches. |
| GetStandardWidthPixels | Gets or sets the default column width in the worksheet, in unit of pixels. |
| SetStandardWidthPixels | Gets or sets the default column width in the worksheet, in unit of pixels. |
| GetStandardWidth | Gets or sets the default column width in the worksheet, in unit of characters. |
| SetStandardWidth | Gets or sets the default column width in the worksheet, in unit of characters. |
| GetStandardHeight | Gets or sets the default row height in this worksheet, in unit of points. |
| SetStandardHeight | Gets or sets the default row height in this worksheet, in unit of points. |
| GetStandardHeightPixels | Gets or sets the default row height in this worksheet, in unit of pixels. |
| SetStandardHeightPixels | Gets or sets the default row height in this worksheet, in unit of pixels. |
| GetStandardHeightInch | Gets or sets the default row height in this worksheet, in unit of inches. |
| SetStandardHeightInch | Gets or sets the default row height in this worksheet, in unit of inches. |
| ImportFormulaArray | Imports an array of formula into a worksheet. |
| TextToColumns | Splits content in specified column into multiple columns.. |
| ImportCSV_String_String_Bool_Int_Int | Import a CSV file to the cells. |
| ImportCSV_Stream_String_Bool_Int_Int | Import a CSV file to the cells. |
| ImportCSV_String_TxtLoadOptions_Int_Int | Import a CSV file to the cells. |
| ImportCSV_Stream_TxtLoadOptions_Int_Int | Import a CSV file to the cells. |
| GetPreserveString | Gets or sets a value indicating whether all worksheet values are preserved as strings.Default is false. |
| SetPreserveString | Gets or sets a value indicating whether all worksheet values are preserved as strings.Default is false. |
| Merge_Int_Int_Int_Int | Merges a specified range of cells into a single cell. |
| Merge_Int_Int_Int_Int_Bool | Merges a specified range of cells into a single cell. |
| Merge_Int_Int_Int_Int_Bool_Bool | Merges a specified range of cells into a single cell. |
| UnMerge | Unmerges a specified range of merged cells. |
| ClearMergedCells | Clears all merged ranges. |
| HideRow | Hides a row. |
| UnhideRow | Unhides a row. |
| HideRows | Hides multiple rows. |
| UnhideRows | Unhides the hidden rows. |
| SetRowHeightPixel | Sets row height in unit of pixels. |
| SetRowHeightInch | Sets row height in unit of inches. |
| SetRowHeight | Sets the height of the specified row. |
| GetRowHeight_Int_Bool_CellsUnitType | Gets row’s height. |
| GetColumnWidth_Int_Bool_CellsUnitType | Gets the column width. |
| HideColumn | Hides a column. |
| UnhideColumn | Unhides a column |
| HideColumns | Hide multiple columns. |
| UnhideColumns | Unhide multiple columns. |
| GetRowHeight_Int | Gets the height of a specified row, in unit of points. |
| GetViewRowHeight | Gets the height of a specified row. |
| GetRowHeightInch | Gets the height of a specified row in unit of inches. |
| GetViewRowHeightInch | Gets the height of a specified row in unit of inches. |
| GetRowHeightPixel | Gets the height of a specified row in unit of pixel. |
| SetColumnWidthPixel | Sets column width in unit of pixels in normal view. |
| SetColumnWidthInch | Sets column width in unit of inches in normal view. |
| SetColumnWidth | Sets the width of the specified column in normal view. |
| GetColumnWidthPixel | Gets the width of the specified column in normal view, in units of pixel. |
| GetColumnWidth_Int | Gets the width(in unit of characters) of the specified column in normal view |
| GetViewColumnWidthPixel | Get the width in different view type. |
| SetViewColumnWidthPixel | Sets the width of the column in different view. |
| GetMinRow | Minimum row index of cell which contains data or style. |
| GetMaxRow | Maximum row index of cell which contains data or style. |
| GetMinColumn | Minimum column index of those cells that have been instantiated in the collection(does not include the columnwhere style is defined for the whole column but no cell has been instantiated in it). |
| GetMaxColumn | Maximum column index of those cells that have been instantiated in the collection(does not include the columnwhere style is defined for the whole column but no cell has been instantiated in it). |
| GetMinDataRow | Minimum row index of cell which contains data. |
| GetMaxDataRow | Maximum row index of cell which contains data. |
| GetMinDataColumn | Minimum column index of cell which contains data. |
| GetMaxDataColumn | Maximum column index of cell which contains data. |
| GetLastDataRow | Gets the last row index of cell which contains data in the specified column. |
| GetFirstDataRow | Gets the first row index of cell which contains data in the specified column. |
| IsDefaultRowHeightMatched | Indicates that row height and default font height matches |
| SetIsDefaultRowHeightMatched | Indicates that row height and default font height matches |
| IsDefaultRowHidden | Indicates whether the row is default hidden. |
| SetIsDefaultRowHidden | Indicates whether the row is default hidden. |
| GetColumns | Gets the collection of Column objects that represents the individual columns in this worksheet. |
| ApplyColumnStyle | Applies formats for a whole column. |
| ApplyRowStyle | Applies formats for a whole row. |
| ApplyStyle | Applies formats for a whole worksheet. |
| CopyColumns_Cells_Int_Int_Int_PasteOptions | Copies data and formats of a whole column. |
| CopyColumn | Copies data and formats of a whole column. |
| CopyColumns_Cells_Int_Int_Int | Copies data and formats of a whole column. |
| CopyColumns_Cells_Int_Int_Int_Int | Copies data and formats of the whole columns. |
| CopyRow | Copies data and formats of a whole row. |
| CopyRows_Cells_Int_Int_Int | Copies data and formats of some whole rows. |
| CopyRows_Cells_Int_Int_Int_CopyOptions | Copies data and formats of some whole rows. |
| CopyRows_Cells_Int_Int_Int_CopyOptions_PasteOptions | Copies data and formats of some whole rows. |
| GetGroupedRowOutlineLevel | Gets the outline level (zero-based) of the row. |
| GetGroupedColumnOutlineLevel | Gets the outline level (zero-based) of the column. |
| GetMaxGroupedColumnOutlineLevel | Gets the max grouped column outline level (zero-based). |
| GetMaxGroupedRowOutlineLevel | Gets the max grouped row outline level (zero-based). |
| ShowGroupDetail | Expands the grouped rows/columns. |
| HideGroupDetail | Collapses the grouped rows/columns. |
| UngroupColumns | Ungroups columns. |
| GroupColumns_Int_Int | Groups columns. |
| GroupColumns_Int_Int_Bool | Groups columns. |
| UngroupRows_Int_Int_Bool | Ungroups rows. |
| UngroupRows_Int_Int | Ungroups rows. |
| GroupRows_Int_Int_Bool | Groups rows. |
| GroupRows_Int_Int | Groups rows. |
| DeleteColumn_Int_Bool | Deletes a column. |
| DeleteColumn_Int | Deletes a column. |
| DeleteColumns_Int_Int_Bool | Deletes several columns. |
| DeleteColumns_Int_Int_DeleteOptions | Deletes several columns. |
| IsDeletingRangeEnabled | Check whether the range could be deleted. |
| DeleteRow_Int | Deletes a row. |
| DeleteRow_Int_Bool | Deletes a row. |
| DeleteRows_Int_Int | Deletes multiple rows. |
| DeleteRows_Int_Int_Bool | Deletes multiple rows in the worksheet. |
| DeleteRows_Int_Int_DeleteOptions | Deletes multiple rows in the worksheet. |
| DeleteBlankColumns | Delete all blank columns which do not contain any data. |
| DeleteBlankColumns_DeleteOptions | Delete all blank columns which do not contain any data. |
| IsBlankColumn | Checks whether given column is blank(does not contain any data). |
| DeleteBlankRows | Delete all blank rows which do not contain any data or other object. |
| DeleteBlankRows_DeleteOptions | Delete all blank rows which do not contain any data or some special objects such as visible comment, pivot table. |
| InsertColumns_Int_Int | Inserts some columns into the worksheet. |
| InsertColumns_Int_Int_Bool | Inserts some columns into the worksheet. |
| InsertColumns_Int_Int_InsertOptions | Inserts some columns into the worksheet. |
| InsertColumn_Int_Bool | Inserts a new column into the worksheet. |
| InsertColumn_Int | Inserts a new column into the worksheet. |
| InsertRows_Int_Int_Bool | Inserts multiple rows into the worksheet. |
| InsertRows_Int_Int_InsertOptions | Inserts multiple rows into the worksheet. |
| InsertRows_Int_Int | Inserts multiple rows into the worksheet. |
| InsertRow | Inserts a new row into the worksheet. |
| GetRanges | Gets the collection of Range objects created at run time. |
| ClearRange_CellArea | Clears contents and formatting of a range. |
| ClearRange_Int_Int_Int_Int | Clears contents and formatting of a range. |
| ClearContents_CellArea | Clears contents of a range. |
| ClearContents_Int_Int_Int_Int | Clears contents of a range. |
| ClearFormats_CellArea | Clears formatting of a range. |
| ClearFormats_Int_Int_Int_Int | Clears formatting of a range. |
| GetLastCell | Gets the last cell in this worksheet. |
| LinkToXmlMap | Link to a xml map. |
| GetMaxDisplayRange | Gets the max range which includes data, merged cells and shapes. |
| GetFirstCell | Gets the first cell in this worksheet. |
| Find_Object_Cell | Finds the cell containing with the input object. |
| Find_Object_Cell_FindOptions | Finds the cell containing with the input object. |
| EndCellInRow_Int | Gets the last cell in this row. |
| EndCellInColumn_Int | Gets the last cell in this column. |
| EndCellInColumn_Int_Int_Int_Int | Gets the last cell with maximum column index in this range. |
| EndCellInRow_Int_Int_Int_Int | Gets the last cell with maximum row index in this range. |
| MoveRange | Moves the range. |
| InsertCutCells | Insert cut range. |
| InsertRange_CellArea_Int_ShiftType_Bool | Inserts a range of cells and shift cells according to the shift option. |
| InsertRange_CellArea_ShiftType | Inserts a range of cells and shift cells according to the shift option. |
| InsertRange_CellArea_Int_ShiftType | Inserts a range of cells and shift cells according to the shift option. |
| DeleteRange | Deletes a range of cells and shift cells according to the shift option. |
| ExportArray | Exports data in the Cells collection to a two-dimension array object. |
| RetrieveSubtotalSetting | Retrieves subtotals setting of the range. |
| Subtotal_CellArea_Int_ConsolidationFunction_int32Array | Creates subtotals for the range. |
| Subtotal_CellArea_Int_ConsolidationFunction_int32Array_Bool_Bool_Bool | Creates subtotals for the range. |
| RemoveFormulas | Removes all formula and replaces with the value of the formula. |
| RemoveDuplicates | Removes duplicate rows in the sheet. |
| RemoveDuplicates_Int_Int_Int_Int | Removes duplicate values in the range. |
| RemoveDuplicates_Int_Int_Int_Int_Bool_int32Array | Removes duplicate data of the range. |
| ConvertStringToNumericValue | Converts all string data in the worksheet to numeric value if possible. |
| GetDependents | Get all cells which refer to the specific cell. |
| GetDependentsInCalculation | Gets all cells whose calculated result depends on specific cell. |
| GetCellsWithPlaceInCellPicture | Gets all cells that contain embedded picture. |
| GetCellStyle | Get the style of given cell. |
| GetCellDisplayStyle_Int_Int | Get the display style of given cell. |
| GetCellDisplayStyle_Int_Int_BorderType | Get the display style of given cell. |