Write Excel

This is an alternate way to write to Excel (instead of using the built in Excel.WriteToFile), found in the Bumblebee package created by Konrad Sobon. It requires the user to set up a ‘BB Data’ node, which is one of the inputs. The full list of inputs is:

FilePath

RunIt – a true / false switch, where true means ‘do it’

ByColumn – a true / false switch that essentially has the effect of Transposing the data before writing it

BB Data – a node that sets up the information to be written to Excel, and it comprehends the ‘Excel way’ of writing cell references, ie. A1, A2 etc.

More information at: http://archi-lab.net/bumblebee-dynamo-and-excel-interop/

Advertisements

BumbleBee Node Index

Maintained by Konrad Sobon. Instructions and tutorials can be found at www.archi-lab.net. This is an open source project with GitHub page: https://github.com/ksobon/Bumblebee as well as an open source primer: https://github.com/ksobon/BumblebeePrimer. You can read the primer here: http://konradsobon.gitbooks.io/bumblebee-primer/content/

(2) Color Scale Format Condition
(3) Color Scale Format Condition
BB Data
BB Style
Border Style
Cell Index
Cell Value Format Condition
Chart Style
Clear Contents
Conditionally Format Excel
Data Bar Format Condition
Expression Format Condition
Fill Style
Format Excel
Get Worksheet Names
Graphic Style
Label Style
Legend Style
Line Chart Graph Style
Line Chart
Line Style
Live Write Excel
Marker Style
New File By Template
Pie Chart Graph Style
Pie Chart
Read Excel
ReadExcel.ByRange
Search Value Get Row
Text Style
Top/Bottom Percentile Format Condition
Write Excel

bumblebee