Table Body (tbody) |
---|
id | excelExport-JSFoundSet_StringArray |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
excelExport |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
(foundSet, dataProviderIds) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {JSFoundSet} foundSet - the foundset on which to export {String[]} dataProviderIds - the ids of the dataproviders |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| //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); |
|
|
|
|
Table Body (tbody) |
---|
id | excelExport-JSFoundSet_StringArray_byteArray |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
excelExport |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
(foundSet, dataProviderIds, templateXLS) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {JSFoundSet} foundSet - the foundset on which to export {String[]} dataProviderIds - the ids of the dataproviders {byte[]} templateXLS - the xls template to export in |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| //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); |
|
|
|
|
Table Body (tbody) |
---|
id | excelExport-JSFoundSet_StringArray_byteArray_String |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
excelExport |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
(foundSet, dataProviderIds, templateXLS, sheetName) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {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 |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| //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); |
|
|
|
|
Table Body (tbody) |
---|
id | excelExport-JSFoundSet_StringArray_byteArray_String_Number |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
excelExport |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
(foundSet, dataProviderIds, templateXLS, sheetName, startRow) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {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 |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| //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); |
|
|
|
|
Table Body (tbody) |
---|
id | excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
excelExport |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {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 |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| //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); |
|
|
|
|
|