This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is it possible to retain some of the formatting from an existing sheet?
Basically I have a sheet that I would like to overwrite daily, but in several columns I have Data Validation drop down lists. I do not want those touched.
In my workflow those fields are Null(), I have tried to overwrite sheet and (with and without skip field names) but it overwrites the data validation.
Append may work but I do not need previous days data. I tried to simulate if after working the document I deleted the rows from that day, so it is only the header row, then re-ran, it appends on like row 1000. It keeps the drop downs though!
Depending on what version of Designer you have, you can preserve formatting on overwrite if you put in a range when you output. If you have the same layout everyday, I'd suggest putting the columns that you don't what overwritten at the end of your table.
In the attached workflow, I only brought in the fields that I wanted to update by naming the cell range (I could've also created a named range in excel). I then did any transformation I needed to and then I output directly back into the same sheet. I again, selected the range that I wanted to output to and checked the box that said 'Preserve Formatting on Overwrite' in the Options.
Original xlsx (I didn't bring the Validation field into Alteryx):
I am on the most recent version of Alteryx. I noticed in the workflow that you attached that you chose "Create New Sheet" as your output option, but when I try to use this option to overwrite on an existing sheet Alteryx will not allow it. When I choose "Overwrite Sheet or Range," with my range specified A7:D30, it overwrites all columns in those rows, not just columns A-D. Also, when I use this output option I get a message that my file has been damaged.
Try un-checking 'Skip Field Names'. I see a few community posts that say that this occasionally has been corrupting excel files. Since the new version of Alteryx can preserve formatting, it's not going to change how your headers look.