You can import matrixes that contain data, such as matrix
attribute values or time grid values from an .xls file to a time grid
sheet.
Before you begin
- To import information to time grid sheets, you need a file in
.xls format. The .xls file must include a column that corresponds
to a unique ID attribute in the targeted elements, and a matrix for
each element. If the .xls file contains more data than the time grid
sheet setup, any extra values are ignored.
- The time grid sheet must be in edit mode.
Procedure
- In a display view, click the element.
- Select a time grid attribute.
- Click the link to a time grid sheet.
- Click Import.
- Select import settings.
- Select the .xls file to import from.
- Select the worksheet in the .xls file to import from.
- Select the time grid sheet to import to.
- Click Import.
The selected .xls file is displayed.
- Select a column in the worksheet to map to a unique ID
attribute in the target elements.
- Select the column to import to the time grid sheet.
- Click Import.
Results
The matrixes from the .xls file are imported to the specified
time grid sheet in the elements.