How to import openpyxl module into Sikuli - not possible (C-based)

Asked by MPE on 2017-07-02

----------------- workaround

Since openpyxl depends on numpy and pandas it cannot be imported in Jython based environments (numpy and padas are not available here).

use the alternative packages according to
http://www.python-excel.org

----------------------------------------------------------------------

I would like to use the openpyxl module in Sikuli to process sheet-data into a web-application. I just can't seem to find a good way to import it into Sikuli.

What are the steps and prerequisites needed to import openpyxl into a sikuli script?

Many thanks in advance!

MPE

Question information

Language:
English Edit question
Status:
Solved
For:
Sikuli Edit question
Assignee:
No assignee Edit question
Solved by:
MPE
Solved:
2017-07-03
Last query:
2017-07-03
Last reply:
2017-07-03
RaiMan (raimund-hocke) said : #1

Modules to be imported in SikuliX environment (Jython/Java based) must be Python code only.

If any parts are C-based, import will not work.

In this case you have to look for other appropriate modules.

In your case this might be helpful:
faq 2208

MPE (maartenpelgrim) said : #2

Hi Raiman,

Many thanks for the answer.

Do you mean to say that I can't import openpyxl into sikuli?

RaiMan (raimund-hocke) said : #3

see the edit in the question.

MPE (maartenpelgrim) said : #4

Hi Raiman,

I decided to use the xlrd and xlwt modules, which do exactly what I need. Thanks putting me on the right track!