Output data to a formatted excel file
- 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
Hi,
Is there any possibility to output data from Alteryx to a provided formatted excel file including macros and formulas which should not be removed/ touched?
An example: there is a workbook file with multiple tabs provided by an external vendor in their format to transform data provided by us.
Thanks and regards
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @KW_S2
You can choose to output to specified range in a specified sheet (i.e. replace only hardcoded value). The formatting can be preserved, see discussion in this thread.
good luck,
Dawn.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! It is working great! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DawnDuong & @KW_S2 ,
I have also seen instances where individuals will use the blob tool in order to output to a pre-formatted excel template. Take a look at the Community post found here:
Thanks,
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @MichaelSu . very helpful blog post!
