DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR
{column:width=80px|padding=0px}{column}{column}{column}
Property Summary
exportEnabled
Enable the export feature of this plugin.
importEnabled
Enable the import feature of this plugin.
{column:width=80px|padding=0px}{column}{column}{column}
Method Summary
byte[]
excelExport(foundSet, dataProviderIds)
Export to Excel data
byte[]
excelExport(foundSet, dataProviderIds, templateXLS)
Export to Excel data
byte[]
excelExport(foundSet, dataProviderIds, templateXLS, sheetName)
Export to Excel data
byte[]
excelExport(foundSet, dataProviderIds, templateXLS, sheetName, startRow)
Export to Excel data
byte[]
excelExport(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn)
Export to Excel data
{column:width=100%|padding=0px}{column}
Property Details
Sample
plugins.excelxport.exportEnabled = true; var isEnabled = plugins.excelxport.exportEnabled;
Sample
plugins.excelxport.importEnabled = true; var isEnabled = plugins.excelxport.importEnabled;
{column:width=100%|padding=0px}{column}
Method Details
byte[]
excelExport
(foundSet, dataProviderIds)
Parameters
{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders
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);
byte[]
excelExport
(foundSet, dataProviderIds, templateXLS)
Parameters
{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders
{byte[]} templateXLS – the xls template to export in
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);
byte[]
excelExport
(foundSet, dataProviderIds, templateXLS, sheetName)
Parameters
{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders
{byte[]} templateXLS – the xls template to export in
{String} sheetName – the name of the worksheet
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);
byte[]
excelExport
(foundSet, dataProviderIds, templateXLS, sheetName, startRow)
Parameters
{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders
{byte[]} templateXLS – the xls template to export in
{String} sheetName – the name of the worksheet
{Number} startRow – row in the foundset at which to start the export
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);
byte[]
excelExport
(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn)
Parameters
{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders
{byte[]} templateXLS – the xls template to export in
{String} sheetName – the name of the worksheet
{Number} startRow – row in the foundset at which to start the export
{Number} startColumn – column in the foundset at which to start the export
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);