Struct Worksheet 

pub struct Worksheet { /* private fields */ }

A Worksheet Object.

Implementations

impl Worksheet

pub fn get_value<T>(&self, coordinate: T) -> String

where T: Into<CellCoordinates>,

Get value.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• String - Value of the specified cell.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(&0).unwrap();
let value = worksheet.get_value("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let value = worksheet.get_value((1, 1));

pub fn get_value_number<T>(&self, coordinate: T) -> Option<f64>

where T: Into<CellCoordinates>,

Get value number.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1)

Return value

• Option<f64> - Value of the specified cell.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(&0).unwrap();
let value = worksheet.get_value_number("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let value = worksheet.get_value_number((1, 1));

pub fn get_formatted_value<T>(&self, coordinate: T) -> String

where T: Into<CellCoordinates>,

Get formatted value.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• String - Formatted value of the specified cell.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(&0).unwrap();
let value = worksheet.get_formatted_value("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let value = worksheet.get_formatted_value((1, 1));

pub fn get_cell_collection(&self) -> Vec<&Cell>

Get Cell List.

pub fn get_cell_collection_sorted(&self) -> Vec<&Cell>

pub fn get_cell_collection_mut(&mut self) -> Vec<&mut Cell>

Get Cell List in mutable.

pub fn get_collection_to_hashmap(&self) -> &HashMap<(u32, u32), Box<Cell>>

pub fn get_collection_to_hashmap_mut( &mut self, ) -> &mut HashMap<(u32, u32), Box<Cell>>

pub fn get_cell<T>(&self, coordinate: T) -> Option<&Cell>

where T: Into<CellCoordinates>,

Get cell.

Note

Cells with unset Value and Style will return None.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• Option - Cell in the Some.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(&0).unwrap();
let cell = worksheet.get_cell("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let cell = worksheet.get_cell((1, 1));

pub fn get_cell_mut<T>(&mut self, coordinate: T) -> &mut Cell

where T: Into<CellCoordinates>,

Get cell with mutable.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• &mut Cell - Cell with mutable.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
let cell = worksheet.get_cell_mut("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let cell = worksheet.get_cell_mut((1, 1));

pub fn get_collection_by_column(&self, column_num: &u32) -> Vec<&Cell>

pub fn get_collection_by_row(&self, row_num: &u32) -> Vec<&Cell>

pub fn get_collection_by_column_to_hashmap( &self, column_num: &u32, ) -> HashMap<u32, &Cell>

pub fn get_collection_by_row_to_hashmap( &self, row_num: &u32, ) -> HashMap<u32, &Cell>

pub fn set_cell(&mut self, cell: Cell) -> &mut Self

Set Cell

Arguments

• cell - Cell

pub fn remove_cell<T>(&mut self, coordinate: T) -> bool

where T: Into<CellCoordinates>,

Remove Cell

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Examples

worksheet.remove_cell("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
worksheet.remove_cell((1, 1));

pub fn get_cell_value<T>(&self, coordinate: T) -> &CellValue

where T: Into<CellCoordinates>,

Get cell value.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• &CellValue - CellValue.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(&0).unwrap();
let cell_value = worksheet.get_cell_value("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let cell_value = worksheet.get_cell_value((1, 1));

pub fn get_cell_value_mut<T>(&mut self, coordinate: T) -> &mut CellValue

where T: Into<CellCoordinates>,

Get cell value with mutable.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• &mut CellValue - CellValue with mutable.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
let cell_value = worksheet.get_cell_value_mut("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let cell_value = worksheet.get_cell_value_mut((1, 1));

pub fn get_cell_value_by_range(&self, range: &str) -> Vec<&CellValue>

Gets the cell value by specifying an range.

Arguments

• range - range. ex) “A1:C5”

Return value

*Vec<&CellValue> - CellValue List.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
let mut cell_value_List = worksheet.get_cell_value_by_range("A1:C5");

pub fn get_style<T>(&self, coordinate: T) -> &Style

where T: Into<CellCoordinates>,

Get style.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• &Style - Style.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(&0).unwrap();
let style = worksheet.get_style("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let style = worksheet.get_style((1, 1));

pub fn get_style_mut<T>(&mut self, coordinate: T) -> &mut Style

where T: Into<CellCoordinates>,

Get style with mutable.

Arguments

• coordinate - Specify the coordinates. ex) "A1" or (1, 1) or (&1, &1)

Return value

• &mut Style - Style with mutable.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
let style = worksheet.get_style_mut("A1");
// or pass in a tuple `(col, row)`, both col and row starting at `1`
let style = worksheet.get_style_mut((1, 1));

pub fn set_style<T>(&mut self, coordinate: T, style: Style) -> &mut Self

where T: Into<CellCoordinates>,

pub fn set_style_by_range(&mut self, range: &str, style: Style) -> &mut Self

Set style by range.

Arguments

• range - Specify the range. ex) “A1:B2”
• style - Style

Return value

• &mut Self - Self.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
let mut style = umya_spreadsheet::Style::default();
style.get_borders_mut().get_bottom_mut().set_border_style(umya_spreadsheet::Border::BORDER_MEDIUM);
worksheet.set_style_by_range("A1:A3", style);

pub fn map_merged_cell<T>(&self, coordinate: T) -> (u32, u32)

where T: Into<CellCoordinates>,

Get the upper-left corner cell of a cell inside a merged cell range (if any).

pub fn get_comments(&self) -> &[Comment]

Get Comments

pub fn get_comments_mut(&mut self) -> &mut ThinVec<Comment>

Get Comments in mutable.

pub fn get_comments_to_hashmap(&self) -> HashMap<String, &Comment>

Get Comments convert to hashmap.

pub fn set_comments(&mut self, value: impl Into<ThinVec<Comment>>)

Set Comments.

Arguments

• value - Comment List (Vec)

pub fn add_comments(&mut self, value: Comment)

Add Comments.

Arguments

• value - Comment

pub fn has_comments(&self) -> bool

Has Comments.

pub fn get_threaded_comments(&self) -> &[ThreadedComment]

Get ThreadedComments

pub fn get_threaded_comments_mut(&mut self) -> &mut ThinVec<ThreadedComment>

Get ThreadedComments in mutable.

pub fn get_threaded_comments_to_hashmap( &self, ) -> HashMap<String, &ThreadedComment>

Get ThreadedComments convert to hashmap.

pub fn set_threaded_comments( &mut self, value: impl Into<ThinVec<ThreadedComment>>, )

Set ThreadedComment.

Arguments

• value - ThreadedComment List (Vec)

pub fn add_threaded_comments(&mut self, value: ThreadedComment)

Add ThreadedComment.

Arguments

• value - ThreadedComment

pub fn has_threaded_comments(&self) -> bool

Has ThreadedComments.

pub fn get_conditional_formatting_collection(&self) -> &[ConditionalFormatting]

Get ConditionalFormatting list.

pub fn set_conditional_formatting_collection( &mut self, value: impl Into<ThinVec<ConditionalFormatting>>, )

Set ConditionalFormatting.

Arguments

• value - ConditionalSet List (Vec)

pub fn add_conditional_formatting_collection( &mut self, value: ConditionalFormatting, )

Add ConditionalFormatting.

Arguments

• value - ConditionalFormatting

pub fn get_merge_cells(&self) -> &[Range]

pub fn get_merge_cells_mut(&mut self) -> &mut ThinVec<Range>

pub fn add_merge_cells<S: Into<String>>(&mut self, range: S) -> &mut Self

Arguments

• range - Range. ex) “A1:C5”

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.add_merge_cells("A1:C5");

pub fn get_auto_filter(&self) -> Option<&AutoFilter>

pub fn get_auto_filter_mut(&mut self) -> Option<&mut AutoFilter>

pub fn set_auto_filter<S: Into<String>>(&mut self, range: S)

Arguments

• range - Range. ex) “A2:K2”

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.set_auto_filter("A2:K2");

pub fn remove_auto_filter(&mut self)

pub fn get_column_dimensions(&self) -> &[Column]

Get Column Dimension List.

pub fn get_column_dimensions_mut(&mut self) -> &mut ThinVec<Column>

Get Column Dimension List in mutable.

pub fn calculation_auto_width(&mut self) -> &mut Self

Calculation Auto Width.

pub fn get_column_dimension(&self, column: &str) -> Option<&Column>

Get Column Dimension.

Arguments

• column - Column Char. ex) “A”

pub fn get_column_dimension_mut(&mut self, column: &str) -> &mut Column

Get Column Dimension in mutable.

Arguments

• column - Column Char. ex) “A”

pub fn get_column_dimension_by_number(&self, col: &u32) -> Option<&Column>

Get Column Dimension.

Arguments

• col - Column Number.

pub fn get_column_dimension_by_number_mut(&mut self, col: &u32) -> &mut Column

Get Column Dimension in mutable.

Arguments

• col - Column Number.

pub fn has_sheet_data(&self) -> bool

pub fn get_row_dimensions(&self) -> Vec<&Row>

Get Row Dimension List.

pub fn get_row_dimensions_mut(&mut self) -> Vec<&mut Row>

Get Row Dimension List in mutable.

pub fn get_row_dimensions_to_hashmap(&self) -> &HashMap<u32, Box<Row>>

Get Row Dimension convert Hashmap.

pub fn get_row_dimensions_to_hashmap_mut( &mut self, ) -> &mut HashMap<u32, Box<Row>>

pub fn get_row_dimension(&self, row: &u32) -> Option<&Row>

Get Row Dimension.

pub fn get_row_dimension_mut(&mut self, row: &u32) -> &mut Row

Get Row Dimension in mutable.

pub fn get_worksheet_drawing(&self) -> &WorksheetDrawing

Get WorksheetDrawing.

pub fn get_worksheet_drawing_mut(&mut self) -> &mut WorksheetDrawing

Get WorksheetDrawing in mutable.

pub fn set_worksheet_drawing(&mut self, value: WorksheetDrawing)

Set WorksheetDrawing.

Arguments

• value - WorksheetDrawing

pub fn has_drawing_object(&self) -> bool

Has WorksheetDrawing.

pub fn insert_new_row(&mut self, row_index: &u32, num_rows: &u32)

Insert new rows.

Arguments

• row_index - Specify point of insert. ex) 1
• num_rows - Specify number to insert. ex) 2

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.insert_new_row(&2, &3);

pub fn insert_new_row_from_other_sheet( &mut self, sheet_name: &str, row_index: &u32, num_rows: &u32, )

Adjust for references to other sheets.

pub fn insert_new_column(&mut self, column: &str, num_columns: &u32)

Insert new columns.

Arguments

• column - Specify point of insert. ex) “B”
• num_columns - Specify number to insert. ex) 3

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.insert_new_column("B", &3);

pub fn insert_new_column_from_other_sheet( &mut self, sheet_name: &str, column: &str, num_columns: &u32, )

Adjust for references to other sheets.

pub fn insert_new_column_by_index( &mut self, column_index: &u32, num_columns: &u32, )

Insert new columns.

Arguments

• column_index - Specify point of insert. ex) 2
• num_columns - Specify number to insert. ex) 3

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.insert_new_column_by_index(&2, &3);

pub fn insert_new_column_by_index_from_other_sheet( &mut self, sheet_name: &str, column_index: &u32, num_columns: &u32, )

Adjust for references to other sheets.

pub fn remove_row(&mut self, row_index: &u32, num_rows: &u32)

Remove rows.

Arguments

• row_index - Specify point of remove. ex) 1
• num_rows - Specify number to remove. ex) 2

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.remove_row(&2, &3);

pub fn remove_row_from_other_sheet( &mut self, sheet_name: &str, row_index: &u32, num_rows: &u32, )

