pub struct Range<T: CellType> { /* private fields */ }
Expand description
A struct which represents a squared selection of cells
Implementations
sourceimpl<T: CellType> Range<T>
impl<T: CellType> Range<T>
sourcepub fn new(start: (u32, u32), end: (u32, u32)) -> Range<T>
pub fn new(start: (u32, u32), end: (u32, u32)) -> Range<T>
Creates a new non-empty Range
When possible, prefer the more efficient Range::from_sparse
Panics
Panics if start.0 > end.0 or start.1 > end.1
sourcepub fn from_sparse(cells: Vec<Cell<T>>) -> Range<T>
pub fn from_sparse(cells: Vec<Cell<T>>) -> Range<T>
Creates a Range
from a coo sparse vector of Cell
s.
Coordinate list (COO) is the natural way cells are stored Inner size is defined only by non empty.
cells: Vec
of non empty Cell
s, sorted by row
Panics
panics when a Cell
row is lower than the first Cell
row or
bigger than the last Cell
row.
sourcepub fn set_value(&mut self, absolute_position: (u32, u32), value: T)
pub fn set_value(&mut self, absolute_position: (u32, u32), value: T)
Set inner value from absolute position
Remarks
Will try to resize inner structure if the value is out of bounds. For relative positions, use Index trait
Try to avoid this method as much as possible and prefer initializing
the Range
with from_sparse
constructor.
Panics
If absolute_position > Cell start
Examples
use calamine::{Range, DataType};
let mut range = Range::new((0, 0), (5, 2));
assert_eq!(range.get_value((2, 1)), Some(&DataType::Empty));
range.set_value((2, 1), DataType::Float(1.0));
assert_eq!(range.get_value((2, 1)), Some(&DataType::Float(1.0)));
sourcepub fn get_value(&self, absolute_position: (u32, u32)) -> Option<&T>
pub fn get_value(&self, absolute_position: (u32, u32)) -> Option<&T>
Get cell value from absolute position.
If the absolute_position
is out of range, returns None
, else returns the cell value.
The coordinate format is (row, column).
Warnings
For relative positions, use Index trait
Remarks
Absolute position is in sheet referential while relative position is in range referential.
For instance if we consider range C2:H38:
(0, 0)
absolute is “A1” and thus this function returnsNone
(0, 0)
relative is “C2” and is returned by theIndex
trait (i.emy_range[(0, 0)]
)
Examples
use calamine::{Range, DataType};
let range: Range<usize> = Range::new((1, 0), (5, 2));
assert_eq!(range.get_value((0, 0)), None);
assert_eq!(range[(0, 0)], 0);
sourcepub fn rows(&self) -> Rows<'_, T>ⓘNotable traits for Rows<'a, T>impl<'a, T: 'a + CellType> Iterator for Rows<'a, T> type Item = &'a [T];
pub fn rows(&self) -> Rows<'_, T>ⓘNotable traits for Rows<'a, T>impl<'a, T: 'a + CellType> Iterator for Rows<'a, T> type Item = &'a [T];
Get an iterator over inner rows
Examples
use calamine::{Range, DataType};
let range: Range<DataType> = Range::new((0, 0), (5, 2));
// with rows item row: &[DataType]
assert_eq!(range.rows().map(|r| r.len()).sum::<usize>(), 18);
sourcepub fn used_cells(&self) -> UsedCells<'_, T>ⓘNotable traits for UsedCells<'a, T>impl<'a, T: 'a + CellType> Iterator for UsedCells<'a, T> type Item = (usize, usize, &'a T);
pub fn used_cells(&self) -> UsedCells<'_, T>ⓘNotable traits for UsedCells<'a, T>impl<'a, T: 'a + CellType> Iterator for UsedCells<'a, T> type Item = (usize, usize, &'a T);
Get an iterator over used cells only
sourcepub fn deserialize<'a, D>(
&'a self
) -> Result<RangeDeserializer<'a, T, D>, DeError>where
T: ToCellDeserializer<'a>,
D: DeserializeOwned,
pub fn deserialize<'a, D>(
&'a self
) -> Result<RangeDeserializer<'a, T, D>, DeError>where
T: ToCellDeserializer<'a>,
D: DeserializeOwned,
Build a RangeDeserializer
from this configuration.
Example
fn example() -> Result<(), Error> {
let path = format!("{}/tests/tempurature.xlsx", env!("CARGO_MANIFEST_DIR"));
let mut workbook: Xlsx<_> = open_workbook(path)?;
let mut sheet = workbook.worksheet_range("Sheet1")
.ok_or(Error::Msg("Cannot find 'Sheet1'"))??;
let mut iter = sheet.deserialize()?;
if let Some(result) = iter.next() {
let (label, value): (String, f64) = result?;
assert_eq!(label, "celcius");
assert_eq!(value, 22.2222);
Ok(())
} else {
return Err(From::from("expected at least one record but got none"));
}
}