These vb Components for Grasshopper, adapted from work by Damian Alamar of www.liquidtectonics.com, allows for the streaming in and out of data from Excel to Grasshopper with parametric control of not only data placement but also general formatting.  The functions are broken up into 5 individual components, an import column reader, an export column writer, and three formatting functions for type, cell, and border.  These components are designed to operate on a per column basis allowing the user to create sheets in a flexible format.  To stream information to or from excel, simply open an empty excel workbook and switch the _Stream input to a boolean value of true.  Data will be actively updated as parameters change.  The "Write to Excel" function allows the user to specify a title for the column, the column to stream to and the starting row.  Additionally three optional inputs for the formatting options can be applied, but are not required.  The final inputs are the list of data and the and a boolean to toggle streaming on and off.  The three formatting inputs work off of the basic available formatting options for a cell in excel, for the border this is style, thickness, and color, for the cell this is the pattern, the pattern color and the fill color, and for the text the inputs are, height, color, horizontal justification, vertical justification, bold, italic, underline, strikethrough, subscript, superscript.  Formatting options are available on the MSDN, msdn.microsoft.com, database.  The "Read Excel" function allows for the input of data from a specific column in excel to a list in grasshopper.  The inputs allow the user to specify the start column and row as well as an optional limit on the number of cells to be read in the column.  If this is left empty the data will be read down to the last value in the column.

Excel.ghx (download)