sheetjs drop rows when there are blank rows in .numbers files #3009

New Issue

relaxslow · 2023-10-11T20:42:08Z

relaxslow commented

2023-10-11 20:42:08 +00:00

Hi, team
there is big issue when I reading a .numbers with blank rows, sheetjs drops nearly half of the rows
here is the code
` for (let sheetName of workbook.SheetNames) {
// var csv = XLSX.utils.sheet_to_csv(workbook.Sheets[sheetName]);
// await Bun.write("./tools/testExportCSV.csv",csv)
const jsonData = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], {
header: 1,
blankrows: false,
raw: false
});

}
`
there should be 5853 available , but actually I got 2973

Hi, team there is big issue when I reading a .numbers with blank rows, sheetjs drops nearly half of the rows here is the code ` for (let sheetName of workbook.SheetNames) { // var csv = XLSX.utils.sheet_to_csv(workbook.Sheets[sheetName]); // await Bun.write("./tools/testExportCSV.csv",csv) const jsonData = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], { header: 1, blankrows: false, raw: false }); } ` there should be 5853 available , but actually I got 2973

LM0008421SanDiegoFemA (4) copy.numbers.zip

2.1 MiB

sheetjs commented

2023-10-11 20:46:49 +00:00

Thanks for sharing! We'll take a closer look. Do you know what program last touched the file (e.g. icloud.com web interface, Apple Numbers on the desktop, Apple Numbers for Mac)? Also, just to confirm, are you expecting alternating rows of data? It looks like the even rows are blank in Numbers 13.1

relaxslow commented

2023-10-11 20:52:32 +00:00

yes , I edit the file on mac numbers. No , I don't want the blank rows . I receive this file from client , and I hope to speed up my processing using javascript. so I wrote a program. I have many of them , so it is not practical to correct the file one by one

relaxslow commented

2023-10-11 21:08:26 +00:00

so , I am counting on you ,bro. can you unveil when it could be fixed

relaxslow commented

2023-10-13 00:52:41 +00:00

any update on this , thanks

sheetjs referenced this issue from a commit

2023-10-16 03:04:07 +00:00

QPW string formula results

sheetjs closed this issue

2023-10-16 03:04:07 +00:00

relaxslow commented

2023-10-17 14:10:00 +00:00

Hi, seems that the issue has been fixed , but why I still got error result. when shall I use the fixed version of sheetjs

sheetjs commented

2023-10-17 17:47:59 +00:00

We have to make a new release. If you want a tarball now, join the chat and we can make a pre-release package available for you.

We have to make a new release. If you want a tarball now, join [the chat](https://sheetjs.com/chat) and we can make a pre-release package available for you.

Sign in to join this conversation.