Get data from Excel file (CSV)

Hello,

How can I modify some properties of a Mill machine using an Excel file (or CSV)?

I thought of changing the Python Script of the component and taking the data from the external file, but I can not get to extract the data. Probably because my skills on Pyhton API are not that good. If anyone has had this issue and resolved it, please let me know how is the best solution. Thanks in advance.

2 Likes

I want to know this too

Hello

I used xlrd, xlwt libraries to model these examples below.

Property Updater

Resource Manager

Scenario Manager

Also these are the sources i used a lot while programing those AddOns:

http://www.programmersought.com/article/541827637/
https://programtalk.com/python-examples/xlwt./

and ofcourse stackoverflow…

Hi Ozan,
I was revisiting this post because now I need to modify Excel files instead of csv files now. I encountered a problem because apparently there is no xlwt module installed on the VC libraries files. I tried going looking for it to add it to the folder “site-packages” but I’ve had no success. Do you know where can I get the package files?
By the way, impressive work with those Add-ons they seem really helpful and a great tool. Congrats!