Excel to Sketchup
-
Hello everyone,
I'm trying to do an automatisation from excel to sketchup.
To make it simple I have several objects that I want to positioned in sketchup.
The objects remain the same (there is no change of dimensions within those objects), the only values which I want to pilot from Excel are the positioning of these objects (and their copies).
In summary I try to send values from Excel cells towards a dynamic component and more exactly towards attributes of this dynamic component.
I do not know exactly where to begin, but I dare to hope that there is a plugin to do that (my searches gave nothing).
Anybody would have an idea or even a beginning of a track ?
-
You can [with some convolution] get Ruby to read an Excel file - at least in Windows ?
However, if you export your Excel data as an CSV file, it's then text - and that's much easier to read into Ruby, and then parse out the text into rows and the columns from the file, using the Comma as the separator...
There are several examples out there, for parsing CSV files into usable Ruby values.
Typical examples are those scripts which import XYZ values etc... -
Thank you tig i ll take a look at this and come back to you when i find the solution.
Advertisement