Type | Description | |||
Destination as Variant |
A String expression that specifies the file/format to be created. The
Destination parameter indicates the format to be created as follows:
No error occurs, if the Export method can not create the file. | |||
Options as Variant | A String expression that specifies the options to be used when exporting the control's data, as explained bellow. |
Return | Description | |||
Variant | The
result of the Export method is a:
|
The following file samples, shows the format the Export method can export the control's DATA:
Let's say we have the following control's DATA:
The following screen shot shows the control's DATA in CSV format:
The following screen shot shows the control's DATA in HTML format:
The Options parameter consists a list of fields separated by | character, in the following order:
The Destination parameter indicates the file to be created where exported date should be saved. For instance, Export( "c:\temp\export.html") exports the control's DATA to export.html file in HTML format, or Export( "","sel|0,1|;") returns the cells from columns 0, 1 from the selected items, to a CSV format using the ; character as a field separator.
The "CSV" refers to any file that:
The "HTML" refers to any file that:
You can use the Copy/CopyTo to export the control's view to clipboard/EMF/BMP/JPG/PNG/GIF or PDF format.