Adding Headers to existing datatable from header excel

Help Studio
, ,
1

hi i have a header file(xlsx) with all the headers into it and now i have another datatable with the data into into it . now i need to add the headers to the datatable which has a data into it. how can i acheive this in uipath

2

Hey @vishal_nachankar

You can just read the two data tables & Merge it !

Also read/write both without headers into a new Excel.

Thanks
#nK

3

it is not working i read the headers excel in dt1 and another dt2 which is csv file and tried to merge Dt1 and dt2 the columns of dt1 got added at the end of the final dt

4

When you say dt2 as csv is it tab separate or comma separated ?

Also, please share those files here if possible.

Thanks
#nK

5

it is | pipe seperated i cant share the files sorry

6

do you mean sth like this? do both files have same # of columns?
image

7

yes both files have same no columns

8

use this xaml as an example
basically you loop through headerDt.columns
in each iteration assign
dataDt.Columns(colIndex).ColumnName = col.ColumnName
image

test.xaml (9.5 KB)

Test file

image
image759×608 27.3 KB

headerFile.xlsx (8.2 KB)
dataFile.xlsx (8.3 KB)

Result (written to dataFileNew.xlsx)

image
image336×514 12.7 KB

9

You can please share a simulated sample files.

Thanks
#nK

10

thanks it works