Considerations for Exporting Data
When exporting parts or product structures to Microsoft Excel, consider the following:
Exported spreadsheets are saved with the XLS or XLSX extension.
When exporting parts and product structures, spreadsheets can contain multiple worksheets. A worksheet is created for each of the following:
part type
part subtype
document type
document subtype
the product structure or BOM
replacements
Classified parts that share a common classification node can also be exported to the same worksheet, and that worksheet is assigned a system generated name. Same behaviour applies for classified documents as well.
Different part types, for example, manufacturer parts and vendor parts, are exported to separate worksheets, even if they belong to the same node in the classification structure. Similarly, different document types, for example, agenda document and plan document, are exported to separate worksheets, even if they belong to the same node in the classification structure.
The Export Importable Spreadsheet action is not available for custom parts or custom documents.
When you export from a search results table, all parts or documents in the table are exported to a spreadsheet.
The first cell of a worksheet defines the type of data that was exported. If you plan to import the spreadsheet back in Windchill, do not modify the first cell of the top row of a worksheet.
Row 5 of the exported spreadsheet contains the display names of the soft attributes included in the worksheet. If the attribute does not have a display name, this field is blank.
Row 6 of the exported spreadsheet can contain the internal names of the attributes included in the worksheet. The internal name of an attribute may be a system generated name such as xje262.
Was this helpful?