Hi, I am using Alteryx Designer x64 version 2023.2.1.7 Desktop. I can't post the workflow due to privacy concerns. I have a workflow where I have an .xlsx output that appends a row of data to the end of an existing .xlsx spreadsheet (screenshot # 1). I am trying to make the workflow and process automated where I would not have to go into the Excel spreadsheet each week and change the formatting for the new week's data for 34 columns to $, %, commas, etc. manually. So, I added a formula tool that does all the formatting in the workflow (screenshot # 3). I then have a Select tool of which the data types are 'V_WString' (screenshot # 4). The purpose is for the output to email to the necessary individuals directly as opposed to manually emailing it. The issue I am encountering is that the appended row of data does not match thee existing file formatting (screenshot attached with the new row output appended to the existing data). When I hover over the new appended row cells in the .xlsx appended output it says "the number in this cell is formatted as text or preceded as an apostrophe." I then tried changing the data types in the Select tool before the output tool from 'V_WString' to numeric (Int, double, etc.) but that changed the formatting to remove the $, %, and commas, etc. which I need. Note, when I change the output to a CSV the formatting is exactly what I need but the issue is that I lose all the column header colors as well as the ability to continue to include 2 worksheets in one Excel report. I have also tried using the Table tool and Render tool to align the data to the right Right but there was no option to Append to an existing file and it ended up overwriting the existing file and only returning the new row of data in the output .xlsx file so I scrapped that route. Any help would be appreciated. Thank you.
