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 Firat Aydin on August 17, 2012 at 11:16pm

Hi Peter;

Can you send me the component if possible?

It look likes your U-Clamp work outs by the way, ha?

Thanks

Permalink Reply by Xiaoming Yang on August 20, 2012 at 6:32am

Hi everyone,

Just some updates of the excelReadWrite components. I just recompiled it with Grasshopper 0.9 and update some of the demo files. Also tried to fix the language bug in the previous version. Please let me know if anything strange happens.

Attachments:

ExcelReadWrite.zip, 167 KB

Permalink Reply by Davide Mariani on March 8, 2013 at 3:37am

Thanks Xiaoming! I will use this component in my thesis and I will quote you in the final credits.

Permalink Reply by Xiaoming Yang on March 8, 2013 at 4:42am

I am very glad to know it helps:)

Permalink Reply by Francesco De Luca on April 7, 2013 at 1:27pm

Hello,

thank you for the tools. I am getting problems to make it work. I use Rhino 4 so I installed the relative (3) .gha files. Do I have to install also the excelreadwrite.gha? I use Office 2010. I attach an image if it can be useful. Thank you.

Francesco

Permalink Reply by Xiaoming Yang on April 7, 2013 at 1:50pm

Hi Francesco,

I think it is because gHowl is accessing the excel process and the excelWrite component is denied from accessing it(even for different file names). To confirm this, could you check two things?

(1) Try the demo file for the excelWrite component. If it works, then it suggest that the problem could be a compatible issue with gHowl excel function.(Please make sure all excel process has been killed before running the component)

(2) If the error occurs for the demo file, please check the error message for the the excelWrite component and let me know.

Xiaoming

Permalink Reply by Francesco De Luca on April 7, 2013 at 5:01pm

Hello Xiaoming,

thank you for the fast reply. Both the way you say didn't work. I deleted the gHowl component and I turned off and on again the GhExcel Write but I have the same problem and also the demo file don't work I already tried that to understnad. I attach a new image (sorry the bad quality it's a photo of the screen). Hope you can help.

Best.

Francesco

Permalink Reply by Xiaoming Yang on April 8, 2013 at 2:52am

Hi Francesco,

Thank you for your feedback. I think I found the problem. I actually updated the component after the initial post. Can you try to download the updated components from my post on August 20th last year? Just on this page. I should update the initial post as well. Sorry for the confusion.

Xiaoming

Permalink Reply by Francesco De Luca on April 8, 2013 at 3:14am

Thank you Xiaoming,

I am going to try right away. Are these components for Rhino 4? In the archive I see just one kind each component, previously I dowmloaded two versions one for 4 the other for 5.

Francesco

Permalink Reply by Xiaoming Yang on April 8, 2013 at 3:29am

Yes, it should work. Just tried it on my Rhino 4. Different versions has made this post confusing. I will recompile it in the next few days and upload it to food4rhino website.

Xiaoming

Permalink Reply by Francesco De Luca on April 8, 2013 at 3:42am

Xiaoming I have a quick question, in the ExcekWriting Recording Demo mode I got a spreadsheet with 3 columns, and that's ok it comes from the 3 branches, but there is a reason why I got 20 rows moving the slider? They could be less or more? Actually I have data coming from changing values of a slider but defininig 10 configuration and I want to stream the 10 configuration data on 10 different sheet of the same file (i guess it is possible with your tool). I need to associate a different sheet number from 1 to 10 to each configuration and input it the Sheet input right? Thank you.

Francesco

Permalink Reply by Xiaoming Yang on April 8, 2013 at 10:07am

Hi Francesco,

For the 20 rows, I guess you use animation of a slider which has default 20 frames. That leads to 20 values and thus 20 rows are recorded. If you check the recording, click connect and manually change the slider (or use counter from Kangaroo), any rows of data could be recorded.

Unfortunately it is not possible to record data simultaneously to different sheets right now. Sheet input only accept one integer. But I think it is very useful function to be added (which will take some time). For a temporary solution, I guess you can entwine all your configurations to one datatree and record in the same sheet. Then you can manually paste data to different sheets accordingly.

It is also possible to use multiple excelWrite components and write each of your configuration to a different file. But it will consume quite some system resources (10 excel running).

Xiaoming