Excel sheets Exception

[Ajith1]

Hi all

I have an Excel file in Sheet names Like 2,L2,L3,1
I need to remove sheets 2 and 1
and it needs to append data L2 and L3

if some times my sheets to be adding my excel-like L4,L5,L6


Could you please suggest to me

[pedrodrfaria · Accepted solution]

Hi @Ajith1 

Please see attached for one example:

We input the file by the sheet names, then we filter out everything that we do not want, adjust the file path to the correct sheet name and then load the files with an XLSX Excel Macro Opener that I created.

Please remember to assign solutions to the discussion posts that you open as it really helps the people answering the questions. You can assign multiple solutions if that is the case)

Pedro.

[DanielG]

Hi,

You can pull in the existing data into your workflow from L2, L3, etc. and append the data within the workflow and just have your first output overwrite the entire file, then using Block Until Done have the other outputs follow in series adding new sheets to the output created first.

This way any existing sheets you dont need will not get recreated in the initial overwrite of the file.

Hopefully that makes some sense.