Excel to SU ( 29/7/08 version )

coulteri

Hello,
here are some examples:
attachment No1 is small example of terrain data (only 25 boxes). No2 is table with coordinates of border points of these boxes. No3 is example of what I would like to reach.

Thanks. C.

1

2.xls

3.skp

deanwilliams

Hi Oscar,

Thanks for uploading this Ruby!

I can see great potential with it in architecture. I have been looking for a script that will allow me to take data (say the area of part of a building in square meters) from an excel sheet and translate it to a circle of the same area in Sketchup.

Your ruby loads in sketchup but it only opens excel. Would you be able to tell me how to make the ruby open the actual spreadsheet?

Thanks,

Dean

AtlJimK

Oscar,

Thanks for setting this up. I have tried to edit your original SS to my needs but I somehow think you have the script tied to the specific cell addresses (i.e. Row 12, Column Q). I would like to create my own list but each time I mod the original SS it ceases working. It also does not read the count of the items and just places three of each in the scene.

AtlJimK

Can someone help with this script? We could use this for architectural programming tasks. Thanks in advance.

Dan Rathbun

@atljimk said:

Can someone help with this script? We could use this for architectural programming tasks. Thanks in advance.

Who is "we" ??

AtlJimK

@dan rathbun said:

Who is "we" ??

The "proverbial" we, meaning anyone who uses SketchUp in a programming environment.

AtlJimK

Is there a programmer who would be interested in further development of this type of capability? My company would be willing to pay for this work. If you are interested please PM me with your contact info. TFL.

TIG

Accessing an xls file via Ruby IS possible on a PC using other .so's etc.
However, to be cross-platform and quick/easy to use why not make the xls data as a csv or tsv file [or even a txt format] - all easily made formats from Excel. Then import the text data from that file by reading it in Ruby. The csv/tsv formats also open in Excel by default too.
There are many scripts already that will both read and write csv/tsv files.
For example importing 'clouds' of points in a csv to using in making a mesh, or writing out tabulated component data for cutting lists etc...
If you have a specific requirement feel free to PM me with more details of how you see this working for your office - I often do this kind of thing...

Dan Rathbun

@deanwilliams said:

Would you be able to tell me how to make the ruby open the actual spreadsheet?

if you have ".xls" associated with excel.exe, then on PC, do this:

UI.openURL("C:/some/path/to/spreadsheet.xls")

If you wish more integration, you can use OLE calls (requires the Win32OLE.so library file.)
see:Windows Automation
and Microsoft Windows Support

rivingregend

Hi Oscar Lok

I was really interested in your ex2sk ruby when I found it recently . I downloaded it from your post and got it to work and it's really good good. It is exactly what I was looking for.

I actually wanted to be able to edit it a little bit but I think it's in rbs format at the moment. Would it be possible to get the rb version of this script so I could play around with it?

Thanks

Joe