Forum Discussion

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

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:

Forum Discussion

Dynamically parse the excel without having sheet index or sheet name

Recent Discussions

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM

Pagination and nextCursor in header

Javascript to promote top level lists