Add columns in Excel

[sullivanne]

Hello, I have a question - how to add several columns in Excel at one time?
I’im working on StudioX.

[tazunnisa.badavide (Taj)]

In StudioX, you can add multiple columns to an Excel worksheet at once by using the “Add Data Column” activity.

[Yoichi]

Hi,

Unfortunately, there is no activity to add multiple columns to worksheet of excel at once.
Can you try to use InsertColumn activity with loop as the following?

Regards,

[Kartheek_Battu]

Hello @sullivanne

Excel Application Scope
Input: WorkbookPath - “YourExcelFile.xlsx”

Add Data Column
Input:
- SheetName - “Sheet1”
- Column Name - “Column1, Column2, Column3”
- Data Type - “String”

Thanks & Cheers!!!