Adjust for references to other sheets.

pub fn remove_column(&mut self, column: &str, num_columns: &u32)

Remove columns.

Arguments

• sheet_name - Specify the sheet name. ex) “Sheet1”
• column - Specify point of remove. ex) “B”
• num_columns - Specify number to remove. ex) 3

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.remove_column("B", &3);

pub fn remove_column_from_other_sheet( &mut self, sheet_name: &str, column: &str, num_columns: &u32, )

Adjust for references to other sheets.

pub fn remove_column_by_index(&mut self, column_index: &u32, num_columns: &u32)

Remove columns.

Arguments

• column_index - Specify point of remove. ex) 2
• num_columns - Specify number to remove. ex) 3

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(&0).unwrap();
worksheet.remove_column_by_index(&2, &3);

pub fn remove_column_by_index_from_other_sheet( &mut self, sheet_name: &str, column_index: &u32, num_columns: &u32, )

Adjust for references to other sheets.

pub fn get_code_name(&self) -> Option<&str>

Get Code Name.

pub fn set_code_name<S: Into<String>>(&mut self, value: S)

Set Code Name.

Arguments

• value - Code Name

pub fn get_header_footer(&self) -> &HeaderFooter

Get Header Footer.

pub fn get_header_footer_mut(&mut self) -> &mut HeaderFooter

Get Header Footer in mutable.

pub fn set_header_footer(&mut self, value: HeaderFooter) -> &mut Self

Set Header Footer.

Arguments

• value - Header Footer

pub fn get_active_cell(&self) -> &str

Get Active Cell.

pub fn set_active_cell<S: Into<String>>(&mut self, cell: S)

Set Active Cell.

Arguments

• cell - Cell ex) “A1”

pub fn get_sheet_id(&self) -> &str

Get Sheet Id.

pub fn has_code_name(&self) -> bool

Has Code Name.

pub fn get_tab_color(&self) -> Option<&Color>

Get Tab Color.

pub fn get_tab_color_mut(&mut self) -> &mut Color

Get Tab Color in mutable.

pub fn set_tab_color(&mut self, value: Color) -> &mut Self

Set Tab Color.

Arguments

• value - Color

pub fn remove_tab_color(&mut self) -> &mut Self

Remove Tab Color.

pub fn calculate_worksheet_dimension(&self) -> String

Calculate Worksheet Dimension.

pub fn get_highest_column_and_row(&self) -> (u32, u32)

Return value

*(u32, u32) - (column, row)

pub fn get_highest_column(&self) -> u32

pub fn get_highest_row(&self) -> u32

pub fn get_name(&self) -> &str

Get SheetName.

pub fn set_name<S: Into<String>>(&mut self, sheet_name: S) -> &mut Self

Set SheetName.

Arguments

• sheet_name - Sheet Name. [Caution] no duplicate other worksheet.

pub fn get_state(&self) -> &SheetStateValues

pub fn set_state(&mut self, value: SheetStateValues) -> &mut Self

pub fn get_sheet_state(&self) -> &str

pub fn set_sheet_state(&mut self, value: String) -> &mut Self

Set Sheet State.

Arguments

• value - Sheet State.

pub fn get_page_setup(&self) -> &PageSetup

pub fn get_page_setup_mut(&mut self) -> &mut PageSetup

pub fn set_page_setup(&mut self, value: PageSetup) -> &mut Self

Set Page Setup.

Arguments

• value - PageSetup.

pub fn get_page_margins(&self) -> &PageMargins

pub fn get_page_margins_mut(&mut self) -> &mut PageMargins

pub fn set_page_margins(&mut self, value: PageMargins) -> &mut Self

Set Page Margins.

