Help
Topics
Exporting a GridBlox to Excel
You can export a grid to a Microsoft Excel spreadsheet in order to perform other calculations or Excel specific actions.
Before exporting the
grid data to Excel:
- You must have Office 2000 or Office XP.
- If an authorization dialog box displays behind the browser; use Alt-Tab
to bring it forward.
To export a grid to an Excel spreadsheet, you have several options:
- If the toolbar is available in your application, click the Export
to Excel icon (
)
in the toolbar.
- If the menu bar is available in your application, select File
> Export to Excel.
As you open the spreadsheet,
you will be prompted whether to enable the macros contained in the file. You
must enable the macros for the spreadsheet to work.
- If neither the toolbar nor the menu bar is available, you can:
- In the browser's location field, at the end of the URL, type
?render=xls
.
For example, the URL for a Sales Forecast application might be:
http://salesserver/sales/forecast.jsp
In preparation for exporting, you would add ?render=xls
to
the end of the URL, as follows:
http://salesserver/sales/forecast.jsp?render=xls
- Press the Enter key.
- Enter your user name and password in the authorization window.
Microsoft Excel opens, showing the grid.
Using this approach,
the chart is exported as a grahic and cannot be updated or modified in
Excel.
Related Topics: