Considerations for Exporting Redline Product Data
When exporting redline product structures to Microsoft Excel, consider the following:
The exported workbook is downloaded with the XLSX extension.
When exporting multiple distinct redline structures, the workbook can contain multiple spreadsheets such that each redline structure is exported to a single distinct spreadsheet in the same workbook. The root part of a structure in one spreadsheet is not included in the other spreadsheet of the workbook.
The Export Redline Importable Spreadsheet action is only available for parts with open redlines.
The first cell of a worksheet defines the type of data that was exported. The second cell of the top row of a worksheet contains the name of the change notice. The third cell of the top row of a worksheet contains the name of the owning organization of the change notice. If you plan to import the workbook in Windchill, do not modify the first three cells of the top row of a worksheet.
Row 5 of the exported worksheet 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 worksheet contains 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.
Row 7 and later of the worksheet contain the product data for the worksheet type.
Rows representing parts with open redline versions are identified with the redline Revision (for example, Chg-A-1) and View.
Rows representing parts without open redline version are identified without values for Revision and View.
Was this helpful?