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]
|