Components for Excel read and write

Hi Group,

Just want to share three component developed recently. One for read Excel file, one for read Excel file interactively and one for write data to Excel. Slightly improvement from previous post(http://www.grasshopper3d.com/forum/topics/a-gha-component-example-e...) and a new write component.

The excel components in gHowl works very well but I think for me I just like to have more control(for example: not overwrite the whole excel file when I use the write component).

The component has more functions(for example: it can record all the values in Excel when you change your slider, maybe it can even record all the results from Galapagos, haven't try this) but it also use more resources.

Please try these components and give your valuable advices.

I have compiled for both Rhino 4 and 5, you can try the components accordingly.

Attachments:

Excelhandler_shortManual.pdf, 103 KB
ExcelReadWrite.zip, 167 KB

Replies to This Discussion

Permalink Reply by Anabela Popovici on March 20, 2012 at 10:06am

Hello Xiaoming,

I am using office 2010...i also thought that was the problem, but apparently it isn't....

Thanks for the reply anyway...

Best regards,

Anabela

Permalink Reply by Xiaoming Yang on March 21, 2012 at 1:01am

Hi，

I tried office 2010, it seems to work on my computer. Please remember to close all excel processes before you used the component to connect to excel. Sometime when a excel process exist, there is error. This is bug I don't know how to fix:(

Xiaoming

Permalink Reply by Rémy Maurcot on February 5, 2012 at 2:22pm

Xiaming (me Remy),

it's possible to add a recomput solution GH when if a excel data file changing.

I am having problems reading when I stand in dynamic mode in a file.

Thanks

Permalink Reply by Rémy Maurcot on February 6, 2012 at 4:29am

Please read this post:

http://www.grasshopper3d.com/forum/topics/string-text?xg_source=act...

I've a problem with a decimal number.

Permalink Reply by Xiaoming Yang on February 6, 2012 at 5:39am

Hi,

I don't understand the problem. What is the problem with a decimal number? Can you post a gh file so I can try to solve it?

Permalink Reply by Rémy Maurcot on February 6, 2012 at 6:20am

On a simple example (yours) when I change a decimal number in excel there an error in grasshopper. If I recompite grasshopper, then the solution works again.
My setup windows 7 rhino grasshopper 0.8.0.0066 5 and Excel 2010

Permalink Reply by Rémy Maurcot on February 6, 2012 at 7:16am

http://www.grasshopper3d.com/forum/topics/string-text?page=1&co...

It's ok for me

Permalink Reply by Rémy Maurcot on February 6, 2012 at 6:50am

After various tests, it only happens on my Laptop config with the high-end (shit). I will see levels of options.

Permalink Reply by yahya ibraheem on June 11, 2012 at 8:09am

I've chose the special folder components and attached the rhino 4 file of excel write ,but it's not working ,the message i got is not supported by rhino series .... so can any one help how to connect excel to grasshopper please?

Permalink Reply by Firat Aydin on August 16, 2012 at 4:14am