Struct ExcelTable 

pub struct ExcelTable {
    pub id: u64,
    pub name: String,
    pub sheet_id: u64,
    pub start_row: usize,
    pub start_col: usize,
    pub end_row: usize,
    pub end_col: usize,
    pub has_header_row: bool,
    pub has_totals_row: bool,
    pub columns: Vec<String>,
    pub style_name: Option<String>,
    pub has_insert_row: bool,
}

Mirrors an Excel Table (a.k.a. ListObject)

Fields

id: u64

Workbook-unique identifier

name: String

The table’s name, as a structured reference spells it. Unique workbook-wide and matched case-insensitively.

sheet_id: u64

The sheet this table occupies part of.

start_row: usize

Topmost row of the range, 0-based – the header row when there is one.

start_col: usize

Leftmost column of the range, 0-based.

end_row: usize

Bottommost row of the range, 0-based and inclusive – the totals row when there is one.

end_col: usize

Rightmost column of the range, 0-based and inclusive.

has_header_row: bool

Whether the first row is a header rather than data.

has_totals_row: bool

Whether the last row is a totals row rather than data.

columns: Vec<String>

Column names, in sheet-column order

style_name: Option<String>

Visual style theme name (e.g. “TableStyleMedium9”, “TableStyleLight1”, or custom theme)

has_insert_row: bool

Whether the last row of the range is Excel’s insert row placeholder, i.e. the table has zero data rows.

Implementations

impl ExcelTable

pub fn set_style_name(&mut self, style_name: Option<String>)

Sets the table’s visual style, or clears it with None.

pub fn row_count(&self) -> usize

Total rows in the range, header and totals rows included.

pub fn col_count(&self) -> usize

Columns in the range.

pub fn data_start_row(&self) -> usize

First row of the table’s actual data body (excludes the header row).

pub fn data_end_row(&self) -> usize

Last row of the table’s actual data body, excluding the totals row and Excel’s insert-row placeholder.

pub fn data_row_count(&self) -> usize

How many data rows the table actually has, which is 0 for a table sitting on its insert-row placeholder.

pub fn header_row(&self) -> Option<usize>

The header row’s sheet-row index, or None if the table has no header.

pub fn totals_row(&self) -> Option<usize>

The totals row’s sheet-row index, or None if the table has no totals row.

pub fn local_column_index(&self, name: &str) -> Option<usize>

Index (0-based, relative to the table’s own columns) of the column with the given name, matched case-insensitively

pub fn overlaps( &self, start_row: usize, start_col: usize, end_row: usize, end_col: usize, ) -> bool

Whether this table’s range overlaps the given rectangular range.

Trait Implementations

impl Clone for ExcelTable

fn clone(&self) -> Self

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for ExcelTable

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for ExcelTable

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for ExcelTable

fn eq(&self, other: &Self) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl Serialize for ExcelTable

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for ExcelTable