hello,
I am using the table tool before writing my data into an excel sheet.
when I use a browse to look at the result of table its looks good, when I write it into an excel file it apears just as code, anyone knows what the problem is?
Cheers
Hi @TonyMu
you are using output for report output
you need to use render tool for report output.
https://help.alteryx.com/current/designer/render-tool
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Can I write to a specific sheet and range using Render?
OK, where do I sprcify the sheet in render tool?
Hi @TonyMu
Its not straight forward
Check the config for this workflow
In layout tool this config at the bottom gives the sheet name.
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @TonyMu
May I suggest that you use the output data tool to append to a worksheet range and further benefit from keeping the destination formatting and minimize runtime...if you are not rendering text, header, footer, images, etc.
Something like this.
OK, thanks. Is there a way that render preserves formatting while overwriting?
Cheers
it does not apear like a table in the output file if I do as you suggest, or?