Deleting a sheet from excel file

Question

Hi All,

I need a support from my more experienced colleagues. I have a file having three sheets and only two of them I need to keep, the 3rd one should be skipped.

I've went through  several posts in the Community where similar issue was described, but any of existing solution were helpful to me.

Is there any way to do this or Alteryx is just not giving such possibility?

The screenshot above shows an example of a file I have, the goal is to keep only tab 1st and 2nd.

Thank you for any kind of help.

take care

DavidP · Answer

Hi @Bart_Esz

You could load the desired sheets with Input Data tools and then use a Block Until Done tool to ensure they are written back in a specified sequence. You can then set the Output Data tool for the first sheet to replace the entire file which would delete all existing sheets. Your workflow would look something like this:

Bart_Esz · Answer

hi @mceleavey , I'm sorry for not putting myself clear.

I'm thinking about loading a file having three tabs into Alteryx and output only two of them.

regards

mceleavey · Answer

Hi @Bart_Esz ,

what do you mean "keep"?

Are you talking about actually outputting to the Excel file and removing the tab? Or are you talking about loading them into Alteryx and simply ignoring one sheet?

M.