OpenBuildings GenerativeComponents Help

Exchanging Data with Microsoft® Office and Databases

In order to extend its functionality beyond importing and exporting geometry files, OpenBuildings™ GenerativeComponents is also capable of interfacing with Microsoft Office applications. Using built-in tools, it is possible to read and write data from Excel® spreadsheets, Access™ databases files, text (*.TXT) files, and even external databases. Two node types listed in the Node Types dialog are present when first opening OpenBuildings™ GenerativeComponents: DataExporter and DataImporter. These nodes interface with Access databases and text files. There is one additional node type that interfaces with Excel, though it is not initially present when OpenBuildings™ GenerativeComponents is first installed: ExcelRange.