ListObject

Overview

ListObject is a struct in Aspose.Cells FOSS for Rust.

Represents an Excel table (structured reference / ListObject).

This struct provides 48 methods for working with ListObject objects in Rust programs. Available methods include: comment, convert_to_range, data_range, display_name, end_column, end_row, get_comment, get_data_range, get_display_name, get_end_column, get_end_row, get_list_columns, and 36 additional methods. All public members are accessible to any Rust application after installing the Aspose.Cells FOSS for Rust package.

Methods

SignatureDescription
display_name()&strGets the user-visible table name.
get_display_name()&strGets the user-visible table name.
set_display_name(value: impl Into<String>)Result<(), CellsError>Sets the user-visible table name.
comment()&strGets an optional comment for the table.
get_comment()&strGets an optional comment for the table.
set_comment(value: impl Into<String>)Sets an optional comment for the table.
start_row()u32Gets the zero-based row index of the first row.
get_start_row()u32Gets the zero-based row index of the first row.
start_column()u32Gets the zero-based column index of the first column.
get_start_column()u32Gets the zero-based column index of the first column.
end_row()u32Gets the zero-based row index of the last row.
get_end_row()u32Gets the zero-based row index of the last row.
end_column()u32Gets the zero-based column index of the last column.
get_end_column()u32Gets the zero-based column index of the last column.
data_range()StringGets the table range in A1 notation.
get_data_range()StringGets the table range in A1 notation.
show_header_row()boolGets whether the first row of the table range is a header row.
get_show_header_row()boolGets whether the first row of the table range is a header row.
set_show_header_row(value: bool)Sets whether the first row of the table range is a header row.
show_totals()boolGets whether the last row of the table range is a totals row.
get_show_totals()boolGets whether the last row of the table range is a totals row.
set_show_totals(value: bool)Sets whether the last row of the table range is a totals row.
show_auto_filter_enabled()boolGets whether the header row shows auto-filter drop-down buttons.
get_show_auto_filter()boolGets whether the header row shows auto-filter drop-down buttons.
show_auto_filter()Shows the auto-filter drop-down buttons on the table header row.
remove_auto_filter()Hides the auto-filter drop-down buttons from the table header row.
table_style_type()TableStyleTypeGets the built-in table style type.
get_table_style_type()TableStyleTypeGets the built-in table style type.
set_table_style_type(value: TableStyleType)Sets the built-in table style type.
table_style_name()&strGets the raw table style name stored in SpreadsheetML.
get_table_style_name()&strGets the raw table style name stored in SpreadsheetML.
set_table_style_name(value: impl Into<String>)Sets the raw table style name stored in SpreadsheetML.
show_table_style_first_column()boolGets whether the first column receives highlight formatting.
get_show_table_style_first_column()boolGets whether the first column receives highlight formatting.
set_show_table_style_first_column(value: bool)Sets whether the first column receives highlight formatting.
show_table_style_last_column()boolGets whether the last column receives highlight formatting.
get_show_table_style_last_column()boolGets whether the last column receives highlight formatting.
set_show_table_style_last_column(value: bool)Sets whether the last column receives highlight formatting.
show_table_style_row_stripes()boolGets whether alternating row stripes are shown.
get_show_table_style_row_stripes()boolGets whether alternating row stripes are shown.
set_show_table_style_row_stripes(value: bool)Sets whether alternating row stripes are shown.
show_table_style_column_stripes()boolGets whether alternating column stripes are shown.
get_show_table_style_column_stripes()boolGets whether alternating column stripes are shown.
set_show_table_style_column_stripes(value: bool)Sets whether alternating column stripes are shown.
list_columns()ListColumnCollection<'_>Gets the collection of columns in this table.
get_list_columns()ListColumnCollection<'_>Gets the collection of columns in this table.
resize(start_row: i32, start_column: i32, end_row: i32, end_column: i32, has_headers: bool)Result<(), CellsError>Resizes the table to the specified range.
convert_to_range()Removes the table structure, leaving the cell data in place.

See Also