Struct edit_xlsx::WorkSheet

pub struct WorkSheet { /* private fields */ }

Implementations

impl WorkSheet

pub fn autofilter<L: LocationRange>(&mut self, loc_range: L)

pub fn filter_column<L: Location>(&mut self, col: L, filters: &Filters<'_>)

impl WorkSheet

pub fn max_column(&self) -> u32

pub fn max_row(&self) -> u32

pub fn get_name(&self) -> &str

pub fn set_name(&mut self, name: &str) -> WorkSheetResult<()>

pub fn activate(&mut self)

pub fn select(&mut self)

pub fn deselect(&mut self)

pub fn right_to_left(&mut self)

pub fn set_top_left_cell<L: Location>(&mut self, loc: L)

pub fn set_zoom(&mut self, zoom_scale: u16)

pub fn set_selection<L: LocationRange>( &mut self, loc_range: L ) -> WorkSheetResult<()>

pub fn freeze_panes<L: Location>(&mut self, loc: L) -> WorkSheetResult<()>

pub fn split_panes(&mut self, width: f64, height: f64) -> WorkSheetResult<()>

pub fn set_default_row(&mut self, height: f64)

pub fn get_default_row(&self) -> f64

pub fn set_default_column(&mut self, height: f64)

pub fn get_default_column(&self) -> f64

pub fn hide_unused_rows(&mut self, hide: bool)

pub fn outline_settings( &mut self, visible: bool, symbols_below: bool, symbols_right: bool, auto_style: bool )

pub fn ignore_errors<L: Location>(&mut self, error_map: HashMap<&str, L>)

pub fn hide(&mut self)

pub fn set_tab_color(&mut self, tab_color: &FormatColor)

pub fn set_background<P: AsRef<Path>>( &mut self, filename: P ) -> WorkSheetResult<()>

pub fn insert_image<L: LocationRange, P: AsRef<Path>>( &mut self, loc_range: L, filename: &P ) -> WorkSheetResult<()>

pub fn id(&self) -> u32

Trait Implementations

impl Debug for WorkSheet

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

Formats the value using the given formatter.

impl Read for WorkSheet

fn read_cell<L: Location>(&self, loc: L) -> WorkSheetResult<Cell<String>>

impl WorkSheetCol for WorkSheet

fn get_columns<R: LocationRange>( &self, col_range: R ) -> WorkSheetResult<HashMap<String, Column>>

get methods

fn get_columns_with_format<R: LocationRange>( &self, col_range: R ) -> WorkSheetResult<HashMap<String, (Column, Option<Format>)>>

fn get_columns_width<R: LocationRange>( &self, col_range: R ) -> WorkSheetResult<HashMap<String, Option<f64>>>

fn set_columns<R: LocationRange>( &mut self, col_range: R, column: &Column ) -> WorkSheetResult<()>

set methods

fn set_columns_with_format<R: LocationRange>( &mut self, col_range: R, column: &Column, format: &Format ) -> WorkSheetResult<()>

fn set_columns_width<R: LocationRange>( &mut self, col_range: R, width: f64 ) -> WorkSheetResult<()>

set columns width and formats

fn set_columns_width_pixels<R: LocationRange>( &mut self, col_range: R, width: f64 ) -> WorkSheetResult<()>

fn set_columns_width_with_format<R: LocationRange>( &mut self, col_range: R, width: f64, format: &Format ) -> WorkSheetResult<()>

fn set_columns_width_pixels_with_format<R: LocationRange>( &mut self, col_range: R, width: f64, format: &Format ) -> WorkSheetResult<()>

fn hide_columns<R: LocationRange>( &mut self, col_range: R ) -> WorkSheetResult<()>

hide columns

fn set_columns_level<R: LocationRange>( &mut self, col_range: R, level: u32 ) -> WorkSheetResult<()>

collapse columns

fn collapse_columns<R: LocationRange>( &mut self, col_range: R ) -> WorkSheetResult<()>

impl WorkSheetRow for WorkSheet

fn get_row(&self, row: u32) -> WorkSheetResult<Row>

fn get_row_with_format( &self, row: u32 ) -> WorkSheetResult<(Row, Option<Format>)>

fn get_row_height(&self, row: u32) -> WorkSheetResult<Option<f64>>

fn set_row(&mut self, row_number: u32, row: &Row) -> WorkSheetResult<()>

set methods

fn set_row_with_format( &mut self, row_number: u32, row: &Row, format: &Format ) -> WorkSheetResult<()>

fn set_row_height(&mut self, row: u32, height: f64) -> WorkSheetResult<()>

set row height and format

fn set_row_height_pixels( &mut self, row: u32, height: f64 ) -> WorkSheetResult<()>

fn set_row_height_with_format( &mut self, row: u32, height: f64, format: &Format ) -> WorkSheetResult<()>

fn set_row_height_pixels_with_format( &mut self, row: u32, height: f64, format: &Format ) -> WorkSheetResult<()>

fn hide_row(&mut self, row: u32) -> WorkSheetResult<()>

hide row

fn set_row_level(&mut self, row: u32, level: u32) -> WorkSheetResult<()>

collapse rows

fn collapse_row(&mut self, row: u32) -> WorkSheetResult<()>

impl Write for WorkSheet

fn write_cell<L: Location, T: Clone + CellDisplay + CellValue>( &mut self, loc: L, cell: &Cell<T> ) -> WorkSheetResult<()>

fn write<L: Location, T: CellDisplay + CellValue>( &mut self, loc: L, data: T ) -> WorkSheetResult<()>

fn write_string<L: Location>( &mut self, loc: L, data: String ) -> WorkSheetResult<()>

fn write_number<L: Location>( &mut self, loc: L, data: i32 ) -> WorkSheetResult<()>

fn write_double<L: Location>( &mut self, loc: L, data: f64 ) -> WorkSheetResult<()>

fn write_boolean<L: Location>( &mut self, loc: L, data: bool ) -> WorkSheetResult<()>

fn write_row<L: Location, T: CellDisplay + CellValue>( &mut self, loc: L, data: &[T] ) -> WorkSheetResult<()>

fn write_row_cells<L: Location, T: CellDisplay + CellValue + Clone>( &mut self, loc: L, cells: &[Cell<T>] ) -> WorkSheetResult<()>

fn write_column<L: Location, T: CellDisplay + CellValue>( &mut self, loc: L, data: &[T] ) -> WorkSheetResult<()>

fn write_column_cells<L: Location, T: CellDisplay + CellValue + Clone>( &mut self, loc: L, cells: &[Cell<T>] ) -> WorkSheetResult<()>

fn write_url<L: Location>(&mut self, loc: L, url: &str) -> WorkSheetResult<()>

fn write_url_text<L: Location, T: CellDisplay + CellValue>( &mut self, loc: L, url: &str, data: &str ) -> WorkSheetResult<()>

fn merge_range<L: LocationRange, T: CellDisplay + CellValue>( &mut self, loc: L, data: T ) -> WorkSheetResult<()>

fn write_formula<L: Location>( &mut self, loc: L, data: &str ) -> WorkSheetResult<()>

fn write_old_formula<L: Location>( &mut self, loc: L, data: &str ) -> WorkSheetResult<()>

fn write_array_formula<L: Location>( &mut self, loc: L, data: &str ) -> WorkSheetResult<()>

fn write_dynamic_array_formula<L: Location>( &mut self, loc: L, data: &str ) -> WorkSheetResult<()>

fn write_with_format<L: Location, T: Default + Clone + CellDisplay + CellValue>( &mut self, loc: L, data: T, format: &Format ) -> WorkSheetResult<()>

fn write_string_with_format<L: Location>( &mut self, loc: L, data: String, format: &Format ) -> WorkSheetResult<()>

fn write_number_with_format<L: Location>( &mut self, loc: L, data: i32, format: &Format ) -> WorkSheetResult<()>

fn write_double_with_format<L: Location>( &mut self, loc: L, data: f64, format: &Format ) -> WorkSheetResult<()>

fn write_boolean_with_format<L: Location>( &mut self, loc: L, data: bool, format: &Format ) -> WorkSheetResult<()>

fn write_row_with_format<L: Location, T: CellDisplay + CellValue>( &mut self, loc: L, data: Iter<'_, T>, format: &Format ) -> WorkSheetResult<()>

fn write_column_with_format<L: Location, T: CellDisplay + CellValue>( &mut self, loc: L, data: Iter<'_, T>, format: &Format ) -> WorkSheetResult<()>

fn write_url_with_format<L: Location>( &mut self, loc: L, url: &str, format: &Format ) -> WorkSheetResult<()>

fn write_url_text_with_format<L: Location>( &mut self, loc: L, url: &str, data: &str, format: &Format ) -> WorkSheetResult<()>

fn write_formula_with_format<L: Location>( &mut self, loc: L, data: &str, format: &Format ) -> WorkSheetResult<()>

fn write_array_formula_with_format<L: Location>( &mut self, loc: L, data: &str, format: &Format ) -> WorkSheetResult<()>

fn write_dynamic_array_formula_with_format<L: LocationRange>( &mut self, loc_range: L, data: &str, format: &Format ) -> WorkSheetResult<()>

fn merge_range_with_format<L: LocationRange, T: CellDisplay + CellValue>( &mut self, loc: L, data: T, format: &Format ) -> WorkSheetResult<()>