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.
- edited on
Can an excel template be updated if the incoming information is not in a block form? Say I want to fill in a form from an existing list into something like this template.
This is a question we get from time to time. There are a few options on how to do this, the below provided by
I was using Option 1, mentioned above, and would often times open the file after Alteryx had run to find that some tabs had been deleted. I could never find a pattern, because it was never the same tabs that would be deleted.
In this senario i would output to the output tabs and agregate them into the Summary tab. Each output was blocked by a Block Until Done so Alteryx wasnt trying to access the in-use file.
Have you all seen this before and/or know of any fixes?
My work around was to output to File A and put my summary in File B that refferenced File A. Definitely not ideal due to the limitations of Excel.
Hope this helps,
I created a workflow that splits 1 file into multiple excel files (into specific template). The issue I have is that its is also adding the column titles that are already in my template, so I get the column title in duplicate (in red below). Any idea how I could avoid this?
I had similar issue. My work around of getting rid of fields is renaming those headers to whatever desired one row above the output data in the spreadsheet. For empty cell, you can rename the field name as " " (make sure you have at least one space there). Fortunately it will be trimmed in the spreadsheet output.