Hi I have a template dashboard as shown below. I have a workflow to collect the sales amount from various sources and I want to update the existing sales excel file. when I run the workflow in the output is it possible to update the "Sales" column C5,C10 and C11. I have tried using the range option but not able to do it as the template has some hidden rows. help is greatly appreciated.
Hi @lumjingbki ,
These blog posts may be helpful as it shows how to put data to specfic cells.
https://community.alteryx.com/t5/Alteryx-Community-Resources/Alteryx-amp-Excel-Guide/ta-p/991380
Thank you Yoshiro_Fujimori !
I tried and it is working for input in Range C19-C21 and also a single cell C5. I have many single cell like C5 to update. I am thinking if we need to have multiple input files to update those single cells. I have about 20 single cells to be updated as the excel templet file has some hidden rows. I have spend some time but not able to conclude on the solution to update multiple single cells. Any inputs will be of great help.
Hi @lumjingbki ,
If I can tweak your Excel template, I would add a sheet to store all the values to set in the template.
[Template] Sheet
[Data] Sheet
Once you have this setting, all you should do is to set the data for each "Single Cell" on to [Data] Sheet in the same way on the blog post.
Then it does not matter if the cell is hidden or shown.
I hope it helps.