Forum Discussion

rashmi's avatar
rashmi
New Contributor III
3 years ago

Dynamically parse the excel without having sheet index or sheet name

Hi, Anyone aware of how do we parse the excel with multisheet without even knowing sheet index / sheet name with having certain number of records in each sheet. I am having requirement to remove ...
dimitri_hristov's avatar
dimitri_hristov
Contributor
6 years ago
Copy LinkReport

Hi @mjain,

Maybe you could try and use the JSON Splitter Snap to split the array into separate JSON documents.

BR,
Dimitri

mjain's avatar
mjain
New Contributor
6 years ago
Copy LinkReport

Hi Dimitri thanks for the quick reply I am attacting the screenshot can you please look into this. I have also tried json splitter but it is not working And the file header shoud be first array.

I am expecting in