Add the column in to data table

Help
,
1

Hi , i am trying to add the specific column to another excel sheet ,which is having already data columns in that.please help me
thanks in advance

2

Your trying to pass one whole column to another excel sheet?

3

Use add data column activity

4

yes vishal.kp

5

But its only creating a empty column. i need to append every time specific data column

6

You can first take that entire column into a datatable as mentioned below. Then write that data table which contains the column to the required excel.

Dt=dt.DefaultView.ToTable(false,“columnname”)

1 Like
7

test
test1482Ă—517 32.3 KB

Or use read column to add to other sheet

8

In excel1-Column1, Column2,Column3,Column4
In excel2-Column1,Column2
Now i need to add the column 4 from excel1 into column3 in excel 2(As last column)

9

yes you can write to the specified column in the write range activity after you take the column you want to paste.

10

But i dont want to specify the Column range in write range , because every day i want add the column as last column

11

then you can specify in the index as (datatablename.columns.count+1).

12

Okay vishal, Can you please help me that where should I specify the index

13

to extract the data column you can use assign activity and put datacolumnvariable=datatablename.columns(“columnName”)
then use the add data table column activity and pass the data column variable as input .:slight_smile:

1 Like
14

Thank for your rply vishal, i tried as u instructed, but it replace with old data.i want old data column and new data column