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 => {
    // replace variables with #
    let variables = new Map();
    variables.set("VAR_1", "New value 1");
    xlsx.setTemplateSymbols("#");
    xlsx.replaceVariableText(variables, "sheets");

    // replace variables with ${}
    variables = new Map();
    variables.set("VAR_1", "New value 2");
    xlsx.setTemplateSymbols("${", "}");
    xlsx.replaceVariableText(variables, "sheets");

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