hi Actually my requirement is like this. I am having one excel in which I have to add two column in last. Column name “Prize” and “Owner”. But my existing column range will be dynamic. So first we need to get last column and then add above two column. I am attaching the excel. We have to add new …

Hi @sshitol First make a Read Range and then take two Add Data Column activity. Add your columns one by one. Finally make a Write Range on the same sheet and same range. Make sure the Write Range has its AddHeader property checked. As your test file has the Other column names at row 6, the read…

Add two column in last

Help Forum

Rahul_Unnikrishnan (Rahul Unnikrishnan) December 27, 2022, 3:05pm 9

@sshitol

Do as below

Thanks

Topic		Replies	Views
Adding two new column at the end of the excel sheet dynamically Forum forum , question	7	970	December 28, 2022
Add column in excel with column name Help datatable , activities , question	21	13888	August 26, 2020
How to append the column values afetr the last column dynamically Automation Ops question , automation_ops	19	397	March 26, 2024
Add new column name in data table Help datatable , activities , question	10	2760	December 20, 2019
Add column Help datatable , activities , question	14	1825	November 24, 2019

Add two column in last

Related topics