# Error while retrieving data from Excel

**URL:** <https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024>\
**Category:** Help\
**Tags:** question, excel, uiautomation, activities\
**Created:** [November 18, 2019, 11:36am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024 "2019-11-18T11:36:56Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 18, 2019, 11:36am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/1 "2019-11-18T11:36:56Z")

</div>

Hi All,

I am unable to retrieve the second data and so on from excel sheet and place it in website where as the first data is fetched and processed.

 ![image](https://global.discourse-cdn.com/uipath/original/3X/1/1/11ed7045188621d5fa2fe802fdedc034daadbf94.png)

If there’s a solution please let me know it as soon as possible.

---

<div class="post-metadata">

**Author:** ![sarathi125](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sarathi125/32/519448_2.png) [@sarathi125](https://forum.uipath.com/u/sarathi125)\
**Post date:** [November 18, 2019, 11:39am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/2 "2019-11-18T11:39:59Z")

</div>

@SOURAV_KUMAR_DAS,

How you are reading the data from this excel, and are you using any framework mechanism to process the data.

I recommend you to use RE Framework for Tabular data, which will handle move to the next record if first one is completed.  
[https://go.uipath.com/component/reframework-for-tabular-data](https://go.uipath.com/component/reframework-for-tabular-data)

---

<div class="post-metadata">

**Author:** ![Vashisht](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/vashisht/32/74082_2.png) [@Vashisht](https://forum.uipath.com/u/Vashisht)\
**Post date:** [November 18, 2019, 11:43am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/3 "2019-11-18T11:43:02Z")

</div>

Hi @SOURAV_KUMAR_DAS,  
Are you getting any error while processing?

Cheers.  
Vashisht.

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 18, 2019, 11:44am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/4 "2019-11-18T11:44:35Z")

</div>

Hi [Vashisht](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/3) Sir,

Yes Sir… I am getting error.

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 18, 2019, 11:45am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/5 "2019-11-18T11:45:02Z")

</div>

Hi [sarathi125](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/2) Sir,

No Sir…normal I am using

---

<div class="post-metadata">

**Author:** ![KarthikByggari](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/karthikbyggari/32/430060_2.png) [@KarthikByggari](https://forum.uipath.com/u/KarthikByggari)\
**Post date:** [November 18, 2019, 11:58am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/6 "2019-11-18T11:58:00Z")

</div>

What error you are getting?  
And also give more details how you are entering excel data into website!!!

Regards,  
Karthik Byggari

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 19, 2019, 6:00am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/8 "2019-11-19T06:00:38Z")

</div>

Hi [KarthikByggari](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/6) Sir,

Is there any solution let me know…

---

<div class="post-metadata">

**Author:** ![KarthikByggari](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/karthikbyggari/32/430060_2.png) [@KarthikByggari](https://forum.uipath.com/u/KarthikByggari)\
**Post date:** [November 19, 2019, 6:16am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/9 "2019-11-19T06:16:11Z")

</div>

Can you please elaborate your process. What you are trying to do?

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 19, 2019, 6:32am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/10 "2019-11-19T06:32:32Z")

</div>

Hi [KarthikByggari](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/9) Sir,

Can You share me your mail Id Sir…

---

<div class="post-metadata">

**Author:** ![KarthikByggari](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/karthikbyggari/32/430060_2.png) [@KarthikByggari](https://forum.uipath.com/u/KarthikByggari)\
**Post date:** [November 19, 2019, 6:33am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/11 "2019-11-19T06:33:56Z")

</div>

Check your inbox.

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 20, 2019, 7:20am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/12 "2019-11-20T07:20:29Z")

</div>

Hi Sir,

I have sent you a mail Sir.

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 20, 2019, 10:22am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/13 "2019-11-20T10:22:23Z")

</div>

Hi [KarthikByggari](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/11) Sir,

Is there any solution based upon my requirement and with sample Xaml files…

---

<div class="post-metadata">

**Author:** ![KarthikByggari](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/karthikbyggari/32/430060_2.png) [@KarthikByggari](https://forum.uipath.com/u/KarthikByggari)\
**Post date:** [November 20, 2019, 11:29am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/14 "2019-11-20T11:29:04Z")

</div>

I will check. I got busy with other important work. I will let you know soon.

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 20, 2019, 11:54am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/15 "2019-11-20T11:54:20Z")

</div>

Hi [KarthikByggari](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/14) Sir,

Ok Sir.

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 21, 2019, 11:28am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/16 "2019-11-21T11:28:02Z")

</div>

Hi [KarthikByggari](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/14) Sir,

Any progress…?

---

<div class="post-metadata">

**Author:** ![KarthikByggari](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/karthikbyggari/32/430060_2.png) [@KarthikByggari](https://forum.uipath.com/u/KarthikByggari)\
**Post date:** [November 21, 2019, 11:38am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/17 "2019-11-21T11:38:01Z")

</div>

I will check now and let you know.

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 21, 2019, 11:38am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/18 "2019-11-21T11:38:25Z")

</div>

Hi [KarthikByggari](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/17) Sir,

Ok Sir.

---

<div class="post-metadata">

**Author:** ![Deepak94](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/deepak94/32/112246_2.png) [@Deepak94](https://forum.uipath.com/u/Deepak94)\
**Post date:** [November 21, 2019, 11:53am UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/19 "2019-11-21T11:53:42Z")

</div>

HI @SOURAV_KUMAR_DAS,

I think you are using read range activity with range “A1” and “B1” and so on which makes it to read only one row.  
if you change it to “A1:A+“dtYourExcelRead.rows.count.ToString”” or “B1:B+”+dtYourExcelRead.rows.count.tostring+“” , you will be able to read all the rows.

you can also use Nothing to read all the columns at the same time.

Hope this will work for you.

Thanks!

---

<div class="post-metadata">

**Author:** ![SOURAV\_KUMAR\_DAS](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sourav_kumar_das/32/126111_2.png) [@SOURAV\_KUMAR\_DAS](https://forum.uipath.com/u/SOURAV_KUMAR_DAS)\
**Post date:** [November 21, 2019, 12:11pm UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/20 "2019-11-21T12:11:15Z")

</div>

Hi [Deepak94](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/19) Sir,

I can’t get it out your reply.

---

<div class="post-metadata">

**Author:** ![Deepak94](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/deepak94/32/112246_2.png) [@Deepak94](https://forum.uipath.com/u/Deepak94)\
**Post date:** [November 21, 2019, 12:19pm UTC](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024/21 "2019-11-21T12:19:00Z")

</div>

Hi @SOURAV_KUMAR_DAS  
Ok.  
Try to replace “A1” with “” and “B1” with “” and so on in read range activity.  
I know you are reading one column at a time but, above method should not make any impact on your current process.  
There is another way as well to read all the columns in single for each but you try above one and please let me know if its working or not.

Thanks!

[Next page](https://forum.uipath.com/t/error-while-retrieving-data-from-excel/169024.md?page=2)