Arguments

• value - PageMargins.

pub fn get_sheets_views(&self) -> &SheetViews

pub fn get_sheet_views_mut(&mut self) -> &mut SheetViews

pub fn set_sheets_views(&mut self, value: SheetViews) -> &mut Self

Set SheetViews.

Arguments

• value - SheetViews.

pub fn get_ole_objects(&self) -> &OleObjects

pub fn get_ole_objects_mut(&mut self) -> &mut OleObjects

pub fn set_ole_objects(&mut self, value: OleObjects) -> &mut Self

Set Ole Objects.

Arguments

• value - OleObjects.

pub fn get_defined_names(&self) -> &[DefinedName]

Get Defined Name (Vec).

pub fn get_defined_names_mut(&mut self) -> &mut ThinVec<DefinedName>

Get Defined Name (Vec) in mutable.

pub fn set_defined_names(&mut self, value: impl Into<ThinVec<DefinedName>>)

Set Defined Name (Vec).

Arguments

• value - Vec.

pub fn add_defined_names(&mut self, value: DefinedName)

Add Defined Name.

Arguments

• value - DefinedName.

pub fn add_defined_name<S: Into<String>>( &mut self, name: S, address: S, ) -> Result<(), &str>

Add Defined Name.

Arguments

• name - Name. ex) “DefinedName01”
• address - Address. ex) “A1:A2”

pub fn get_print_options(&self) -> &PrintOptions

Get Print Options.

pub fn get_print_options_mut(&mut self) -> &mut PrintOptions

Get Print Options in mutable.

pub fn set_print_options(&mut self, value: PrintOptions) -> &mut Self

Set Print Options.

Arguments

• value - PrintOptions.

pub fn get_column_breaks(&self) -> &ColumnBreaks

Get Column Breaks.

pub fn get_column_breaks_mut(&mut self) -> &mut ColumnBreaks

Get Column Breaks in mutable.

pub fn set_column_breaks(&mut self, value: ColumnBreaks) -> &mut Self

Set Column Breaks.

Arguments

• value - ColumnBreaks.

pub fn get_row_breaks(&self) -> &RowBreaks

Get Row Breaks.

pub fn get_row_breaks_mut(&mut self) -> &mut RowBreaks

Get Row Breaks in mutable.

pub fn set_row_breaks(&mut self, value: RowBreaks) -> &mut Self

Set Row Breaks.

Arguments

• value - RowBreaks.

pub fn has_table(&self) -> bool

pub fn add_table(&mut self, table: Table)

pub fn get_tables(&self) -> &[Table]

pub fn get_tables_mut(&mut self) -> &mut ThinVec<Table>

pub fn get_data_validations(&self) -> Option<&DataValidations>

pub fn get_data_validations_mut(&mut self) -> Option<&mut DataValidations>

pub fn set_data_validations(&mut self, value: DataValidations) -> &mut Self

pub fn remove_data_validations(&mut self) -> &mut Self

pub fn get_data_validations_2010(&self) -> Option<&DataValidations2010>

pub fn get_data_validations_2010_mut( &mut self, ) -> Option<&mut DataValidations2010>

pub fn set_data_validations_2010( &mut self, value: DataValidations2010, ) -> &mut Self

pub fn remove_data_validations_2010(&mut self) -> &mut Self

pub fn get_sheet_format_properties(&self) -> &SheetFormatProperties

pub fn get_sheet_format_properties_mut(&mut self) -> &mut SheetFormatProperties

pub fn set_sheet_format_properties( &mut self, value: SheetFormatProperties, ) -> &mut Self

pub fn get_image_collection(&self) -> &[Image]

Outputs all images contained in the worksheet.

Return value

• &Vec<Image> - Image Object List.

pub fn get_image_collection_mut(&mut self) -> &mut ThinVec<Image>

Outputs all images contained in the worksheet.

Return value

• &mut Vec<Image> - Image Object List.

