Excel - GH_Python

Replies to This Discussion

Permalink Reply by Anders Holden Deleuran on September 16, 2013 at 3:04pm

Hi Rasmus,

While it is possible to interact dynamically with Excel using IronPython in Rhino, I personally prefer using the Python xlrd/xlwt modules. These are both fairly easy to implement and have the advantage of being cross-platform and compatible with Libre/Open Office as well. Hope that helps.

Best,

Anders

Permalink Reply by Rasmus Holst on September 17, 2013 at 4:34am

Hi Anders.

Yes I looked into the xlrd/xlwt modules, I just could not succed in installing them? If you have time and could make a short checklist or recipe, I would really appreciate that. I tried to follow the tutorials but I could'nt make it work.

Thanks.

Rasmus

 

Permalink Reply by Anders Holden Deleuran on September 17, 2013 at 11:05am

No problem. I have attached the xlrd/xlwt modules in a zip file.

To install the modules you simple  unzip and add them to a directory which is read by Rhino.Python. To check and modify these directories:

1) In Rhino type in the command "EditPythonScript".
2) In this Python editor go Tools -> Options -> Files.

Here you will see an overview of the directories which are currently used.

3) Add your own directory (I would recommend C:\RhinoPython).
4) Move the folders xlrd and xlwt to this directory.
5) To check that the install worked you can type this into the Python script editor:

import xlrd
import xlwt

If this does not throw any errors you should be good to go.

Attachments:

• ExcelModules.zip, 244 KB

Permalink Reply by Rasmus Holst on September 18, 2013 at 5:31am

Cool Anders. That worked like a charm.

Now I just need to figure out how it works. I guess I'll have to use some time with the manual. I have a a bit difficulties figuring out how to read from a specific file path.

 

Thanks for helping me out once again. I owe you a beer one day.

Rasmus

Permalink Reply by Anders Holden Deleuran on September 18, 2013 at 8:44am

You can use a Grasshopper File Path parameter to quickly reference a file as a string (note that the Excel file should be saved as .xls). See the attached files. No worries, I'll be sure to hold you to that when I'm back in Denmark ;)

Attachments:

• xlrdExample.gh, 7 KB
• xlrdExample.xls, 22 KB

Permalink Reply by Rasmus Holst on October 14, 2013 at 8:24am

Thanks.

Is it so that It is not possible to read .xlsm files? I don't seem to be able to do that.

Permalink Reply by Michal Dengusiak on November 15, 2013 at 3:18am

I just tested now and it works up to Excel 97-2003,

I would be also intersted to find out how to use it on Excel from version 2007? 

Permalink Reply by Anders Holden Deleuran on November 15, 2013 at 3:28am

While I haven't tried it myself, it does looks like the latest xlrd update supports .xlsx files (I believe this is the default Excel 2007 format). If not, you might want to check out this module instead..