Import xlsxwriter module in Python Script

Developers
1

Hi everyone,

I’m trying to import the xlsxwriter module (which I successfuly installed in ironpython 2.7 through the command prompt) in a Python script within Dynamo.

I already looked at the workaround to set the path in the code, but still I get the warning saying there is “no module named xlsxwriter”.

can anyone help me understand what is my mistake? attached here is proof of what I’m struggling with, Thanks!

(as soon as I make this work I will make the script available… it would allow to format excel files as we want, merge cells, controlling headnotes and footnotes as well)

jpeg.jpg821×1055 224 KB

2

Hi,

It seems that “Xlsxwriter Python Module” is not installed. Have a look at some of the links on how to install Python modules. Hope it helps!

https://ironpython-test.readthedocs.io/en/latest/install/index.html

3

That’s a cPython package and it will most likely not work with Dynamo’s ironPython implementation.

As an alternative, have you tried The Bumblebee package?
https://konradsobon.gitbooks.io/bumblebee-primer/content/

You’ll also need to add the full path to the module - “C:\Program Files (x86)\IronPython 2.7\Lib\site-packages”

4

@Dimitar_Venkov +1 :+1: