!rows数组中的数据有缺失 #3091

New Issue

Kerwin · 2024-03-21T08:49:24Z

Kerwin commented

2024-03-21 08:49:24 +00:00

我使用这个方式 XLSX.read(data, {type: 'binary', cellStyles: true}) 读取出来了每一个 sheet 中的 !rows 和 !cols 数据，但是在我查询其中一个 sheet 的数据时，发现 !rows 数组中的数据时缺失的。Example，长度为5的数组，索引应该为 0, 1, 2, 3, 4. 可是现在显示出来的只有 0, 1, 4。

Screenshot 2024-03-21 164718.png

51 KiB

Kerwin commented

2024-03-21 08:50:41 +00:00

当我把这几行在 Excel 中 hidden 起来之后，反而可以显示出来 hidden 的属性，但是其他的属性就不显示了

sheetjs commented

2024-03-21 08:54:02 +00:00

The !rows metadata is only available for rows that use custom row heights or visibility settings. If you can share a file, we can take a closer look.

The `!rows` metadata is only available for rows that use custom row heights or visibility settings. If you can share a file, we can take a closer look.

Kerwin commented

2024-03-21 09:03:24 +00:00

Sorry, the file is confidential. Can't share it with you. Thank you for your reply. I will try your suggestion.

Kerwin closed this issue

2024-03-22 00:34:37 +00:00

Sign in to join this conversation.