Opening a Spefic Excel's Sheet using RobotFramework

Robot Framework
1

Hello Everyone :smile:

I have installed Robotframework, PyCharm, Intellibot, Selenium using PIP3 on a MAC, no problems. I have installed ExcelLibrary and Collections as well.

Now my excel file contains 3 sheets, and I am trying to open this Excel and returning the number of rows for each sheet which include that I have to navigate between the excel’s sheets and I am unable to do it.

Does anyone please know how to do it ?

Thanks :smile:

Lamia

2

Hi @Lamiamrad,

I do not know Excel library, but I had some success with RPA.Excel.Files library. See library documentation here: https://rpaframework.org/libraries/excel_files/

I believe, the second example on that page should be similar to your use case.

Regards,
Markus

2 Likes
3

Thanks a lot it was very helpful :smiley:

1 Like