I defined column names, set hasHeader: true and use that schema:
const schema = { "COL_A": {prop: "A"}, "COL_B": {prop: "B"}, "COL_C": {prop: "C"}, "COL_D": {prop: "D"} };
but looks like column names are not respected, when some cell values is missing
Example file:
Result:
Additional info:
input.xlsx file was created using LibreOffice Calc 6.4.3.2 (x64) on Windows 10 system.
Tested on node.js: 11.15.0 and 12.16.2
I defined column names, set
hasHeader: trueand use that schema:const schema = { "COL_A": {prop: "A"}, "COL_B": {prop: "B"}, "COL_C": {prop: "C"}, "COL_D": {prop: "D"} };but looks like column names are not respected, when some cell values is missingExample file:
Result:
Additional info: input.xlsx file was created using LibreOffice Calc 6.4.3.2 (x64) on Windows 10 system. Tested on node.js: 11.15.0 and 12.16.2