Cell format Excel to Bumbelbee

Thanks for this great tool!

Got a little confused by how you address a cell with int,int ;

so I made a little (naughty) conversion tool. But maybe its worth to include something like this right away?

Best,

Phillip

Attachments:

FormatExcelToBumbelbee.gh, 15 KB

Replies to This Discussion

Permalink Reply by David Mans on May 22, 2013 at 7:49am

Phillip,

Good call, that would definitely make initial cell placement easier to set. There is currently a component which does this inverse of this operation, converting an index to an address, but it requires a link to Excel. Ill rebuild these two components, Index to Address, and Address to Index so they work based on vb operations and not using excels built in conversion and make them part of the download.... Hopefully this week.

Permalink Reply by David Mans on May 31, 2013 at 3:35pm

Phillip,

Ive added a new component XL Cell Index which converts a cell address to to a cell index, examples "A1" to "1,1". The component's output is an interval so it can be directly used with the rest of the bumblebee components. This component does the conversion in vb with no reference to excel, so excel does not need to be running. The XL address has been updated as well so it no longer needs a link to excel.

Also, I caught an error in the address component where the domain input "Location" was reversing the column and row values, this has been fixed.

Conversion from integer to string column ID adapted from: http://stackoverflow.com/questions/181596/how-to-convert-a-column-n...

Excels limits are listed at: http://office.microsoft.com/en-us/excel-help/excel-specifications-a...

Updates User Object collection can be downloaded at: Bumblebee Version 1.02

Permalink Reply by phillip on June 3, 2013 at 1:48am