DB2 graphic QMF Version 8

Using the Microsoft Excel add-in

The 32-bit version of QMF for Windows includes an add-in for Microsoft Excel 7.0 or later. This enables you to run QMF for Windows and export query results directly into a spreadsheet. The appropriate add-in is automatically installed if you choose the "Typical" installation option, or if you choose the "Custom" installation option and select the Microsoft Excel Add-In.

  1. Run a query in QMF for Windows.

    The query results open in the query results grid.

  2. Select the data you want to return to Excel.
  3. Select Results--> Display Chart.
  4. Select Microsoft Excel from the Application drop-down list.
  5. Specify the chart type, chart title, chart labels, and other charting options.
  6. Click OK.

    Microsoft Excel opens and displays the exported spreadsheet.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004