PyFCM does not run

[OddurBjarnason99]

I am very interested in using PyFCM to process excel files from Mental Modeler but I have not succeeded to get it to run in spite of many attempts. The following comments describe my experience:

xlrd is obsolete and does not open xlsx.
I have replaced it with openpyxl.
workbook = op.load_workbook(file_location) seems to work when I use the absolute path.

Shall I use the file name or the absolute path to Adjacency_Matrix_Example.xlsx?

sheet = workbook.sheet_by_index(0) does not work and I get the following error message:
Traceback (most recent call last):
File "C:\Users\Lazarus\PycharmProjects\PyFCM-master\Codes\Scenario_Analysis\Scenario_Analysis.py", line 27, in
sheet = workbook.sheet_by_index(0)
AttributeError: 'Workbook' object has no attribute 'sheet_by_index'
"sheet by index" probably has to be changed after changing to openpyxl.

I should be very grateful if you could help me with this problem.

Oddur Bjarnason
oddur.bjarnason@gmail.com