Cells class

Cells class

Encapsulates a collection of cell relevant objects, such as Cell, Row, …etc.

The Cells type exposes the following members:

Properties

Property	Description
ods_cell_fields	Gets the list of fields of ods.
count	Gets the total count of instantiated Cell objects.
count_large	Gets the total count of instantiated Cell objects.
rows	Gets the collection of Row objects that represents the individual rows in this worksheet.
merged_cells	Gets the collection of merged cells.
multi_thread_reading	Gets or sets whether the cells data model should support Multi-Thread reading. Default value of this property is false.
memory_setting	Gets or sets the memory usage option for this cells.
style	Gets and sets the default style of the worksheet.
standard_width_inch	Gets or sets the default column width in the worksheet, in unit of inches.
standard_width_pixels	Gets or sets the default column width in the worksheet, in unit of pixels.
standard_width	Gets or sets the default column width in the worksheet, in unit of characters.
standard_height	Gets or sets the default row height in this worksheet, in unit of points.
standard_height_pixels	Gets or sets the default row height in this worksheet, in unit of pixels.
standard_height_inch	Gets or sets the default row height in this worksheet, in unit of inches.
preserve_string	Gets or sets a value indicating whether all worksheet values are preserved as strings. Default is false.
min_row	Minimum row index of cell which contains data or style.
max_row	Maximum row index of cell which contains data or style.
min_column	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).
max_column	Maximum 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).
min_data_row	Minimum row index of cell which contains data.
max_data_row	Maximum row index of cell which contains data.
min_data_column	Minimum column index of cell which contains data.
max_data_column	Maximum column index of cell which contains data.
is_default_row_height_matched	Indicates that row height and default font height matches
is_default_row_hidden	Indicates whether the row is default hidden.
columns	Gets the collection of Column objects that represents the individual columns in this worksheet.
ranges	Gets the collection of Range objects created at run time.
last_cell	Gets the last cell in this worksheet.
max_display_range	Gets the max range which includes data, merged cells and shapes.
first_cell	Gets the first cell in this worksheet.

Methods

Method	Description
create_range	Creates a Range object from a range of cells.
create_range	Creates a Range object from a range of cells.
create_range	Creates a Range object from an address of the range.
create_range	Creates a Range object from rows of cells or columns of cells.
get	Add API for Python Via .Net.since this[int row, int column] is unsupported
get	Add API for Python Via .Net.since this[string cellName] is unsupported
import_object_array	Imports an array of data into a worksheet.
import_object_array	Imports an array of data into a worksheet.
import_array	Imports an array of string into a worksheet.
import_array	Imports an array of integer into a worksheet.
import_array	Imports an array of double into a worksheet.
import_csv	Import a CSV file to the cells.
import_csv	Import a CSV file to the cells.
import_csv	Import a CSV file to the cells.
import_csv	Import a CSV file to the cells.
merge	Merges a specified range of cells into a single cell.
merge	Merges a specified range of cells into a single cell.
merge	Merges a specified range of cells into a single cell.
get_column_width_pixel	Gets the width of the specified column in normal view, in units of pixel.
get_column_width_pixel	Gets the width of the specified column in normal view, in units of pixel.
copy_columns	Copies data and formats of a whole column.
copy_columns	Copies data and formats of a whole column.
copy_columns	Copies data and formats of the whole columns.
copy_rows	Copies data and formats of some whole rows.
copy_rows	Copies data and formats of some whole rows.
copy_rows	Copies data and formats of some whole rows.
group_columns	Groups columns.
group_columns	Groups columns.
ungroup_rows	Ungroups rows.
ungroup_rows	Ungroups rows.
group_rows	Groups rows.
group_rows	Groups rows.
delete_column	Deletes a column.
delete_column	Deletes a column.
delete_row	Deletes a row.
delete_row	Deletes a row.
delete_rows	Deletes several rows.
delete_rows	Deletes multiple rows in the worksheet.
delete_blank_columns	Delete all blank columns which do not contain any data.
delete_blank_columns	Delete all blank columns which do not contain any data.
delete_blank_rows	Delete all blank rows which do not contain any data or other object.
delete_blank_rows	Delete all blank rows which do not contain any data or other object.
insert_columns	Inserts some columns into the worksheet.
insert_columns	Inserts some columns into the worksheet.
insert_column	Inserts a new column into the worksheet.
insert_column	Inserts a new column into the worksheet.
insert_rows	Inserts multiple rows into the worksheet.
insert_rows	Inserts multiple rows into the worksheet.
insert_rows	Inserts multiple rows into the worksheet.
clear_range	Clears contents and formatting of a range.
clear_range	Clears contents and formatting of a range.
clear_contents	Clears contents of a range.
clear_contents	Clears contents of a range.
clear_formats	Clears formatting of a range.
clear_formats	Clears formatting of a range.
find	Finds the cell containing with the input object.
find	Finds the cell containing with the input object.
end_cell_in_row	Gets the last cell in this row.
end_cell_in_row	Gets the last cell with maximum row index in this range.
end_cell_in_column	Gets the last cell in this column.
end_cell_in_column	Gets the last cell with maximum column index in this range.
insert_range	Inserts a range of cells and shift cells according to the shift option.
insert_range	Inserts a range of cells and shift cells according to the shift option.
insert_range	Inserts a range of cells and shift cells according to the shift option.
import_custom_objects	Imports custom objects.
import_custom_objects	Imports custom objects.
subtotal	Creates subtotals for the range.
subtotal	Creates subtotals for the range.
remove_duplicates	Removes duplicate rows in the sheet.
remove_duplicates	Removes duplicate values in the range.
remove_duplicates	Removes duplicate data of the range.
get_row_enumerator	Gets the rows enumerator.
get_merged_areas	Gets all merged cells.
get_cell	Gets the Cell element or null at the specified cell row index and column index.
get_row	Gets the Row element at the specified cell row index.
check_cell	Gets the Cell element or null at the specified cell row index and column index.
check_row	Gets the Row element or null at the specified cell row index.
check_column	Gets the Column element or null at the specified column index.
is_row_hidden	Checks whether a row at given index is hidden.
is_column_hidden	Checks whether a column at given index is hidden.
add_range	Adds a range object reference to cells
clear	Clears all data of the worksheet.
import_data	Import data from custom data table.
import_array_list	Imports an arraylist of data into a worksheet.
import_formula_array	Imports an array of formula into a worksheet.
text_to_columns	Splits the text in the column to columns.
un_merge	Unmerges a specified range of merged cells.
clear_merged_cells	Clears all merged ranges.
hide_row	Hides a row.
unhide_row	Unhides a row.
hide_rows	Hides multiple rows.
unhide_rows	Unhides the hidden rows.
set_row_height_pixel	Sets row height in unit of pixels.
set_row_height_inch	Sets row height in unit of inches.
set_row_height	Sets the height of the specified row.
get_row_original_height_point	Gets original row’s height in unit of point if the row is hidden
get_column_original_width_point	Gets original column’s height in unit of point if the column is hidden
hide_column	Hides a column.
unhide_column	Unhides a column
hide_columns	Hide multiple columns.
unhide_columns	Unhide multiple columns.
get_row_height	Gets the height of a specified row, in unit of points.
get_view_row_height	Gets the height of a specified row.
get_row_height_pixel	Gets the height of a specified row in unit of pixel.
get_row_height_inch	Gets the height of a specified row in unit of inches.
get_view_row_height_inch	Gets the height of a specified row in unit of inches.
set_column_width_pixel	Sets column width in unit of pixels in normal view.
set_column_width_inch	Sets column width in unit of inches in normal view.
set_column_width	Sets the width of the specified column in normal view.
get_column_width_inch	Gets the width of the specified column in normal view, in units of inches.
get_column_width	Gets the width(in unit of characters) of the specified column in normal view
get_view_column_width_pixel	Get the width in different view type.
set_view_column_width_pixel	Sets the width of the column in different view.
get_last_data_row	Gets the last row index of cell which contains data in the specified column.
apply_column_style	Applies formats for a whole column.
apply_row_style	Applies formats for a whole row.
apply_style	Applies formats for a whole worksheet.
copy_column	Copies data and formats of a whole column.
copy_row	Copies data and formats of a whole row.
get_grouped_row_outline_level	Gets the outline level (zero-based) of the row.
get_grouped_column_outline_level	Gets the outline level (zero-based) of the column.
get_max_grouped_column_outline_level	Gets the max grouped column outline level (zero-based).
get_max_grouped_row_outline_level	Gets the max grouped row outline level (zero-based).
show_group_detail	Expands the grouped rows/columns.
hide_group_detail	Collapses the grouped rows/columns.
ungroup_columns	Ungroups columns.
delete_columns	Deletes several columns.
is_deleting_range_enabled	Check whether the range could be deleted.
is_blank_column	Checks whether given column is blank(does not contain any data).
insert_row	Inserts a new row into the worksheet.
link_to_xml_map	Link to a xml map.
move_range	Moves the range.
insert_cut_cells	Insert cut range.
delete_range	Deletes a range of cells and shift cells according to the shift option.
retrieve_subtotal_setting	Retrieves subtotals setting of the range.
remove_formulas	Removes all formula and replaces with the value of the formula.
convert_string_to_numeric_value	Converts all string data in the worksheet to numeric value if possible.
get_dependents	Get all cells which refer to the specific cell.
get_dependents_in_calculation	Gets all cells whose calculated result depends on specific cell.
get_cell_style	Get the style of given cell.

Remarks

See Also

• module aspose.cells
• class Cell
• class Column
• class Range
• class Row