This plugin allows the enabling/disabling of the Smart Client menuitems that expose the generic Excel import/export logic
{column:padding=0px|width=80px}{column}{column}{column}
Property Summary
exportEnabled
Enable the export feature of this plugin.
importEnabled
Enable the import feature of this plugin.
{column:padding=0px|width=80px}{column}{column}{column}
Method Summary
byte[]
excelExport(foundSet, dataProviderIds, [templateXLS], [sheetName], [startRow], [startColumn])
Export to Excel data
{column:padding=0px|width=100%}{column}
Property Details
Enable the export feature of this plugin.
Returns
Boolean
Sample
plugins.excelxport.exportEnabled = true; var isEnabled = plugins.excelxport.exportEnabled;
Enable the import feature of this plugin.
Returns
Boolean
Sample
plugins.excelxport.importEnabled = true; var isEnabled = plugins.excelxport.importEnabled;
{column:padding=0px|width=100%}{column}
Method Details
byte[]
excelExport
(foundSet, dataProviderIds, [templateXLS], [sheetName], [startRow], [startColumn])
Export to Excel data
Parameters
foundSet
dataProviderIds
[templateXLS]
[sheetName]
[startRow]
[startColumn]
Returns
byte[]
Sample
//export in new byte array var bytes = plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']); //export by adding to templateXLS in default (new) 'Servoy Data' worksheet var bytes = plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS); //export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/column var bytes = plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS, 'mySheet'); //export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th column var bytes = plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS, 'mySheet',3,5);