Robot Framework- How to read particular cell data in xlsx file

Question

I am new to Python and Robot framework and want to read particular cell data for automation. I have used `Library ExcelLibrary and used a command

 Read Cell Data By Coordinates    {Path to excel file}/test.xlsx    1    1

but error message appears i.e.

FAIL : AttributeError: 'NoneType' object has no attribute 'index'

Using this in ride robot framework. Please let me know if any other information required.

Can you post your Python and RF source code? Other tracecalls could be useful also. — ponkape
– ponkape, Commented Mar 8, 2018 at 11:37
It's seem your Keyword use not correctly . Please check instruction keyword ExcelLibrary navinet.github.io/robotframework-excellibrary/… — Sidara KEO
– Sidara KEO, Commented Mar 15, 2018 at 4:34

Sidara KEO · Accepted Answer · 2018-03-15 04:39:16Z

1

Anyway you can use below code if you want to read data from your xls file .

${data}    Read Cell Data By Name    Sheet1    A1

OR

${data}  Read Cell Data By Coordinates   Sheet1    1   1

Uses the column and row to return the data from that cell.

Arguments:

Sheet Name (string) The selected sheet that the cell value will be returned from. Column (int) The column integer value that the cell value will be returned from. Row (int) The row integer value that the cell value will be returned from.

answered Mar 15, 2018 at 4:39

Sidara KEO

1,6992 gold badges17 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Robot Framework- How to read particular cell data in xlsx file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related