Hi, Add data column worked with that i created a new column. But i am unable to write that column in to excel next to the last populated column in the excel sheet.
Every day a column will be created, and i need that column to be added to the sheet every day so over time i have data for each day in columns
How can i do that. Thanks for responding.
I ended up using the following solution provided by @aksh1yadav , where the attached work flow was designed to dynamically give the column name. So I assigned a column counter variable and input it into the the work flow done by @aksh1yadav. The output of the work flow was then given to the write range activity. So what happens is the robot reads the file, counts the number of columns in the excel, count+1 gives empty column numeric, that goes into write range activity range.