Struct umya_spreadsheet::structs::Spreadsheet

pub struct Spreadsheet { /* fields omitted */ }

Implementations

impl Spreadsheet

pub fn insert_new_row<S: Into<String>>(
    &mut self,
    sheet_name: S,
    row_index: usize,
    num_rows: usize
)

Insert new rows.

Arguments

• sheet_name - Specify the sheet name. ex) “Sheet1”
• row_index - Specify point of insert. ex) 1
• num_rows - Specify number to insert. ex) 2

Examples

let mut book = umya_spreadsheet::new_file();
book.insert_new_row("Sheet1", 2, 3);

pub fn insert_new_colmun<S: Into<String>>(
    &mut self,
    sheet_name: S,
    column: S,
    num_columns: usize
)

Insert new colmuns.

Arguments

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

Examples

let mut book = umya_spreadsheet::new_file();
book.insert_new_colmun("Sheet1", "B", 3);

pub fn insert_new_colmun_by_index<S: Into<String>>(
    &mut self,
    sheet_name: S,
    column_index: usize,
    num_columns: usize
)

Insert new colmuns.

Arguments

• sheet_name - Specify the sheet name. ex) “Sheet1”
• column_index - Specify point of insert. ex) 2
• num_columns - Specify number to insert. ex) 3

Examples

let mut book = umya_spreadsheet::new_file();
book.insert_new_colmun_by_index("Sheet1", 2, 3);

pub fn remove_row<S: Into<String>>(
    &mut self,
    sheet_name: S,
    row_index: usize,
    num_rows: usize
)

Remove rows.

Arguments

• sheet_name - Specify the sheet name. ex) “Sheet1”
• row_index - Specify point of remove. ex) 1
• num_rows - Specify number to remove. ex) 2

Examples

let mut book = umya_spreadsheet::new_file();
book.remove_row("Sheet1", 2, 3);

pub fn remove_colmun<S: Into<String>>(
    &mut self,
    sheet_name: S,
    column: S,
    num_columns: usize
)

Remove colmuns.

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();
book.remove_colmun("Sheet1", "B", 3);

pub fn remove_colmun_by_index<S: Into<String>>(
    &mut self,
    sheet_name: S,
    column_index: usize,
    num_columns: usize
)

Remove colmuns.

Arguments

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

Examples

let mut book = umya_spreadsheet::new_file();
book.remove_colmun_by_index("Sheet1", 2, 3);

pub fn get_defined_names(&self) -> &Vec<DefinedName>

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

pub fn set_defined_names(&mut self, value: Vec<DefinedName>)

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

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

pub fn get_theme(&self) -> &Theme

pub fn get_properties(&self) -> &Properties

pub fn get_properties_mut(&mut self) -> &mut Properties

pub fn set_properties(&mut self, value: Properties)

pub fn get_security(&self) -> &Security

pub fn get_security_mut(&mut self) -> &mut Security

pub fn set_security(&mut self, value: Security)

pub fn get_macros_code(&self) -> &Option<Vec<u8>>

pub fn get_has_macros(&self) -> &bool

pub fn get_unparsed_loaded_data(&self) -> &Vec<String>

pub fn set_unparsed_loaded_data(&mut self, value: Vec<String>)

pub fn get_active_sheet_index(&self) -> &usize

pub fn get_sheet_collection(&self) -> &Vec<Worksheet>

pub fn get_sheet_count(&self) -> usize

pub fn get_sheet(&self, index: usize) -> Result<&Worksheet, &'static str>

pub fn get_sheet_mut(&mut self, index: usize) -> &mut Worksheet

pub fn get_sheet_by_name<S: Into<String>>(
    &self,
    value: S
) -> Result<&Worksheet, &'static str>

pub fn get_sheet_by_sheet_id<S: Into<String>>(
    &self,
    value: S
) -> Result<&Worksheet, &'static str>

pub fn get_sheet_by_name_mut<S: Into<String>>(
    &mut self,
    value: S
) -> Result<&mut Worksheet, &'static str>

pub fn new_sheet<S: Into<String>>(
    &mut self,
    value: S
) -> Result<&mut Worksheet, &'static str>

pub fn set_sheet_title<S: Into<String>>(
    &mut self,
    index: usize,
    value: S
) -> Result<(), &'static str>

pub fn has_ribbon(&self) -> bool

pub fn has_formula(&self) -> bool

Trait Implementations

impl Debug for Spreadsheet

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

Formats the value using the given formatter.

impl Default for Spreadsheet

fn default() -> Spreadsheet

Returns the “default value” for a type.