Struct umya_spreadsheet::structs::worksheet::Worksheet[−][src]

pub struct Worksheet { /* fields omitted */ }

Implementations

`impl Worksheet`[src]

`pub fn get_value<S: Into<String>>(&self, coordinate: S) -> String`[src]

Get value.

Arguments

coordinate - Specify the coordinates. ex) "A1"

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");

`pub fn get_value_by_column_and_row(&self, col: usize, row: usize) -> String`[src]

Get value by specifying the column number and row number.

Arguments

col - Specify the column number. (first column number is 1)
row - Specify the row number. (first row number is 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_by_column_and_row(1, 1);

`pub fn get_formatted_value<S: Into<String>>(&self, coordinate: S) -> String`[src]

Get formatted value.

Arguments

coordinate - Specify the coordinates. ex) "A1"

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");

`pub fn get_formatted_value_by_column_and_row( &self, col: usize, row: usize ) -> String`[src]

Get formatted value by specifying the column number and row number.

Arguments

col - Specify the column number. (first column number is 1)
row - Specify the row number. (first row number is 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_by_column_and_row(1, 1);

`pub fn get_cell_collection(&self) -> &Vec<Cell>`[src]

`pub fn get_cell_collection_mut(&mut self) -> &mut Vec<Cell>`[src]

`pub fn get_cell_collection_to_hashmap(&self) -> HashMap<String, &Cell>`[src]

`pub fn get_collection_by_row(&self, row_num: &usize) -> BTreeMap<usize, &Cell>`[src]

`pub fn get_cell<S: Into<String>>(&self, coordinate: S) -> Option<&Cell>`[src]

Get cell.

Arguments

coordinate - Specify the coordinates. ex) "A1"

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");

`pub fn get_cell_by_column_and_row( &self, col: usize, row: usize ) -> Option<&Cell>`[src]

Gets the cell by specifying the column number and row number.

Arguments

col - Specify the column number. (first column number is 1)
row - Specify the row number. (first row number is 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_by_column_and_row(1, 1);  // get cell from A1.

`pub fn get_cell_mut<S: Into<String>>(&mut self, coordinate: S) -> &mut Cell`[src]

Get cell with mutable.

Arguments

coordinate - Specify the coordinates. ex) "A1"

Return value

&mut Cell - Cell with mutable.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(0);
let cell = worksheet.get_cell_mut("A1");

`pub fn get_cell_by_column_and_row_mut( &mut self, col: usize, row: usize ) -> &mut Cell`[src]

Gets the cell with mutable by specifying the column number and row number.

Arguments

col - Specify the column number. (first column number is 1)
row - Specify the row number. (first row number is 1)

Return value

*&mut Cell - Cell with mutable.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(0);
let cell = worksheet.get_cell_by_column_and_row_mut(1, 1);  // get cell from A1.

`pub fn get_style_collection(&self) -> &Vec<Style>`[src]

`pub fn get_style_collection_mut(&mut self) -> &mut Vec<Style>`[src]

`pub fn get_style_collection_to_hashmap(&self) -> HashMap<String, &Style>`[src]

`pub fn get_style_collection_by_row( &self, row_num: &usize ) -> BTreeMap<usize, &Style>`[src]

`pub fn get_style<S: Into<String>>(&self, coordinate: S) -> Option<&Style>`[src]

Get style.

Arguments

coordinate - Specify the coordinates. ex) "A1"

Return value

Option - Style in the Some.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(0).unwrap();
let style = worksheet.get_style("A1");

`pub fn get_style_by_column_and_row( &self, col: usize, row: usize ) -> Option<&Style>`[src]

Gets the style by specifying the column number and row number.

Arguments

col - Specify the column number. (first column number is 1)
row - Specify the row number. (first row number is 1)

Return value

Option - Style in the Some.

Examples

let book = umya_spreadsheet::new_file();
let worksheet = book.get_sheet(0).unwrap();
let style = worksheet.get_style_by_column_and_row(1, 1);  // get cell from A1.

`pub fn get_style_mut<S: Into<String>>(&mut self, coordinate: S) -> &mut Style`[src]

Get style with mutable.

Arguments

coordinate - Specify the coordinates. ex) "A1"

Return value

&mut Style - Style with mutable.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(0);
let style = worksheet.get_style_mut("A1");

`pub fn get_style_by_column_and_row_mut( &mut self, col: usize, row: usize ) -> &mut Style`[src]

Gets the style with mutable by specifying the column number and row number.

Arguments

col - Specify the column number. (first column number is 1)
row - Specify the row number. (first row number is 1)

Return value

*&mut Style - Style with mutable.

Examples

let mut book = umya_spreadsheet::new_file();
let mut worksheet = book.get_sheet_mut(0);
let style = worksheet.get_style_by_column_and_row_mut(1, 1);  // get style from A1.