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 record in csv_reader.records().flatten() {
        table.push(record.iter().map(Cell::from).collect::<Vec<Cell>>())
    }

    Tablized::Vector(table)
}