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.