How can I add multiple columns at specific locations to an Excel file ?
Can you help me ?
thank you for your help
How can I add multiple columns at specific locations to an Excel file ?
Can you help me ?
thank you for your help
There are about 10 columns that I need to add to certain places in an Excel report. I made only one, but I wonder if there is a method for more than one.
I did it like in this video for a single column and it worked, but it is needed for more than one column.
Either use a for loop with how many ever column you need and start inserting from the last column
Or use multiple times the same activitiy with different values
For loop you need to first construct a dictionary with key as column name and value as the index …and loop through dict.keys and inside loop use column name as currentitem and column index as Cint(dict(currentitem).ToString)
Cheers
Hi
Try this 2 activity
Thank you