IBM Support

How to import Excel tables present as OLE objects into Rational Rhapsody Gateway

Technote (FAQ)


How do you import Excel tables present as OLE objects into IBM Rational Rhapsody Gateway?


Objective is to view Requirement tool data in Rational Rhapsody


Excel tables present as OLE objects in Rational DOORS can be imported into Rational Rhapsody Gateway as Images by applying the steps below:

  1. Launch Rational Rhapsody and load a project
  2. Open Rational Rhapsody Gateway via Tools > Open Rhapsody Gateway
  3. Navigate to the Types section in Rhapsody Gateway via File > Edit Types
  4. Expand the Analysis Type in use and ensure the Requirement section contains the Picture/Image tag <Picture>
  5. Navigate to the Project configuration section and select the Requirement document
  6. Ensure the variable Capture Diagrams of the Requirement document is set to checked
  7. Click OK
  8. Reload the Requirement document in the Rational Rhapsody Gateway main window
  9. Single-click each requirement and an image with the excel table will be displayed

Once the Excel table information is imported into Rational Rhapsody Gateway, it can further be transferred to Rational Rhapsody via the Add High Level Requirements function

Document information

More support for: Rational Rhapsody
General Information

Software version: 7.6,, 7.6.1,,,, 8.0, 8.0.1

Operating system(s): Windows

Reference #: 1622061

Modified date: 31 January 2013

Translate this page: