Excel to SU ( 29/7/08 version )
-
@dan rathbun said:
Who is "we" ??
The "proverbial" we, meaning anyone who uses SketchUp in a programming environment.
-
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.
-
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... -
@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 -
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
Advertisement