You can export the contents of a view in table structure
to Microsoft® Excel. You
might export and import elements from and to Excel to move elements
from one workspace or installation to another. However, you cannot
import or export the attribute types file, history, and matrix. You
can export 8 KB of characters for each cell. Exporting elements is
useful when you want to move elements from one workspace or installation
to another. The attribute types File, Time Grid and History cannot
be exported or imported. The export and import of the attribute types
Link, Link List and Matrix attribute types require special handling.
Before you begin
To export elements from Excel, you must be an administrator.
About this task
To export elements:
Procedure
- Click Display and select a view
in which you find the elements you want to export.
- Select Table structure.
- Optional: Create a filter to export a subset
of the elements or to export a subset of the attributes.
- Click Export. The limit on characters
in each cell is 8K.
- Click Open to open the Excel file
and view or edit its content.
- Click Save to save the file.
Note: If the Excel file opens in a web browser rather than in
Excel, change the following setting:
- Open Windows Explorer and select .
- Scroll down to XLS and click Advanced.
- Clear the Browse in same window check box
and click OK.