How to Read and Write .txt or .xls files in Grasshopper?

Who knows how to Read and Write *.txt or *.xls files in Grasshopper?
It will be great help for me to link with other database.
Since there are lot of software which can do data analysis more easily.
Thank you~

Tags: database, external, file, input, output, read, txt, write, xls

▶ Reply to This

Replies to This Discussion

Permalink Reply by Bojan Mitrovic on July 6, 2009 at 7:02am

You can try in VB code with System.IO.File, like this:

system.IO.File.WriteAllText("c:\text.txt", "text")

This code write word text in file text.txt on disk c.

▶ Reply

Permalink Reply by Damien Alomar on July 6, 2009 at 12:09pm

This is from a while back, but you can correct directly to excel from within GH. I'm not sure the extent to which you could read xls files without running excel.

http://liquidtectonics.blogspot.com/search/label/Excel

Reading in a csv file wouldn't really be much different in GH than parsing it within dotNet, so all of the dotNet classes you would use would be the same.

▶ Reply

Permalink Reply by Victor Leung on January 5, 2011 at 11:30pm

With the newer version of GH (I'm using 0.8.0004), streaming data with the yellow text box is easy. I write tabular data to a csv by concancate then strings with commas.