(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); |
|
|
|
|
|