From an .xls file, you can import matrixes that contain
data, such as matrix attribute values or time grid values, to a time
grid sheet.
Avant de commencer
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.
A propos de cette tâche
To import a time grid sheet:
Procédure
- 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.
Résultats
The matrixes from the .xls file are imported to the specified
time grid sheet in the elements.