# Data Table

**URL:** <https://forum.uipath.com/t/data-table/4109>\
**Category:** Help\
**Tags:** system, activities\
**Created:** [May 2, 2017, 6:15am UTC](https://forum.uipath.com/t/data-table/4109 "2017-05-02T06:15:44Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![shivamrana](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@shivamrana](https://forum.uipath.com/u/shivamrana)\
**Post date:** [May 2, 2017, 6:15am UTC](https://forum.uipath.com/t/data-table/4109/1 "2017-05-02T06:15:44Z")

</div>

I want to read row of dataTable and after every row it should give me a message . how to do that ? i was able to read the whole datatable but cannot able to show message after every row . i was able to show the whole data Table in the message box

---

<div class="post-metadata">

**Author:** ![Vinutha](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/vinutha/32/152013_2.png) [@Vinutha](https://forum.uipath.com/u/Vinutha)\
**Post date:** [May 2, 2017, 6:46am UTC](https://forum.uipath.com/t/data-table/4109/2 "2017-05-02T06:46:22Z")

</div>

you can use the activity ‘for each row’.

![](https://global.discourse-cdn.com/uipath/original/2X/c/c46a5121091edea5fda8900128502867170e8e1c.png)

---

<div class="post-metadata">

**Author:** ![jibanjyoti](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jibanjyoti/32/11129_2.png) [@jibanjyoti](https://forum.uipath.com/u/jibanjyoti)\
**Post date:** [May 2, 2017, 8:13am UTC](https://forum.uipath.com/t/data-table/4109/3 "2017-05-02T08:13:34Z")

</div>

Hi @shivamrana,  
I guess you are using the activity “Output Data Table” in order to see what is the data inside the data table. This activity will give the whole data in a single message box as string.  
If you want to iterate and see the values one by one then, as @Vinutha suggested you can use the for each row activity and inside that according to your need you can display a message box or write line activity.  
In order to enhance you can write this data one by one to any application if you keep your activity inside that for each row loop.  
Hope you are clear. 🙂

---

<div class="post-metadata">

**Author:** ![Nyx\_Green](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nyx_green/32/199705_2.png) [@Nyx\_Green](https://forum.uipath.com/u/Nyx_Green)\
**Post date:** [March 12, 2018, 9:17pm UTC](https://forum.uipath.com/t/data-table/4109/4 "2018-03-12T21:17:20Z")

</div>

Hi, I have used the above write line example to read just one row from my datatable. Yet my Output shows nothing.  
However when I state Get row Item - row and then the Write Line row.ToString it displays all of the rows.  
Could you please help me to identify just one row based on the row number in my datatable?  
I then need to find this specific row from the datatable in a web page and have tried Send Hotkey ctrl+f but that did not work either. Please can you help?

---

<div class="post-metadata">

**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\
**Post date:** [March 12, 2018, 9:48pm UTC](https://forum.uipath.com/t/data-table/4109/5 "2018-03-12T21:48:05Z")

</div>

Hi @Nyx_Green,  
Can you please attache your xml file to see. At @Vinutha , It has to show the each row values.

Regards  
Balamurugan.S

---

<div class="post-metadata">

**Author:** ![Nyx\_Green](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nyx_green/32/199705_2.png) [@Nyx\_Green](https://forum.uipath.com/u/Nyx_Green)\
**Post date:** [March 12, 2018, 10:18pm UTC](https://forum.uipath.com/t/data-table/4109/6 "2018-03-12T22:18:12Z")

</div>

[web.xaml](https://global.discourse-cdn.com/uipath/original/2X/4/402b2fd01985338beabe515f6e33f3d1e0b3ba6f.xaml) (10.5 KB)

here is the file as requested

---

<div class="post-metadata">

**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\
**Post date:** [March 12, 2018, 10:25pm UTC](https://forum.uipath.com/t/data-table/4109/7 "2018-03-12T22:25:08Z")

</div>

Hi,  
Here I have attached your file with correction.

File : [Data Table.zip](https://global.discourse-cdn.com/uipath/original/2X/7/7d289007baba3f705d8df873f9ddb7eed9326e6b.zip) (2.7 KB)

Regards  
Balamurugan.S

---

<div class="post-metadata">

**Author:** ![Nyx\_Green](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nyx_green/32/199705_2.png) [@Nyx\_Green](https://forum.uipath.com/u/Nyx_Green)\
**Post date:** [March 12, 2018, 10:35pm UTC](https://forum.uipath.com/t/data-table/4109/8 "2018-03-12T22:35:19Z")

</div>

Thank you @balupad14, I now have the column numbers. It still gives me all the rows in the output, instead of row 5 value only?

---

<div class="post-metadata">

**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\
**Post date:** [March 12, 2018, 10:57pm UTC](https://forum.uipath.com/t/data-table/4109/9 "2018-03-12T22:57:27Z")

</div>

Hi @Nyx_Green,  
To get 5 row value , you can use like dtbbproducts.Rows(4).ItemArray

Regards  
Balamurugan.S

---

<div class="post-metadata">

**Author:** ![Nyx\_Green](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nyx_green/32/199705_2.png) [@Nyx\_Green](https://forum.uipath.com/u/Nyx_Green)\
**Post date:** [March 13, 2018, 6:42am UTC](https://forum.uipath.com/t/data-table/4109/10 "2018-03-13T06:42:54Z")

</div>

Hi Bala

Where do I put in that value? New to UiPath Studio so still not so sure as where to put the “dtbbproducts.Rows(4).ItemArray”?

---

<div class="post-metadata">

**Author:** ![arivu96](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@arivu96](https://forum.uipath.com/u/arivu96)\
**Post date:** [March 13, 2018, 7:11am UTC](https://forum.uipath.com/t/data-table/4109/11 "2018-03-13T07:11:46Z")

</div>

> [@Nyx\_Green](#):
>
> dtbbproducts.Rows(4).ItemArray

this will return the 5th row value to **array string[]**

| S.No | Name |
| --- | --- |
| 1 | xxx |
| 2 | yyyy |
| 3 | sss |
| 4 | bbb |
| 5 | sdff |
| 6 | dfgg |

`String.Join(",",dtbbproducts.Rows(4).ItemArray)`  
it will return as **6,dfgg**

Regards.  
Arivu

---

<div class="post-metadata">

**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\
**Post date:** [March 13, 2018, 7:33am UTC](https://forum.uipath.com/t/data-table/4109/12 "2018-03-13T07:33:57Z")

</div>

Hi,  
Normally Row index starts from zero. At your sample project , It will display the “Fiber”.  
Here I have attached the modified one of you : [Data Table.zip](https://global.discourse-cdn.com/uipath/original/2X/9/9f8077ebded46197fed0e673045156cc4d13ac2a.zip) (2.8 KB)

Regards  
Balamrugan.S

---

<div class="post-metadata">

**Author:** ![Nyx\_Green](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nyx_green/32/199705_2.png) [@Nyx\_Green](https://forum.uipath.com/u/Nyx_Green)\
**Post date:** [March 13, 2018, 7:36am UTC](https://forum.uipath.com/t/data-table/4109/13 "2018-03-13T07:36:22Z")

</div>

Alrighty, so my output still showed the requested line and duplicated it. I then removed the for each row and it worked. My output only displays 1 row which is exactly what I wanted.

Thanks for all the help

[web.xaml](https://global.discourse-cdn.com/uipath/original/2X/4/402b2fd01985338beabe515f6e33f3d1e0b3ba6f.xaml) (10.5 KB)

---

<div class="post-metadata">

**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\
**Post date:** [March 13, 2018, 7:41am UTC](https://forum.uipath.com/t/data-table/4109/14 "2018-03-13T07:41:37Z")

</div>

Hi,  
The below one has to change…

![image](https://global.discourse-cdn.com/uipath/original/2X/2/26b4898f4e1f3cc97a6e6705e0c31d0e8641ebba.png)

The right one …  
 ![image](https://global.discourse-cdn.com/uipath/original/2X/6/6f776e7adfe4efcc7bd8d7f11af722d017e7e336.png)

In my previous post of sample file will get clear.

Regards  
Balamurugan.S

---

<div class="post-metadata">

**Author:** ![Nyx\_Green](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/nyx_green/32/199705_2.png) [@Nyx\_Green](https://forum.uipath.com/u/Nyx_Green)\
**Post date:** [March 13, 2018, 8:21am UTC](https://forum.uipath.com/t/data-table/4109/15 "2018-03-13T08:21:09Z")

</div>

Hi, thanks and adjusted accordingly:

[web.xaml](https://global.discourse-cdn.com/uipath/original/2X/7/7ba843cad3b59f1eedcf752a7c77a82e1ed916b0.xaml) (8.5 KB)

---

<div class="post-metadata">

**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\
**Post date:** [March 13, 2018, 8:34am UTC](https://forum.uipath.com/t/data-table/4109/16 "2018-03-13T08:34:51Z")

</div>

Nice 🙂

---

<div class="post-metadata">

**Author:** ![Maheshwar\_Matalwar](https://avatars.discourse-cdn.com/v4/letter/m/90db22/32.png) [@Maheshwar\_Matalwar](https://forum.uipath.com/u/Maheshwar_Matalwar)\
**Post date:** [May 24, 2018, 11:42am UTC](https://forum.uipath.com/t/data-table/4109/17 "2018-05-24T11:42:46Z")

</div>

how to dump excel file into database…[Main.xaml](https://global.discourse-cdn.com/uipath/original/3X/f/c/fc39daa23f913c0622e01cefac2aa955d9e53258.xaml) (9.6 KB)
