Sheet order changing by simply reading and rewriting data to new file

[NikhilCodes]

I have this excel file.
s3data1.xlsx

I have this simple snippet.

const again = await XlsxPopulate.fromFileAsync('./s3data1.xlsx').then((workbook) => {
      workbook.toFileAsync('test.xlsx');
      return workbook.outputAsync()
    });

And I see a file test.xlsx created
test.xlsx

Now if you carefully look at both files.
Content in 2nd tab of first sheet has shifted to 4th tab of 2nd sheet.

What am I doing wrong? Any help at the earliest would be appreciated.

[mp3por]

You only need the workbook.toFileAsync(). Calling workbook.outputAsync afterwards is not needed.

[AmdEagle]

@NikhilCodes Did you get this issue fixed as i am facing the same problem. Would like to know more info.

[NikhilCodes]

@AmdEagle what i had to do was, read the file using python pandas and save it again. After that the xlsx-populate doesnt glitch if you work on newly saved file. Reasons unknown. But works