(foundSet, dataProviderIds) |
|
|
Parameters
{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders |
|
|
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);
|
|
|
|
|
(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 |
|
|
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);
|
|
|
|
|
(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 |
|
|
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);
|
|
|
|
|
(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 |
|
|
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);
|
|
|
|
|
(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 |
|
|
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);
|
|
|
|
|
|