topic RE: Insert new column into Excel worksheet in Product Forum

Insert new column into Excel worksheet

Naga_Prasanthi1 — Mon, 04 Nov 2019 12:16:00 GMT

Hi team,

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

Regards

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

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

RE: Insert new column into Excel worksheet

WojciechFurmans — Tue, 05 Nov 2019 06:20:00 GMT

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
------------------------------

RE: Insert new column into Excel worksheet

SathishkumarPa1 — Tue, 05 Nov 2019 06:45:00 GMT

You can use Insert Action from Excel VBA object

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