The first empty rows aren't displayed

[nghuuphuoc]

Sample spreadsheet:
Untitled-spreadsheet.xlsx

The top first five rows are empty. I would like to see them as well. However, it seems that the library ignores them:

Is that a bug or default behavior? Is there any option for displaying first empty rows?

[nghuuphuoc]

cc @hiepsieunhan

[SheetJSDev]

This is a very weird case because the worksheet itself reports the starting cell as A6. You can pin the worksheet to A1 as follows:

/* ws is the worksheet, e.g. workbook.Sheets["Sheet1"] */
var range = XLSX.utils.decode_range(ws["!ref"]);
range.s.r = range.s.c = 0; // force range to start at A1
ws["!ref"] = XLSX.utils.encode_range(range);

We can update the demo with that effect on each worksheet after reading the file.

Changing the library would probably require a version bump since it would break sheet_to_json behavior when the first few rows are blank