Add new column in excel with title on the top

[SyafiqKCS (Syafiq)]

Hi guys, would like to know how can I add a new column after the Currency , most of the video and question ask before only show table that have no title before the table. unlike mine i have a title on the top of the excel, thus my studiox cant recognize the column. i want to adda new column after currency. please be mind Im only able to use activites that can be done via StudioX

[mkankatala (Mahesh Kankatala)]

Hi @SyafiqKCS

You can use the Insert column activity to add the column in the Excel.
In the Where field dropdown make it to after in the Relative to column field give the column name that you want to add after with in double quotes.
In the Add header field give the new column name with in double quotes.

Check the below image for better understanding

Note - You have to use the Insert column activity inside the use Excel file activity.

Hope it helps!!

[rlgandu]

@SyafiqKCS

Use Insert column activity

[SyafiqKCS (Syafiq)]

I had try and type “Currency” using text but there is an error as below.
I attach along my excel in case any1 can help

EXCEL 1.xlsx (10.9 KB)

[Anil_G (Anil Gorthi)]

@SyafiqKCS

You can directly use write cell and write the required column name in the field you need

Or in insert column try giving the range like this Excel.Sheet("SheetName").Range("A5:H6")

cheers

[SyafiqKCS (Syafiq)]

@Anil_G

Or in insert column try giving the range like this Excel.Sheet("SheetName").Range("A5:H6")

thx i try your 2nd suggestion and it recognize the header and able to put the new column, tq so much