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

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 Remy (RMDeveloppements) on September 7, 2012 at 10:13am

I've testing your code but for list of text, the text used last column.

Please i need write a list of text on tree in the txt file.

• ▶ Reply

Permalink Reply by David Rutten on September 7, 2012 at 11:26am

You'll need to create a single string out of your list if you want to use IO.File.WriteAllText(). You can do this using a loop and a System.Text.StringBuilder for example.

If you specifically want to write to a file line by line, then you need to create a writer object that can send stuff to a file or memorystream.

http://www.dotnetperls.com/streamwriter

--

David Rutten

david@mcneel.com

Poprad, Slovakia

• ▶ Reply

Permalink Reply by ZHANG Yan - popabczhang on September 8, 2012 at 9:50pm

Thanks, David.

• ▶ 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.

• ▶ Reply