IBM Support

Exporting DOORS enumerated data to Excel

Question & Answer


Question

Is it possible to export an enumerated attribute from IBM Rational DOORS to Microsoft Excel as a drop-down list ?

Cause

You need your enumerated values shown as a drop down list in Excel to make data entry easier

Answer

No. Rational DOORS will export an enumeration value as a single line entry in a cell. For multi-valued enumerations each selected value in DOORS is exported as a separate line entry in the table cell.

Note: When you export to Microsoft Excel, rich text formatting and special characters are not preserved. If you want to preserve rich text formatting, export to a Microsoft Word table, and then copy and paste the Word table into Excel.

Related Information

[{"Product":{"code":"SSKR2T","label":"IBM Engineering Requirements Management DOORS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.4.0.1;9.4;9.3.0.7;9.3.0.6;9.3.0.4;9.3.0.5;9.3.0.3;9.3.0.2;9.3.0.1;9.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
01 May 2020

UID

swg21616799