Breaking Apart Excel Data

Hello All,

I am streaming data from Excel through VB Script. I have the script connected to a Panel (string), but would like to break apart the integers. The goal it to be able to select the intergers on by one from the spreadsheet.

Thanks in advance for all your help!!

Sincerely,

Doug Bucci

Replies to This Discussion

Permalink Reply by Danny Boyes on September 27, 2010 at 9:19am

I'm not sure what format you have the data coming into the panel as, but if you're unaware of the String Functions in GH v0.7xx, have look at those, they might be of use.

Permalink Reply by Doug Bucci on September 27, 2010 at 9:29am

Hi Danny,
My feed looks exactly what you have on the right hand panel, although I would like to make that data to be selectable.

Thanks,
Doug

Permalink Reply by Danny Boyes on September 28, 2010 at 2:40am

Use the List Item Component to select specific data from a list.

What is it that you want to do with the data? If you need every line to be used individually then you can use the Graft Component to create a multiple list of single data which might be more useful.

Permalink Reply by Doug Bucci on September 28, 2010 at 5:59pm

Hi Danny,
This is exactly what I needed. In the end I used the lower graft and a slider to read the spread sheet line by line. I am streaming data from my insulin pump to generate form that I will Rapid Prototype. What are you working on?

Thanks a ton!!
Doug

RSS