This plugin allows the enabling/disabling of the Smart Client menuitems that expose the generic Excel import/export logic
Property Summary | |
---|---|
Boolean | #exportEnabled Enable the export feature of this plugin. |
Boolean | #importEnabled Enable the import feature of this plugin. |
Method Summary | |
---|---|
byte[] | #excelExport(foundSet, dataProviderIds, [templateXLS], [sheetName], [startRow], [startColumn]) Export to Excel data |
Property Details |
---|
exportEnabled |
Enable the export feature of this plugin. |
Returns Boolean |
Sampleplugins.excelxport.exportEnabled = true; var isEnabled = plugins.excelxport.exportEnabled; |
importEnabled |
Enable the import feature of this plugin. |
Returns Boolean |
Sampleplugins.excelxport.importEnabled = true; var isEnabled = plugins.excelxport.importEnabled; |
Method Details |
---|
excelExport |
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); |