Add sheet to existing workbook

Hi All -

I have created on workflow which generate output and save same output to specific sheet along with existing sheet.

everything work fine. since have to do some formatting to output I had to used "Report Tool" and "Render Tool" but it doesn't work for me.

when I remove sheet name it works but delete all the existing sheet.

could anyone suggest something.

Thanks

Mukesh

Dynamic Processing

Accepted answers

All comments

AngelosPachis

Hi @Mukeshy12390 ,

At the moment, you are not defining the sheet within which you want to save your table. Alteryx does that by using the ||| notation.

C:\Users\xxx\xxxx\My Tableau Repository\Datasources\2020.3\en_US-US\Sample - Superstore.xls|||`Orders$`

Observe how after my superstore.xls file, I have three "|" to denote that within this xls file, I want to create a sheet called Orders.

You should do a similar thing, so change the file path for each one of the records you want to save under a specific sheet.

Give this a try and let me know if it worked for you

Mukeshy12390

thanks for the reply.I tried it doesn't work.

I'm passing path and sheet details by group data.

AkimasaKajitani

As far as I know, Rendering tool always overwrite existing file(always make as new file).

How about reading the existing file and reformatting the data in Designer and new data and existing data that is reformatted put into the same xlsx file.

Mukeshy12390

they are about 150 sheets in (different 15 excel file ) all existing sheet has function GUI that Alteryx doesn't support.

like pivot.group/ungroup Data validation etc.

I'm really surprised the way "Render tools" works.

Thanks

AngelosPachis

Hi @Mukeshy12390 ,

On a second thought, you can achieve that with the Render tool. You just have to use a Layout tool, configured as shown below

Screenshot 2020-11-26 115922.jpg

Then leave your render tool with a default configuration, so no need for you to define a group.

Another way is that proposed in the following post :

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Render-to-multiple-tabs-in-1-excel-file/m-p/672096#M157668

Either should work for you.

Hope that helps.

Cheers,

Angelos

example.yxzp

Mukeshy12390

thanks for the reply.

I tried it doesn't work it does create multiple tab but removes all the existing file (all previous sheet).

what I have observed in RENDER tool there is no option to put sheet name.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335