Excel to Sketchup

Excel to Sketchup

Postby mgsvinc » Wed Mar 21, 2018 6:05 pm

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 ?
0

mgsvinc 
 

Re: Excel to Sketchup

Postby TIG » Wed Mar 21, 2018 9:24 pm

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...
1
TIG
User avatar
TIG 
Global Moderator
 

Re: Excel to Sketchup

Postby mgsvinc » Mon Mar 26, 2018 1:10 pm

Thank you tig i ll take a look at this and come back to you when i find the solution.
0

mgsvinc 
 

SketchUcation One-Liner Adverts

by Ad Machine » 5 minutes ago



Ad Machine 
Robot
 



 

Return to Dynamic Components

cron

Who is online

Users browsing this forum: No registered users and 1 guest

Visit our sponsors: