Grid Contents to Excel

Data grid contents to native Excel file

This exports the data grid dataset to Excel very much like exporting to delimited text.

To avoid dependencies of any Microsoft Office module to assist the Excel file creation, the very basic Excel version 2 has been chosen.

Just like the delimited text export, some of the data types are not included in the Excel export:

Field types not included in text export

As Graphics as well as attached binary objects (BLOB) and binary fields (BYTES and VARBYTES) are not exported, these fields if non-empty, will be marked in the exported table with the substituting tag text <Graphic>, <Blob>, <Bytes> and <VarBytes> respectively.