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 Francesco De Luca on April 8, 2013 at 3:29am

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

Permalink Reply by Xiaoming Yang on May 11, 2013 at 2:26pm

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

Permalink Reply by Luis Fraguada on April 8, 2013 at 10:11am

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

Permalink Reply by Xiaoming Yang on April 8, 2013 at 2:30pm

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

Permalink Reply by Onrender on July 20, 2013 at 10:41am

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.

Permalink Reply by Xiaoming Yang on July 22, 2013 at 2:20am

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.

Permalink Reply by Lars Olesen on January 28, 2014 at 2:09am

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

Permalink Reply by Xiaoming Yang on January 29, 2014 at 2:39am

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

Permalink Reply by Nicolas Cabargas Mori on June 5, 2014 at 6:10am

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.

Permalink Reply by Douglas Ponciano on September 19, 2016 at 11:29am

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)?

Permalink Reply by Xiaoming Yang on September 21, 2016 at 6:42am

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.

Permalink Reply by Xiaoming Yang on September 27, 2016 at 4:23am

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: