Insert new column into Excel worksheet

[Naga_Prasanthi1]

Hi team,

Can anyone let me know how to include a new column in excel worksheet using BP.

Regards

------------------------------
Prasanthi

------------------------------

[WojciechFurmans]

Hi,

You must add code:

GetWorkbook(handle,Nothing).ActiveSheet.Range(reference).EntireColumn.Insert

VariableIn "reference".

example:
if you want to add one column "K:K".
if you want to add more "K:J". (Two columns added)


Regards,

------------------------------
Wojciech Furmanski
Consultant RPA
Digital Teammates SA
Europe/Warsaw
------------------------------

[SathishkumarPa1]

You can use Insert Action from Excel VBA object

------------------------------
Sathishkumar Palaniswamy
------------------------------