Back
exportOptions
Editing, Updating and Creating Records
exportOptions
Export options for exportLens property
Default:
The default of exportLens is to export all records in CSV format.

To only export current page, set exportOptions = 'CURPAGE'.

To export Excel format instead of CSV, remove the 'CSV' setting from exportOptions.

To change export file name, use exportOptions="NAME^export-$DATE.xls". The $DATE in the file name will be replaced with the current date in Y-m-d format.

Note: In 2.4.10, default export mode was changed from Excel to CSV.

Syntax
# use ; to combine choices, for example:
# export CSV, only current page, with name file.csv

$lens->exportOptions = 'CSV;CURPAGE;NAME^file.csv';

 Basic:Yes  Advanced/Enterprise:Yes  DynamicEdit:Yes   [Version 2.2]