use calamine::{open_workbook, Reader, Xlsx};

pub struct Excel {
    path: String,
}

impl Excel {
    pub fn new(path: &str) -> Excel {
        Excel {
            path: path.to_string()
        }
    }

    pub fn to_csv(self, sheet: &str, output_file: &str) {
        let mut excel: Xlsx<_> = open_workbook(self.path).unwrap();
        let mut outputs = Vec::new();
        if let Some(Ok(r)) = excel.worksheet_range(sheet) {
            for row in r.rows() {
                let mut output_row = vec![];
                for value in row {
                    output_row.push(value.to_string());
                }
                outputs.push(output_row);
            }
        }
        let mut writer = csv::Writer::from_path(output_file).unwrap();
        for row in outputs {
            writer.write_record(row.clone()).unwrap();
        }
    }
}