Python recipe Excel packages

User · March 2022

Hello everyone,

I have an issue while constructing excel with python recipe.
I need to use precise packages (xlsxwriter, xlwings, openpyxl and so on) that work very well in Anaconda.But in Dataiku python recipe it's not the case.
In my mind with python recipe I could do whatever python usually does.

Ex below of a line that does not work:

XlwingsError: Your platform only supports the instantiation via xw.Book(json=...)

Does anyone have a solution please ?

Thank you!

Best regards

Sergey · March 2022

Hi @User

You can indeed do anything you want in python recipes as far as python itself supports this. Here the question is that xlwings natively supports only Windows and Mac OS:

https://docs.xlwings.org/en/stable/installation.html#id2

https://github.com/xlwings/xlwings/blob/e172dfba3f2216e5885892f9653c636165332973/xlwings/main.py#L4934-L4953

    @property
    def impl(self):
        if engines.active is None:
            if not (
                sys.platform.startswith("darwin") or sys.platform.startswith("win")
            ):
                raise XlwingsError(
                    "Your platform only supports the "
                    "instantiation via xw.Book(json=...)"
                )
            elif sys.platform.startswith("darwin"):
                raise XlwingsError(
                    'Make sure to have "appscript" and "psutil", '
                    "dependencies of xlwings, installed."
                )
            elif sys.platform.startswith("win"):
                raise XlwingsError(
                    'Make sure to have "pywin32", a dependency of xlwings, installed.'
                )
        return engines.active.apps.impl

That's why the error related to the platform (OS).

User · March 2022

Hello @sergeyd
,

Thank you for the answer !

So actually DataIku runs on a Linux system ? I supposed it was windows but from your message I understand it is not the case.. Any way to fix it ? I've many python code I wanted to apply in recipes but I cannot.

Thank you