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.

Permalink Reply by Rémy Maurcot 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.

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

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

Thanks, David.

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.

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.