Insert multiple column in Excel

Help Activities
, ,
1

Hi

I want to insert 10 column with some same format some different,
so i have add a array of string

arrCol={“A1;Name;Total Fruits;NoFormat”,“B1;Mango;Total Fruits;NoFormat”,“C1;Apple;Total Fruits;NoFormat”,“O1;PineApple;Total Fruits;Date”,“P1;Total
Amt;Value;Currency”,“Q1;Broccoli;Total Fruits;NoFormat”,“R1;Tomato;Total Fruits;NoFormat”,“S1;Carrot;Total Fruits;NoFormat”,“T1;Beets;Total Fruits;NoFormat”}

with A1- insert column at
Name- Column Name
Total Fruits - Column Before
NoFormat - Format if any

I have split the array with “;” as dividers

However the Insert column is not working

here is the snap of insert column

image
image1249×436 28.4 KB

2

@quick_123

If it has headers then you need to check that box which says has headers

Cheers

3

I tried with Headers checked,Still didn’t work

4

@quick_123

When you say did not work…did it throw error? If so what is it?

Can you show the file here

Cheers

5

test.xlsx (17.5 KB)
Sample excel

6

@quick_123

did a test and working as expected

can you check the name of the column may be it is passed wrong

image

image
image918×245 4.14 KB

cheers

7

but when have to insert multiple column
arrCol={“A1;Name;Total Fruits;NoFormat”,“B1;Mango;Total Fruits;NoFormat”,“C1;Apple;Total Fruits;NoFormat”,“O1;PineApple;Total Fruits;Date”,“P1;Total
Amt;Value;Currency”,“Q1;Broccoli;Total Fruits;NoFormat”,“R1;Tomato;Total Fruits;NoFormat”,“S1;Carrot;Total Fruits;NoFormat”,“T1;Beets;Total Fruits;NoFormat”}

it is not working

8

@quick_123

Print the values you are trying to use a then see if it is matching or not

Cheers