Child pages
  • excelxport
Skip to end of metadata
Go to start of metadata

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
Sample
plugins.excelxport.exportEnabled = true;
var isEnabled = plugins.excelxport.exportEnabled;
importEnabled
Enable the import feature of this plugin.
Returns
Boolean
Sample
plugins.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);
  • No labels