Help Topics

Exporting Data to Excel


You can export data to a Microsoft Excel spreadsheet in order to perform other calculations or Excel specific actions.

NoteYou must have Excel 2000, Excel XP, or Excel 2003.

  1. To export data to an Excel spreadsheet, you have several options:
  2. In the dialog that pops up, select one of the templates from the drop-down list.
Template Description Notes
Default

Exports the data in the grid to native Excel format and uses the grid data to generate the chart in Excel. Because the chart is generated from the grid data, the resulting chart may look different from the one in IBM Alphablox.

 

The benefit of using this template is that if you change the data in the grid in Excel, the chart is automatically updated.

As you open the spreadsheet, you will be asked whether the embedded macros should be enabled. You should enable the macros for the chart to be generated. Choosing to disable the macros will bring up the spreadsheet with grid data only.

If there is only a chart and no grid in the user interface, no chart will be exported because there is no grid data available to generate the chart in Excel.

Use chart data

Exports the data in the grid to native Excel format. Creates a separate worksheet from the chart data so the chart in Excel is similar to the one in IBM Alphablox.

Because the chart is created from a separate worksheet from the chart data, the benefit of using this template is that the chart looks more similar to the one in IBM Alphablox. However, when the grid data in Excel is changed, the chart is not automatically updated. To update the chart in Excel, click the chartData tab in the spreadsheet and update data in this separate worksheet.

Same as the Default template, when you open the spreadsheet, you should enable the macros for the chart to ge generated.

No template

Simply sets the MIME type of the page to Microsoft Excel to trigger the browser to display this HTML page as an Excel spreadsheet. The grid data and the chart are not in native Excel format; nor are they connected.

Use this option if you do not need to further update the grid data or the chart or cannot accept macros.

Only the grid data is available. The chart is not exported.

NoteThese are standard templates provided by IBM Alphablox. Your application may include other custom templates.

Related Topics: