Grashopper file read and write without opening the file in Excel


#1

I have a grasshopper definition which writes and read from excel. So far I have used in a way when the file was opened in Excel. Is it possible to access an excel file without opening it in Excel?


#2

Did you try it?


#3

No I have not. In theory is it possible? I thought excel interoperalitiby works only when Excel is runnning.


#4

Test it yourself and let us know. Seriously, it would take less time to do that than posting the question on the forum.


#5

I would test if I knew how to do that.


(David Rutten) #6

If you can output your data as comma-separated-value, then yes. Grasshopper can read text data from files.

I do believe there’s a plugin for Excel interop, but I do not know which one or how it works.


#7

Thanks David,
I know that t works with normal .txt files. I am asking about .xlxs file and I want to write file too, so that it remains a normal excel file can be read by anyone. And again I want to write it WITHOUT being open in excel.


#8

Try running your tested GH file without opening Excel? What’s the mystery? I can’t help and will say no more.


#9

Of course nothing happens. :slight_smile:


#10

Actually maybe I have found a workaround. There is soultion for this called Leafcutter.