pub fn add_image(&mut self, value: Image) -> &mut Self

pub fn get_image<T>(&self, coordinate: T) -> Option<&Image>

where T: Into<CellCoordinates>,

pub fn get_image_mut<T>(&mut self, coordinate: T) -> Option<&mut Image>

where T: Into<CellCoordinates>,

pub fn get_image_by_column_and_row_mut( &mut self, col: &u32, row: &u32, ) -> Option<&mut Image>

pub fn get_images<T>(&self, coordinate: T) -> Vec<&Image>

where T: Into<CellCoordinates>,

pub fn get_images_mut<T>(&mut self, coordinate: T) -> Vec<&mut Image>

where T: Into<CellCoordinates>,

pub fn get_chart_collection(&self) -> &[Chart]

Outputs all Charts contained in the worksheet.

Return value

• &Vec<Chart> - Chart Object List.

pub fn get_chart_collection_mut(&mut self) -> &mut ThinVec<Chart>

Outputs all Charts contained in the worksheet.

Return value

• &mut Vec<Chart> - Chart Object List.

pub fn add_chart(&mut self, value: Chart) -> &mut Self

pub fn get_chart<T>(&self, coordinate: T) -> Option<&Chart>

where T: Into<CellCoordinates>,

pub fn get_chart_mut<T>(&mut self, coordinate: T) -> Option<&mut Chart>

where T: Into<CellCoordinates>,

pub fn get_charts<T>(&self, coordinate: T) -> Vec<&Chart>

where T: Into<CellCoordinates>,

pub fn get_charts_mut<T>(&mut self, coordinate: T) -> Vec<&mut Chart>

where T: Into<CellCoordinates>,

pub fn get_sheet_protection(&self) -> Option<&SheetProtection>

pub fn get_sheet_protection_mut(&mut self) -> &mut SheetProtection

pub fn set_sheet_protection(&mut self, value: SheetProtection) -> &mut Self

pub fn remove_sheet_protection(&mut self) -> &mut Self

pub fn move_range(&mut self, range: &str, row: &i32, column: &i32) -> &mut Self

Moving a section of the sheet

Arguments

‘range’ - Specify like “A1:G8” ‘row’ - The number of rows to move by (negative numbers mean move ‘left’) ‘column’ - the number of columns to move by (negative numbers mean move ‘up’)

pub fn copy_range(&mut self, range: &str, row: &i32, column: &i32) -> &mut Self

Copying a section of the sheet

Arguments

‘range’ - Specify like “A1:G8” ‘row’ - The number of rows to move by (negative numbers mean move ‘left’) ‘column’ - the number of columns to move by (negative numbers mean move ‘up’)

pub fn cleanup(&mut self)

Remove invisible garbage data. Doing so may reduce file size. Processing may take some time.

pub fn copy_cell_styling<T>(&mut self, source: T, target: T)

where T: Into<CellCoordinates>,

pub fn copy_row_styling( &mut self, source_row_no: &u32, target_row_no: &u32, start_col: Option<&u32>, end_col: Option<&u32>, )

Copy the style of a given Row to the target.

Arguments

• source_row_no - Source Row Number.
• target_row_no - Target Row Number.
• start_col - Start Column Number. If None, minimum value
• end_col - End Column Number. If None, maximum value

pub fn copy_col_styling( &mut self, source_col_no: &u32, target_col_no: &u32, start_row: Option<&u32>, end_row: Option<&u32>, )

Copy the style of a given Column to the target.

Arguments

• source_col_no - Source Column Number.
• target_col_no - Target Column Number.
• start_row - Start Row Number. If None, minimum value
• end_row - End Row Number. If None, maximum value

Trait Implementations

impl Clone for Worksheet

fn clone(&self) -> Worksheet

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Worksheet

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

Formats the value using the given formatter.

impl Default for Worksheet

fn default() -> Worksheet

Returns the “default value” for a type.