# Subject: Issue with Retrieving Data from Specific Excel Cell in Robot Framework

**URL:** <https://forum.robotframework.org/t/subject-issue-with-retrieving-data-from-specific-excel-cell-in-robot-framework/6798>\
**Category:** Robot Framework\
**Created:** [8 February 2024 02:39 UTC](https://forum.robotframework.org/t/subject-issue-with-retrieving-data-from-specific-excel-cell-in-robot-framework/6798 "2024-02-08T02:39:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Javed](https://avatars.discourse-cdn.com/v4/letter/j/73ab20/32.png) [@Javed](https://forum.robotframework.org/u/Javed)\
**Post date:** [8 February 2024 02:39 UTC](https://forum.robotframework.org/t/subject-issue-with-retrieving-data-from-specific-excel-cell-in-robot-framework/6798/1 "2024-02-08T02:39:08Z")

</div>

Hi Everyone,

I’m encountering an issue in Robot Framework where I need to retrieve data from a specific cell in an Excel file, for example, cell G5. However, I’m facing difficulties as the keywords I use for Excel manipulation are throwing errors as “undefined keyword”. I’ve installed the necessary Excel library and dependencies. If anyone has encountered a similar issue and knows how to resolve it, I would greatly appreciate your assistance. Thank you in advance.

---

<div class="post-metadata">

**Author:** ![damies13](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robotframework.org/damies13/32/623_2.png) [@damies13](https://forum.robotframework.org/u/damies13)\
**Post date:** [8 February 2024 05:40 UTC](https://forum.robotframework.org/t/subject-issue-with-retrieving-data-from-specific-excel-cell-in-robot-framework/6798/2 "2024-02-08T05:40:32Z")

</div>

Hi Javed,

Which specific Library are you using for reading Excel? (there is more than one)

What does the line you read the cell look like? (if you have a syntax error we might then be tell you what that is.

What is the error you got?most of the time the solution can be found in the error message.

Unfortunately you haven’t given enough information for anyone to even guess what your issue is.

Dave.

---

<div class="post-metadata">

**Author:** ![Javed](https://avatars.discourse-cdn.com/v4/letter/j/73ab20/32.png) [@Javed](https://forum.robotframework.org/u/Javed)\
**Post date:** [9 February 2024 07:44 UTC](https://forum.robotframework.org/t/subject-issue-with-retrieving-data-from-specific-excel-cell-in-robot-framework/6798/3 "2024-02-09T07:44:02Z")

</div>

Hi Dave ,

**Which specific Library are you using for reading Excel? (there is more than one)**  
I’m reading trying to read xlsx file  
What does the line you read the cell look like? (if you have a syntax error we might then be tell you what that is)  
${Username} Read Excel Cell 4 1  
Input Text ${usernamexpath} ${Username}  
error message ?  
am getting expections like noopeneddocumentsExceptions for this and file name , drivers, everything is proper.

If possible we both can sync and discuss and let me know the availability of your time. Thanks for responding. ☺

---

<div class="post-metadata">

**Author:** ![damies13](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robotframework.org/damies13/32/623_2.png) [@damies13](https://forum.robotframework.org/u/damies13)\
**Post date:** [9 February 2024 16:56 UTC](https://forum.robotframework.org/t/subject-issue-with-retrieving-data-from-specific-excel-cell-in-robot-framework/6798/4 "2024-02-09T16:56:35Z")

</div>

Hi Javid,

Although you didn’t show it, hopefully you followed the example in the [Read Excel Cell](https://rawgit.com/peterservice-rnd/robotframework-excellib/master/docs/ExcelLibrary.html#Read%20Excel%20Cell) documentation?

The error you’re getting indicates you haven’t got an excel file opened buy ExcelLibrary, did you use [Open Excel Document](https://rawgit.com/peterservice-rnd/robotframework-excellib/master/docs/ExcelLibrary.html#Open%20Excel%20Document) or [Create Excel Document](https://rawgit.com/peterservice-rnd/robotframework-excellib/master/docs/ExcelLibrary.html#Create%20Excel%20Document)?

Also don’t forget you shouldn’t have the file open in excel at the same time as ExcelLibrary is using it, and don’t forget to [Close Current Excel Document](https://rawgit.com/peterservice-rnd/robotframework-excellib/master/docs/ExcelLibrary.html#Close%20Current%20Excel%20Document) before exiting the test (or your file might remain locked)

> [@Javed](#):
>
> If possible we both can sync and discuss and let me know the availability of your time. Thanks for responding.

I won’t be able to connect as I’ll be traveling for the next few weeks, but will check in on this forum when I can get an internet connection.

Dave.