#![allow(clippy::expect_used, clippy::panic, clippy::print_stdout)]
use excelerate::model::Spreadsheet;
use excelerate::{CellRef, edit};
fn sheet_index(book: &Spreadsheet, title: &str) -> usize {
book.sheets()
.iter()
.position(|s| s.title() == title)
.expect("no sheet by that name")
}
fn formulas(book: &Spreadsheet) -> Vec<Vec<(CellRef, String)>> {
book.sheets()
.iter()
.map(|sheet| {
sheet
.iter()
.filter_map(|(at, cell)| match &cell.value {
excelerate::model::CellValue::Formula { formula, .. } => {
Some((at, formula.clone()))
}
_ => None,
})
.collect()
})
.collect()
}
fn main() {
let mut args = std::env::args().skip(1);
let input = args
.next()
.expect("usage: edit <in> <out> <op> <sheet> [..]");
let output = args
.next()
.expect("usage: edit <in> <out> <op> <sheet> [..]");
let op = args
.next()
.expect("usage: edit <in> <out> <op> <sheet> [..]");
let title = args
.next()
.expect("usage: edit <in> <out> <op> <sheet> [..]");
let mut book = excelerate::reader::read(&input).expect("input reads");
let sheet = sheet_index(&book, &title);
let before = formulas(&book);
let started = std::time::Instant::now();
match op.as_str() {
"insert-rows" | "remove-rows" => {
let at = args
.next()
.expect("a row number")
.parse::<u64>()
.expect("a number");
let at = excelerate::Row::from_one_based(at).expect("a row of the sheet");
let count = args.next().map_or(1, |n| n.parse().expect("a number"));
if op == "insert-rows" {
edit::insert_rows(&mut book, sheet, at, count)
} else {
edit::remove_rows(&mut book, sheet, at, count)
}
.expect("the edit applies");
}
"insert-columns" | "remove-columns" => {
let letters = args.next().expect("a column letter");
let at = excelerate::Col::from_letters(&letters).expect("a column of the sheet");
let count = args.next().map_or(1, |n| n.parse().expect("a number"));
if op == "insert-columns" {
edit::insert_columns(&mut book, sheet, at, count)
} else {
edit::remove_columns(&mut book, sheet, at, count)
}
.expect("the edit applies");
}
"rename" => {
let to = args.next().expect("the new name");
edit::rename_sheet(&mut book, sheet, &to).expect("the name is valid");
}
"drop" => edit::remove_sheet(&mut book, sheet).expect("the sheet goes"),
other => panic!("unknown operation {other}"),
}
let edited = started.elapsed();
let after = formulas(&book);
let dropped = op == "drop";
let mut changed = 0;
let mut broken = 0;
for (index, was_sheet) in before.iter().enumerate() {
let now_index = match (dropped, index.cmp(&sheet)) {
(true, std::cmp::Ordering::Equal) => continue,
(true, std::cmp::Ordering::Greater) => index - 1,
_ => index,
};
let title = book
.sheet(now_index)
.map_or("", excelerate::model::Worksheet::title);
for ((_, was), (at, now)) in was_sheet.iter().zip(&after[now_index]) {
if was == now {
continue;
}
changed += 1;
if changed <= 10 {
println!("{title}!{at}\t{was}\t->\t{now}");
}
if now.contains("#REF!") && !was.contains("#REF!") {
broken += 1;
}
}
}
println!("{edited:?}: {changed} formulas rewritten, {broken} now #REF!");
let computed = excelerate::formula::eval::recalculate(
&mut book,
None,
&excelerate::progress::Options::default(),
);
println!("{computed} formulas recomputed");
excelerate::writer::xlsx::write_xlsx(&book, &output).expect("output writes");
}