Opening a Spefic Excel's Sheet using RobotFramework

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:


Hi @Lamiamrad,

I do not know Excel library, but I had some success with RPA.Excel.Files library. See library documentation here:

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



Thanks a lot it was very helpful :smiley:

1 Like