Exporting Detail Area Content to Microsoft Excel, Word, or to a Comma Separated Values File

(Release 9.2.5.4) To export the records from a grid in ActiveX mode, set the value for Use ActiveX Controls as TRUE in the Web Runtime section in the Server Manager.

To export all the records from a grid in non-ActiveX mode, set the value for Use ActiveX Controls as FALSE in the Web Runtime section in the Server Manager. To export all the records from a grid in non-ActiveX mode along with the OLE functionality set the value for Use ActiveX Controls as OLEONLY in the Web Runtime section in the Server Manager. You can enable this option to export all records from a grid in the Google Chrome, Edge Chromium, Firefox, Internet Explorer, and Safari browsers.

Access an application with a grid.

1. Launch an application with a grid, and then use Find to load the detail area with records.

2. From the Tools menu, click Export Grid Data.

3. On Export Assistant, select one of these options:

   • Export to Excel

     If you select this option, select if you want to export the data to a new workbook, or an existing workbook.

   • Export to Word

   • Export to Comma Separated Values

4. Select Export All to export all the data in the grid, or clear the Export All check box to export a range cells within the grid containing data that you want to export.

   If you clear the Export All check box, then you must select on the grid the range of cells you want to export. First, click the cell where you want the range to begin, then click the cell where you want the range to end.

   If you click the wrong cell, click Reset Selection.

5. Click Continue.

   The system exports the detail area contents that you selected to the appropriate file type and displays it.