Dynamically parse the excel without having sheet index or sheet name

[rashmi]

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 the email ids from first row of first sheet and rest of the sheets as is upload. Please let me know is there any other approach instead of parsing each sheet

Any help is appreciated.

[lingared]

@koryknick This example works great if it is to replace an existing sheet. My requirement is to add a new sheet along with existing ones.

Suppose I already have an excel file with three sheets and I am getting a stream of data which I need to put into the fourth one… is there a solution for this?

[koryknick]

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: