Validate heder #2821

New Issue

StefanGhiban · 2022-11-08T13:53:56Z

StefanGhiban commented

2022-11-08 13:53:56 +00:00

Hi! I would like to know if there is a way to give an error to the user if the excel they want to import does not have the specified columns. For example, when I am doing a sheet_to_json, I want to make sure only some columns are being extracted, and if they do no exist in the excel, the user should get an error.

sheetjs commented

2022-11-08 16:17:58 +00:00

You can scan the first row to get the header labels:

/* create range covering the first row */
var range = XLSX.utils.decode_range(ws["!ref"]);
range.e.r = range.s.r;

/* get data as an array of arrays */
var aoa = XLSX.utils.sheet_to_json(ws, {header:1, range});
var headers = aoa[0];

headers will be an array of the headers used as keys in sheet_to_json.

You can scan the first row to get the header labels: ```js /* create range covering the first row */ var range = XLSX.utils.decode_range(ws["!ref"]); range.e.r = range.s.r; /* get data as an array of arrays */ var aoa = XLSX.utils.sheet_to_json(ws, {header:1, range}); var headers = aoa[0]; ``` `headers` will be an array of the headers used as keys in `sheet_to_json`.

sheetjs closed this issue

2022-11-08 16:17:58 +00:00

Sign in to join this conversation.