Table Head (thead) |
---|
Table Row (tr) |
---|
| Table Head (th) |
---|
| Method Details |
|
|
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'] |
|
|
|
| ,templateXLS, 'mySheet');
//export by adding to templateXLS |
|
|
|
| ,'mySheet(new) 'Servoy Data' worksheet |
|
|
|
| , starting at 3rd row and 5thcolumn
var bytes = plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);
//export by adding to templateXLS, in 'mySheet' |
|
|
|
| ,3,5);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number|class=node}{tr:id=name}{td}h6.excelExport{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}byte[]{span}{span:id=iets|style=float: left; font-weight: bold;}excelExport{span}{span:id=iets|style=float: left;}\(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn){span}{td}{tr}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_des|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_des|trigger=none|class=sIndent}Export to Excel data{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_snc|text=|trigger=button}{sub-section}{sub-section: 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_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_prs|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_prs|trigger=none|class=sIndent}\{[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
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_ret|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_ret|trigger=none|class=sIndent}byte[]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section: | 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 |
---|
| _see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_sam|trigger=none}{code:language=javascript}
| 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); |
|
|
|
|
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table} |