# Get value from excel

**URL:** <https://forum.uipath.com/t/get-value-from-excel/162850>\
**Category:** Help\
**Tags:** excel, system, activities\
**Created:** [October 27, 2019, 10:22am UTC](https://forum.uipath.com/t/get-value-from-excel/162850 "2019-10-27T10:22:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ananya1](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ananya1](https://forum.uipath.com/u/Ananya1)\
**Post date:** [October 27, 2019, 10:22am UTC](https://forum.uipath.com/t/get-value-from-excel/162850/1 "2019-10-27T10:22:18Z")

</div>

i have particular column in excel sheet.

i want value from that column for every row and that value i have to use in application.

---

<div class="post-metadata">

**Author:** ![AshwinS2](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ashwins2/32/176686_2.png) [@AshwinS2](https://forum.uipath.com/u/AshwinS2)\
**Post date:** [October 27, 2019, 10:33am UTC](https://forum.uipath.com/t/get-value-from-excel/162850/2 "2019-10-27T10:33:22Z")

</div>

Hi @Ananya1  
use for each loop in datatable

row(“ColumnName”).ToString

Thanks  
ashwin S

---

<div class="post-metadata">

**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\
**Post date:** [October 27, 2019, 1:40pm UTC](https://forum.uipath.com/t/get-value-from-excel/162850/3 "2019-10-27T13:40:26Z")

</div>

Fine  
Hope these steps would help you  
—use excel application scope and pass the file path as input  
—inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt  
—then use a FOR EACH ROW activity and pass the above variable dt as input  
—inside the loop use a assign activity like this  
**str\_input = row(“yourcolumnname”).ToString**  
—now use OPEN BROWSER activity and mention the url of the web page we want to process this input  
—then inside that we can use this string variable

Cheers @Ananya1

---

<div class="post-metadata">

**Author:** ![lakshman](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/lakshman/32/523490_2.png) [@lakshman](https://forum.uipath.com/u/lakshman)\
**Post date:** [October 27, 2019, 4:58pm UTC](https://forum.uipath.com/t/get-value-from-excel/162850/4 "2019-10-27T16:58:10Z")

</div>

@Ananya1

You can try below expression to read values from particular column.

```
  columnDT = yourDT.DefaultView.ToTable(False,"ColumnName").CopyToDataTable

```

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [October 30, 2019, 4:58pm UTC](https://forum.uipath.com/t/get-value-from-excel/162850/5 "2019-10-30T16:58:16Z")

</div>

Closed on October 30, 2019, 4:58pm UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.