1. Foundation Guide
  2. Exporting All Records from a Grid

Exporting All Records from a Grid

You can export all records from a grid, rather than choosing a range of records to export.

(Release 9.2.5.4) To export all the records from a grid in ActiveX mode, in Internet Explorer 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.

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

  2. Click the Tools icon, and then click the Export Grid Data menu. You can also click the Export Grid Data icon in the grid.

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

    • Export To Excel

      Note: If you select this option, also select whether you want to export to a new workbook or an existing workbook.If you select the option to export to an existing workbook, the file extensions XLSX, XLSM and XLS are supported. For the XLS file extension, you must use a version of Excel 97-2003 Workbook. You cannot use XML SpreadSheet 2003.

    • Export To Word

    • Export To Comma Separated Values (CSV) File character encoding

  4. Select the Export All option.

  5. Click Continue.

    Note: When you export to an existing workbook, you must ensure that the character count for the worksheet name is between 1 and 31. It must not begin or end with a single quotation mark('). The worksheet name cannot contain the following special characters: colon (:), backslash (\), slash (/), asterisk (*), question mark (?), left bracket ([), right bracket (]), 0x0000 (null character), 0x0003 (end of text).