use std::{fs::File, io::BufReader};

use crate::sheet::{cell::Cell, tablized::Tablized};

pub fn load_csv(path: String) -> Tablized {
    let file = File::open(path).unwrap();
    let reader = BufReader::new(file);
    let mut csv_reader = csv::Reader::from_reader(reader);

    let mut table = Vec::new();

    for result in csv_reader.records() {
        if let Ok(record) = result {
            table.push(record.iter().map(|s| Cell::from(s)).collect::<Vec<Cell>>())
        }
    }

    Tablized::Vector(table)
}