Copy a Excel workshoot from one file to another
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everybody,
I am working with the Alteryx Designer for a while now and I am facing the problem, that I need to add a prepared worksheet to a big number of existing excel-files.
So my question is:
Does anybody have a workflow which copys a filled and formated worksheet from excel-file A to excel-file B?
Thank you in advance and best regards
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Musuke
You can easily the data from a sheet within an Excel file and output that sheet to other files with Alteryx, but the sheet would not be formatted in any way.
The reporting tools have the capabilities to take your data, format it, and output to an Excel file and specific sheet, but the Render tool overwrites the entire file when ran. So this option would not work for you either.
The only way to copy a sheet between workbooks, and retain formatting, would be to do it programmatically. You could use a VBA macro, Command Prompt, Python, etc.
