# Excel reading data into a datatable

**URL:** <https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729>\
**Category:** Help\
**Tags:** excel, activities\
**Created:** [August 24, 2018, 9:21am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729 "2018-08-24T09:21:14Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![kalyanDev](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kalyandev/32/68715_2.png) [@kalyanDev](https://forum.uipath.com/u/kalyanDev)\
**Post date:** [August 24, 2018, 9:21am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/1 "2018-08-24T09:21:14Z")

</div>

Hi all,

```
   when we are reading the excel file(that excel file is having background colors) i am able to store the data only into the data table i am not getting cell colors while we are using the read range.

```

---

<div class="post-metadata">

**Author:** ![Manjuts90](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/manjuts90/32/176617_2.png) [@Manjuts90](https://forum.uipath.com/u/Manjuts90)\
**Post date:** [August 24, 2018, 9:24am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/2 "2018-08-24T09:24:43Z")

</div>

@kalyanDev u wont get cell color in read range activity.

---

<div class="post-metadata">

**Author:** ![kalyanDev](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kalyandev/32/68715_2.png) [@kalyanDev](https://forum.uipath.com/u/kalyanDev)\
**Post date:** [August 24, 2018, 9:28am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/3 "2018-08-24T09:28:06Z")

</div>

thanks @Manjuts90  
yes…

---

<div class="post-metadata">

**Author:** ![quihan](https://avatars.discourse-cdn.com/v4/letter/q/c37758/32.png) [@quihan](https://forum.uipath.com/u/quihan)\
**Post date:** [August 24, 2018, 9:29am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/4 "2018-08-24T09:29:23Z")

</div>

Hi @kalyanDev, if you want to get cell color, you have to use **Get Cell Color** activity.

---

<div class="post-metadata">

**Author:** ![kalyanDev](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kalyandev/32/68715_2.png) [@kalyanDev](https://forum.uipath.com/u/kalyanDev)\
**Post date:** [August 24, 2018, 9:31am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/5 "2018-08-24T09:31:09Z")

</div>

hi @quihan, i just want to get cell color in read range while reading excel it self i need to get…

---

<div class="post-metadata">

**Author:** ![quihan](https://avatars.discourse-cdn.com/v4/letter/q/c37758/32.png) [@quihan](https://forum.uipath.com/u/quihan)\
**Post date:** [August 24, 2018, 9:32am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/6 "2018-08-24T09:32:33Z")

</div>

There is no such built in activity for now.

---

<div class="post-metadata">

**Author:** ![kalyanDev](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kalyandev/32/68715_2.png) [@kalyanDev](https://forum.uipath.com/u/kalyanDev)\
**Post date:** [August 24, 2018, 9:33am UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/7 "2018-08-24T09:33:57Z")

</div>

is there any way to achieve this…

---

<div class="post-metadata">

**Author:** ![quihan](https://avatars.discourse-cdn.com/v4/letter/q/c37758/32.png) [@quihan](https://forum.uipath.com/u/quihan)\
**Post date:** [August 24, 2018, 10:18pm UTC](https://forum.uipath.com/t/excel-reading-data-into-a-datatable/61729/8 "2018-08-24T22:18:20Z")

</div>

Hi @kalyanDev, I guess the only way is to loop through each cells, use **Get Cell Color** activity and store the color value in your datatable.