Alteryx removing Excel sheet formatting

Vikas_Rawat

Hi All,

I am trying to create a copy of my excel file. All sheets without any formula. I want all formula values should be pasted as values.

I am able to achieve this with below workflow. But even if I have checked Preserve formatting, Alteryx creating new file with values but remove sheets formatting. Please help.   

binu_acs

@Vikas_Rawat If you want to preserve the formatting, then you need to write the output in a specific range of the Excel output file; otherwise, it will remove all the formatting. If you want to preserve the formatting try the blob tools

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280