Problems with Data Table

Help
1

Hello,

I want that my automation reads a range, outputs a Data Table, converts it to a string and write it into another excel table. But when the cell gets written, instead of only writing the data table, it also writes “Colums 1”

2

@work_low

Check Add Headers option in both Read and Write Range activities.

3

@work_low,

If you are using Write Range Activity to write the values, then in that activity there is an option “Add Headers”, Uncheck that and try once.

4

@work_low,

What i understand from your question is.

Your able read excel and converts dataTable into a string and the converted string your copying to another dataTable…

Am i right?

Regards,
Anil

5

@sarathi125 @lakshman the add Headers option was never checked

6

right

7

Main.xaml (11.0 KB) here is my main

8

can you share your excel file?
why u are using those read range and output datatable?
If you want that cell value into a variable then u can use read cell and store that value into variable.

9

Data source table:Employee.xlsx (15.4 KB)
Table to fill in: http://badespeak.de/cloud/index.php/s/cMZPK7ACcZjnPrQ (cant upload the file here sorry)