Forum Discussion

rashmi's avatar
rashmi
New Contributor III
4 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 ...
koryknick's avatar
koryknick
Employee
3 years ago

If you know the names of the sheets, you can read in the Excel file using the Excel Parser snap (once for each sheet), then re-create the file using the Excel Multi-Sheet Formatter snap with 4 input views.

It will look something like this: