Applies To
	Product(s):	GenerativeComponents
	Version(s):	08.11.09.288
	Environment:	N\A
	Area:	GC Feature
	Subarea:	N\A
	Original Author:	Steve Cocchi, Bentley Technical Support Group

Problem

Is it possible to extract element coordinate data into Excel?  I would like to get the XYZ coordinates for each point of multiple panels on my 3D model into an Excel spreadsheet.

Solution

In order to access the Excel Range node which supports reading from and writing to Excel workbooks and sheets, choose Utilities > Manage Node Types > Loaded Assemblies dialog and select the Bentley.GenerativeComponents.Office.dll file, by default located at C:\Program Files (x86)\<Bentley xx.xx.xx.xxx\GenerativeComponents\assemblies\.

The type of data structure containing your points; e.g., individual top level nodes, children points of a Point node, nested collections, etc., will typically determine how easy it will be to write the coordinate values to Excel.

Note that for more advanced uses there is also a DataExporter node that lets you write such data out to text files or to formatted tables in a Microsoft Access database (*.mdb).

See Also