Preserve Formatting writing to Excel with "Take File/Table Name From Field" output option

[qasdxx]

Hi,

Within the output tool, I am using the take file/table name from field ouput option to dynamically output my data. I am outputting the data to a range in excel that is already formatted (ie no decimal places in accounting format). The output overrwrites my excel format. I am able to keep the formatting the same when I don't take the file/table name from field and check the 6th option "preserve formatting on overwrite". However, I need to use the take file/table name from field option. Is there a way to preserve formatting with this option?

Thanks. 

[mbarone]

Are you overwriting the whole path using the range in the path as well?

[qasdxx]

Yes i am overwriting the path to include the range. 

[mbarone]

All right, I'll see if I can recreate.  If so, it's probably going to be a Support ticket.  Definitely shouldn't be happening in my opinion.

[mbarone]

I was not able to recreate - I used the checkbox with replace entire file path and it worked.

[mbarone]

[qasdxx]

I have 12 different output tools with a preceding formula tool that tells where to output to my range on Excel. The formula tool is like this: "my file path"+[FileName] (corresponds to tab of excel workbook) + "range" (range differs per each output tool but is the same for all 12 of my tabs. 

[mbarone]

Right, that's the same thing I did.  The field "PATH" in my output tool that I'm changing the entire path with is a dynamically created path/range using a formula tool.  Does your formula tool produce the full path/range with quotes around the sheet name/path as in my screenshot's original path?  Long shot but you never know.

[qasdxx]

I think Alteryx doesn't support preserving formatting when using the take file name from field option in output. I found the same question asked a while ago: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Preserver-Formatting-on-Overwrite-to-E...

Do you know how to add a support ticket for Alteryx to solve this?

Thanks!

[mbarone]

To submit a ticket, there's a Support menu item at the top of the menu bar (https://community.alteryx.com/t5/Support/bd-p/SupportPage).  Although like I said, I did get this to work without issue (see screenshot above - and here is the formula I used):
PATH:
"C:\Users\mbarone\Desktop\XLSX2.xlsx|||'Sheet1$A1:E10'"

And again, watch those quotes.  Sometimes they make a difference.  For me, my formula is in double quotes, and the sheetname/range is in single quotes.