Downloads:
GH.OpenOfficeCXN for GH 0.6.0043
GH.OpenOfficeCXN for GH 0.6.0019
These scripts were written to connect from Grasshopper and OpenOffice Calc, a spreadsheet program very similar to Microsoft Excel. The definition will read and write OpenOffice Calc AND Microsoft Excel Files.
The biggest difference between the two is that OpenOffice is open source and free to download and use. This makes it much easier for us to implement spreadsheet based parameterization with clients and students because everyone has access to download and install OpenOffice. These are early versions of the processes. If there are any issues, please email code@livearchitecture.net. To make this run, please download and instal the latest OpenOffice.org 3.1.
Sarah Neault
Hi, I did your workshop in Boston and it was great, thanks!
and thanks so much for these definitions
is it possible to add to an OOo calc file?
here’s my plan:
import points from an xml file (i’ve got this figured out)
monitor that set of points for change ie new set of points being read in (also cool, return boolean)
if the points change
then
read the OOo file, add the new points to the list just read, write to the OOo file
and repeat
i tried mashing your two scripts together (read and write), but it just locks the file.
i’ve posted the question and hopper def on our blog here: http://annexlab.posterous.com/read-and-write-add-to-an-ooo-calc-file-via-gr
cheers!
Jun 01, 2010 @ 3:32 am
Sarah Neault
i got it working! you can download “fun with gps.ghx” on our blog here:
http://bohmlab.posterous.com/working-readwrite-to-ooo-in-hopper
it includes a vb script which reads an OOo file, compares the data it to the lists coming in (GPS info from from an .xml file) and, if it’s new, adds (writes) the new data to the same OOo file.
i’m new, so please excuse the messy/inefficient scripts!
Jun 03, 2010 @ 5:58 am