Fill data table from array

Learn Academy Feedback
, ,
1

Good afternoon!
I create array of string. It’s done. Now i should fill new data table from created array. It will be a column.
I add “Build Data Table” and name my column. But didn’t fill them:(

2

Hi @RPA3
Use add data column activity

Thanks
Ashwin S

3

Can you write step by step?
Because I try it, but didn’t result

4

Hi @RPA3
Use Read range activity

use for each item in strarray

use add data column and pass rthe value as item and datatable and use write range

Thanks
Ashwin S

5

What write in ReadRange inWorkBookPath?
I have only array

6

Hi @RPA3
Can you share your xaml

Thanks
Ashwin S

7

Can you write your email?

8

Hi @RPA3
ashwinsrini88@gmail.com

Thanks
Ashwin S

9

Hi @RPA3,

You mentioned you have an array of string, you could iterate thru the array and add the values:

  • For Each loop on the array (Of string type)

  • Within the loop use the Add Data Row activity and pass the array value into the datatable

Please see the attached xaml file as example.

BuildDtFromArray.xaml (7.1 KB)

Let me know how that goes!

Regards,
PD

10

Hi @RPA3
BuildDtFromArray.xaml (9.2 KB)
Check this

Thanks
Ashwin S

11

So I can. You need to assign each value to a separate variable and write it in a column in a table

12

So I can. You need to assign each value to a separate variable and write it in a column in a table