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.

Tags: Excel, component, data, gha, recording

Attachments:

components.zip, 75 KB
Excelhandler_shortManual.pdf, 103 KB

▶ Reply to This

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

▶ Reply

Permalink Reply by Xiaoming 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

▶ Reply

Permalink Reply by RhinoBridges 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

▶ Reply

Permalink Reply by RhinoBridges 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.

▶ Reply

Permalink Reply by Xiaoming 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?

▶ Reply

Permalink Reply by RhinoBridges 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