import { CreateXlsx } from "build";
import * as fs from "fs";

const xlsxTemplate = fs.readFileSync("template.xlsx").buffer;

const xlsx = new CreateXlsx();
xlsx.openTemplate(xlsxTemplate).then(xlsx => {
    // set the first sheet as the active sheet
    xlsx.setActiveSheet(0);

    // remove cells
    xlsx.removeCell("A1");
    xlsx.removeCell("B3");

    // set the second sheet as the active sheet
    xlsx.setActiveSheet(1);

    // remove cells
    xlsx.removeCell("B5");

    xlsx.save().then(contents => {
        fs.writeFileSync("removeCell_1.xlsx", Buffer.from(contents));
    });
});