Skip to content

If I add more then 1 sheet all sheets are hidden except for the 1st sheet #617

@techiekayen

Description

@techiekayen

Hi, I am nor sure if this is a bug or if some new functionality has been added but I am using the latest version of exceljs (1.5.1) and if I add more then one sheet to a workbook then all sheets after the first sheet are hidden and I am not able to make them visible using code.

Here is some sample code to re-produce the issue:

const Exceljs = require("exceljs");

let wb = new Exceljs.Workbook();

let sheet1 = wb.addWorksheet("s1");
let sheet2 = wb.addWorksheet("s2");

wb.xlsx.writeFile("myWb.xlsx");

If you open this workbook sheet "s2" is hidden. I tried using:

sheet2.state = "show";
but this doesn't help. Is this a bug or am I missing something?

This works if I use 1.4.6.

Thanks!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions