Bumblebee write-out in read-function?

Hey Bumblebee-devs

I wonder if it is me who is using the plugin wrong, or is there a reason why reading from a file (on a certain sheet) all data in Excel in that particular sheet is overwritten with static data?

Original Excel-file contains formula or conditionals in cells

When using Bumblebee read from file all formulas are gone and replaced with static data:

BR Kristoffer

Replies to This Discussion

Permalink Reply by David Mans on June 18, 2013 at 8:29am

Kristoffer,

As far as I can tell you are using the component properly.

The issue is that the current version of the XL data in components read the cells Value only, not the Formula. This is so results of excel operations can be read by grasshopper. However, this is a good case where the ability to read a formula would be important.

Ill develop a component that can return the formula when a cell does not contain a static value and post an update online, hopefully within the week.

In the meantime, a workaround would be to use two read components and skip the column with the formula. Obviously not ideal, but a quick fix till I can post a new component.

Hope this helped.

David

Permalink Reply by Kristoffer Negendahl on June 18, 2013 at 9:11am

Hey David

Thank you for responding. I really like all the control features you have implemented.

Even though reading out formula-data would be a great feature, it is not exactly what I want.
The read module works perfectly, it reads the content of a cell (or the apparent content of it, which is what I need par se). The issue is the reader is overwriting the cell-formula with the static output. And I don't know why it does that.

As a consequence all dynamics within excel is lost and only manual input can transferred un-changed into GH3d.

All my read columns are constructed with formulas, so at the moment I have to Copy Paste all column-data from a generic sheet into a sheet that is send to GH3d. this of course is not a good solution.

BR Kristoffer

Permalink Reply by David Mans on June 18, 2013 at 2:04pm

Interesting, I haven't run into that issue.

Would you be able to attached a sample of your excel file and grasshopper file, and Ill see if I can recreate the problem and fix it.

Thanks,

David

Permalink Reply by Kristoffer Negendahl on June 22, 2013 at 2:16am

Hi David

Please open the excel file first to see it has formulas to begin with.

When opening/running bumblebee formulas that is send to GH is being reduced to plain content values.

I hope this helps solve the problem

Thank you best regards Kristoffer

Attachments:

Override_problem.xlsx, 115 KB
BumblebeeReadOveridesExcel.gh, 26 KB

Permalink Reply by Balázs Hegedus on May 19, 2014 at 9:23am

Hi,

I am struggling with setting up reading Excel with Bumblebee. I tried to set up the above example files to check if may path setup is Ok. Actually I cant set up even these files to work. Date does not appear in Grasshopper. Is there any tricks with paths? See attached image.

Permalink Reply by David Mans on May 19, 2014 at 10:06am

Balazs,

Can you attach your gh file and excel workbook?

Thanks,
David

Permalink Reply by Kristoffer Negendahl on July 1, 2013 at 3:03am

Hi David

You are properly on vacation relaxing on a sunny beach drinking ice cold GTs. I couldn't resist in asking if you have looked into the override-issue?

Sorry in ruining a perfectly cold GT!

Best Regards,

Kristoffer

Permalink Reply by David Mans on July 1, 2013 at 11:56am

Kristoffer,

Have not forgotten about this one.

Its on the list of things to tackle this week. So hopefully Ill have a solution by Wednesday

Thanks,

David

Permalink Reply by David Mans on July 2, 2013 at 2:12am

Kristoffer,

Ok, so the problem is when the ByColumn input is set to True the component uses a function called transpose to flip the data structure. This apparently has the results of converting the formula to a value, hence the issue.

Ill rework the components that use this function and use an alternate method to achieve the same outcome. Will post an update shortly.

David

Permalink Reply by David Mans on July 2, 2013 at 2:50am

Both data in and data in adv. components have been fixed and should return the value of the formulas in grasshopper but not change the formulas to values in excel. It was fortunately a quick one line fix.

The new version of the components can be downloaded here.

Thank you again for catching the bug and please let me know any other errors or suggestions.

Permalink Reply by Kristoffer Negendahl on July 2, 2013 at 4:38am

perfect.

Thank you.

/Kristoffer

RSS