Hi, I have excel file which is contains dynamic columns. Sometimes it will have 10 cols & some time it will have 15 cols. I need to find the specified column and in cell 2 need to wirte formula and fill the column. Please guide me
Follow the below steps,
→ Use the Excel Process scope activity insert the Use excel file activity inside it.
→ Give the Path of the excel file in the Use excel file activity.
→ Inside Use excel file activity insert the For each excel row activity to iterate the each row in the excel.
→ Inside For each activity insert the write cell activity. Give the Formula in the what to write field, and give the CurrentRow.ByField(“Column name”) in where to write field.
By following the above steps, the bot will write the forumlae till the last row in the Column where you want.
Check the below workflow for better understanding,
Note: change the Column name based on your requirement in the Where to write field in write cell activity.
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.