Grasshopper

algorithmic modeling for Rhino

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. 

Views: 31362

Attachments:

Replies to This Discussion

Hello again Xiaoming,

yes now it is working. I tested your demo file. I will work on my project and let you know. Thank you.

Best

Francesco

Hi Francesco,

I just updated the GhExcel component. It supports multiple sheets read and write now. Unfortunately I cannot test it on Rhino 4 so I am not sure about the compatibility. You can find it at http://www.food4rhino.com/project/ghexcel. Hope it may help you.

Xiaoming   

We use OpenXMLSDK and therefore never actually access any excel functions.

Yes, just realized that. Sorry for the mistake. When I started to develop this component, I did not know about this SDK. To implement some interactive functions, interface Microsoft.Office.Interop.Excel is used for these components.

Xiaoming

Hi, I like your plugin and I would like to ask whether Openoffice could work this way. Currently I am looking for a plugin that connects Oo spreadsheets with GH. 

Hi, I think it should work. I am not familiar with the sdk for openoffice, but you may need to find event handlers equivalent to sheetActivate, sheetChange in office sdk. 

Hi,

Nice component.

 

Is it possible just get one column of a sheet? FX. A:A with only all the cells with data in?

 

Lars

 

 

Hi,

Right now it is not possible to select one column. I think you could work around it such as use a range able to cover all your data (a1:a200), and then filter out the null items in the result.

Xiaoming

Hello Xiaoming,

Thanks a lot for your plugin, is great. 

I am having a problem with the dynamic reading, some time reads the data in a dynamic way following every change, however some times stop working or refreshing. I do not know if there is a refreshing time limit or something that I can change, or if is it possible to use a button to force the refreshment?

Thanks a lot for any idea!

Best.

Hello Xiaoming,

I have seen many plugins / grasshopper components come out since this one, and this one is still simple and easy to use and understand, so first off, thanks for this excellent piece of development.  I was curious though if it is possible to run two instances of the excel dynamic read component.  I looked in your short manual pdf and it says to take note that excel static read and excel dynamic read cannot be used at the same time.  

At first, i tried to input a multi column, multi row range (for example: A1:C3)

but i have since come to understand that an instance of the excel dynamic read component seems only to be handle columns OR rows.  (A1:A3 OR A1:C1)

My question is, is it possible to input multi row data, AND multi column data in the same dynamic read component without having to remap tree values?  Alternatively, is it possible to use two dynamic read components at the same time even though you cant mix static and dynamic components (one for all row data, and one for all column data)?

HI Douglas,

Thank you for the feedback. I have to admit I have not looked at this plugin for almost two years.... I don't remember the reason why it does not work for a range. The graphic control works for a range. Strage. I will get back to you in a day or two. Need to read the code and understand what is happening there. 

HI Douglas,

I looked into the problem you mentioned. Actually you can input a list of columns to each excel sheet. Just a list of columns:

Or I just wrote a script to convert a range to list of columns. Please let me know whether this works for you.

Attachments:

RSS

About

Translate

Search

Photos

  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2024   Created by Scott Davidson.   Powered by

Badges  |  Report an Issue  |  Terms of Service