Struct xlsx_batch_reader::Timestamp

pub struct Timestamp(/* private fields */);

seconds since UNIX epoch

Implementations

impl Timestamp

pub fn utc(&self) -> i64

use cell value as UTC datatime and get timestamp

Examples found in repository

examples/read_datatime.rs (line 17)

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let mut book = XlsxBook::new("xlsx/test.xlsx", true)?;
    for shname in book.get_visible_sheets().clone() {
        // left_ncol should not be 0
        // the tail empty cells will be ignored, if you want the length of cells in each row is fixed, you can set right_ncol to a number not MAX_COL_NUM
        let mut sheet = book.get_sheet_by_name(&shname, 100, 3, 1, MAX_COL_NUM, false)?;

        if let Some((_, rows_data)) = sheet.get_remaining_cells()? {
            let row = &rows_data[0];
            let val_dt: NaiveDate = row[0].get()?.unwrap();
            let val_tm: NaiveTime = row[0].get()?.unwrap();
            let val_dttm: NaiveDateTime = row[0].get()?.unwrap();
            let val_stamp: Timestamp = row[0].get()?.unwrap();   // since v0.1.4
            println!("date:{}\ntime:{}\ndatetime:{}\ntimestamp:{}", val_dt, val_tm, val_dttm, val_stamp.utc());
        }; 
    }
    Ok(())
}

pub fn local(&self) -> i64

use cell value as local datatime and get timestamp, the local time zone is determined by the time zone in which it runs

Trait Implementations

impl Debug for Timestamp

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

Formats the value using the given formatter.

impl FromCellValue for Timestamp

fn try_from_cval(val: &CellValue<'_>) -> Result<Option<Self>>

impl Into<Timestamp> for f64

fn into(self) -> Timestamp

Converts this type into the (usually inferred) input type.

impl Into<Timestamp> for i64

fn into(self) -> Timestamp

Converts this type into the (usually inferred) input type.