FlexPro uses Excel data link objects to access the data of an Excel workbook in the project database. You can assign a cell or a cell range from the Excel workbook in the Excel data link for every element that makes up a FlexPro data set. The Excel data link reads all the information necessary for one FlexPro data set from the Excel workbook. This applies not only to data, but also to all header information such as comments, physical units and names of physical quantities.

You can use this type of Excel data link just like a normal data set. Whenever FlexPro requests the data or other information from the Excel data link, it refers back to the assigned Excel workbook. Elements for which there is no information in the Excel workbook can also be entered directly in the link.

An Excel data link can have all of the data structures supported by FlexPro. You can, for instance, specify the cell ranges for the X and Y component of a signal. Usually, you create several data links to an Excel workbook. Often one column in the Excel workbook corresponds to one Excel data link.

Excel data links always have to be placed in the Excel workbook folder, whose associated Excel workbook you want to access. Furthermore, you cannot use Excel data links to exchange data between FlexPro and a separately launched Excel application. This requires that you create an OLE data link.

See Also

Excel Workbook

Data Set

OLE Data Link

Troubleshooting Excel Communications

Working with Excel Data Links

Manually Creating an Excel Data Link

Creating Excel Data Links via the Clipboard

Creating Excel Data Links Using Drag-and-Drop

Analyzing and Presenting Excel Data

Converting Excel Data Links into Data Sets