Add columns in Excel

Help StudioX
,
1

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

2

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

3

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?

image
image687×806 23.3 KB

Regards,

4

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