My company utilizes a gallery for non-alteryx users. They simply go into the gallery and upload their data then they download the corresponding file that the workflow produces (primarily an excel file).
They're able to upload their data due to the Interface Tool - File Browse incorporated into my workflow.
However, my workflow is different when it comes to the downloadable file (final product).
I need a specific template to be produced with the data in certain cell ranges. Unfortunately, I cannot share the template.
My overall question: Is there an equivalent Interface Tool - File Browse for output data? So I can upload to the gallery to tell my workflow to spit the data on this template in specific cells.
This is all that the non-alteryx users see. They don't see the workflow at all. These four "questions" are the File Browse tools linked to my input tools in my workflow.
You can hide the columns within the excel file and then overwrite that specific file and this should only overwrite the specific cells that are not hidden.
You can also select Preserve Formatting on Overwrite (Range Required) option within the Output tool.
Hope this helps.