JavaScript API: setActiveSheet

import { CreateXlsx, OptionsCellContents, OptionsSheet } from "build";
import * as fs from "fs";

const xlsx = new CreateXlsx();

xlsx.addSheet();

const sheetOptions: OptionsSheet = {
    name: "Other",
};
xlsx.addSheet(sheetOptions);

// this method doesn't change the activeTab in the workbook file. It's used as internal active sheet
xlsx.setActiveSheet(1);

// add sample contents
const content: OptionsCellContents = {
    text: "Lorem ipsum dolor sit amet",
};
xlsx.addCell(content, "A1");

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

Release notes

phpxlsx 5.0:
- new method.