Consider reinterpreting blankrows to treat "" as empty #2836

New Issue

sheetjs · 2022-12-06T23:43:39Z

sheetjs commented

2022-12-06 23:43:39 +00:00

var ws = XLSX.utils.aoa_to_sheet([
  ["a","b"], // "a" , "b"
  ["",]      // (blank string), (no value)
]);
var result = XLSX.utils.sheet_to_json(ws);

Currently the result is an array with one element { a: "" } . It might make sense to skip the row if blankrows is true.

```js var ws = XLSX.utils.aoa_to_sheet([ ["a","b"], // "a" , "b" ["",] // (blank string), (no value) ]); var result = XLSX.utils.sheet_to_json(ws); ``` Currently the result is an array with one element `{ a: "" }` . It might make sense to skip the row if `blankrows` is true.

Sign in to join this conversation.