Page History

{hiddendiv:style=display:none}
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 EXTRACTAUTO CHANGESUPDATE FROM THE PAGECONTENT ANDTHROUGH MERGETHE THEM BACK INTO SERVOY SOURCE{hiddenDOC GENERATOR{div}
{sub-sectiondiv:description|text=}This plugin allows the enabling/disabling of the Smart Client menuitems that expose the generic Excel import/export logic{sub-section}\\ 

{table:id=|class=servoy id=description}{div}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[Boolean]{td}{td}[#exportEnabled]
Enable the export feature of this plugin.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#importEnabled]
Enable the import feature of this plugin.{td}{tr}{tbody}{table}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}byte[]{td}{td}[#excelExport]\(foundSet, dataProviderIds)
Export to Excel data{td}{tr}{tbody}{tbody}{tr}{td}byte[]{td}{td}[#excelExport]\(foundSet, dataProviderIds, templateXLS)
Export to Excel data{td}{tr}{tbody}{tbody}{tr}{td}byte[]{td}{td}[#excelExport]\(foundSet, dataProviderIds, templateXLS, sheetName)
Export to Excel data{td}{tr}{tbody}{tbody}{tr}{td}byte[]{td}{td}[#excelExport]\(foundSet, dataProviderIds, templateXLS, sheetName, startRow)
Export to Excel data{td}{tr}{tbody}{tbody}{tr}{td}byte[]{td}{td}[#excelExport]\(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn)
Export to Excel data{td}{tr}{tbody}{table}\\ 

{table:id=property|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=exportEnabled|class=node}{tr:id=name}{td}h6.exportEnabled{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:exportEnabled_des|trigger=button|text=}{sub-section}{sub-section:exportEnabled_des|trigger=none|class=sIndent}Replace with description{sub-section*Returns*\\{div:class=sIndent}[Boolean]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:exportEnabled_snc|trigger=button|text=}{sub-section}{sub-section:exportEnabled_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
plugins.excelxport.exportEnabled = true;
var isEnabled = plugins.excelxport.exportEnabled;
{code}{div}{td}{tr}{builder-show}{builder-show:permission=edittr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=prsimportEnabled}{tr:id=name}{td}h6.importEnabled{td}*Parameters*\\{sub-section:exportEnabled_prs|trigger=button|text=}{sub-section}{sub-section:exportEnabled_prs|trigger=none|}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section[Boolean]{div}{td}{tr}{builder-show}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:exportEnabled_ret|trigger=button|text=}{sub-section}{sub-section:exportEnabled_ret|trigger=none|class=sIndent}[Boolean]{sub-sectiondiv:class=sIndent}{code:language=javascript}
plugins.excelxport.importEnabled = true;
var isEnabled = plugins.excelxport.importEnabled;
{code}{div}{td}{tr}{builder-showtr:permissionclass=edit}{tr:id=see}{td}*Also see*\\{sub-section:exportEnabled_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:exportEnabled_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=editlastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=excelExport-JSFoundSet_StringArray}{tr:id=link}name}{td}h6.excelExport{td}*External links*\\{sub-section:exportEnabled_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:exportEnabled_link|trigger=none}{sub-section}{div}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}byte[]{span}{span:style=font-weight: bold;}excelExport{span}{span}\(foundSet, dataProviderIds){span}{td}{tr}{builder-show}{tr:id=samprs}{td}*SampleParameters*\\{sub-section:exportEnabled_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:exportEnabled_sam|trigger=none}{code:language=javascript}
plugins.excelxport.exportEnabled = true;
var isEnabled = plugins.excelxport.exportEnabled;
{code}{sub-section}\{[JSFoundSet]} foundSet -- the foundset on which to export
\{[String]\[]} dataProviderIds -- the ids of the dataproviders
{div}{td}{tr}{tr:classid=lastDetailRowret}{td}{td}{tr}{tbody}{tbody:id=importEnabled|class=node}{tr:id=name*Returns*\\{div:class=sIndent}byte[]{div}{td}h6.importEnabled{td}{tr}{builder-show:permission=edit}{tr:id=dessam}{td}{sub-section:importEnabled_des|trigger=button|text=}{sub-section}{sub-section:importEnabled_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:importEnabled_snc|trigger=button|text=}{sub-section}{sub-section:importEnabled_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:importEnabled_prs|trigger=button|text=}{sub-section}{sub-section:importEnabled_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:importEnabled_ret|trigger=button|text=}{sub-section}{sub-section:importEnabled_ret|trigger=none|class=sIndent}[Boolean]{sub-section*Sample*\\{div:class=sIndent}{code:language=javascript}
//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}{div}{td}{tr}{builder-showtr:permissionclass=editlastDetailRow}{tr:id=seetd}{td}*Also see*\\{sub-section:importEnabled_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:importEnabled_see|trigger=none}{sub-section}{div}{{tr}{tbody}{tbody:id=excelExport-JSFoundSet_StringArray_byteArray}{tr:id=name}{td}h6.excelExport{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linksig}{td}*External links*\\{sub-section:importEnabled_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:importEnabled_link|trigger=none}{sub-section}{div{span:style=margin-right: 5px;}byte[]{span}{span:style=font-weight: bold;}excelExport{span}{span}\(foundSet, dataProviderIds, templateXLS){span}{td}{tr}{builder-show}{tr:id=samprs}{td}*SampleParameters*\\{sub-section:importEnabled_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:importEnabled_sam|trigger=none}{code:language=javascript}
plugins.excelxport.importEnabled = true;
var isEnabled = plugins.excelxport.importEnabled;
{code}{sub-section}\{[JSFoundSet]} foundSet -- the foundset on which to export
\{[String]\[]} dataProviderIds -- the ids of the dataproviders
\{byte[]} templateXLS -- the xls template to export in
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=lastDetailRowsIndent}byte[]{tddiv}{td}{tr}{tbodytr:id=sam}{tabletd}*Sample*\\ 

{tablediv:id=function|class=servoy sDetailsIndent}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=excelExport-JSFoundSet_StringArray|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){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_des|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:excelExport-JSFoundSet_StringArray_snc|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_snc|trigger=none|class=sIndent} Replace with version info{sub-sectioncode:language=javascript}
//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}{div}{td}{tr}{builder-showtr:class=lastDetailRow}{tr:id=prstd}{td}*Parameters*\\{sub-section:excelExport-JSFoundSet_StringArray_prs|trigger=button|text=}{sub-section}{sub-section:{tr}{tbody}{tbody:id=excelExport-JSFoundSet_StringArray_prs|trigger=none|class=sIndent}\{[JSFoundSet]} foundSet -- the foundset on which to export
\{[String]\[]} dataProviderIds -- the ids of the dataproviders
{sub-section}{td}{byteArray_String}{tr:id=name}{td}h6.excelExport{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:excelExport-JSFoundSet_StringArray_ret|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_ret|trigger=none|class=sIndent}byte[]{sub-section{span:style=margin-right: 5px;}byte[]{span}{span:style=font-weight: bold;}excelExport{span}{span}\(foundSet, dataProviderIds, templateXLS, sheetName){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:excelExport-JSFoundSet_StringArray_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit\{[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
{div}{td}{tr}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:excelExport-JSFoundSet_StringArray_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_link|trigger=none}{sub-section}{byte[]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_sam|trigger=none}{div:class=sIndent}{code:language=javascript}
//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}{tbody:id=excelExport-JSFoundSet_StringArray_byteArray|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){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_des|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_snc|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_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_prs|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_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
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_ret|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_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_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_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_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_sam|trigger=none}{code:language=javascript}
//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}{tbody:id=excelExport-JSFoundSet_StringArray_byteArray_String|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){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_des|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_snc|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_prs|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_ret|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_sam|trigger=none}{code:language=javascript}
//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}{tbody:id=excelExport-JSFoundSet_StringArray_byteArray_String_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){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_des|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_snc|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_prs|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_ret|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_see|trigger=none}{sub-sectionbytes = plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS, 'mySheet',3,5);
{code}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:idclass=linklastDetailRow}{td}*External links*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:{td}{tr}{tbody}{tbody:id=excelExport-JSFoundSet_StringArray_byteArray_String_Number_link|trigger=none}{sub-sectiontr:id=name}{divtd}h6.excelExport{td}{tr}{builder-show}{tr:id=samsig}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_sam|trigger=none}{code:language=javascript}
//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}{span:style=margin-right: 5px;}byte[]{span}{span:style=font-weight: bold;}excelExport{span}{span}\(foundSet, dataProviderIds, templateXLS, sheetName, startRow){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div: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
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}byte[]{div}{td}{tr}{tr:classid=lastDetailRowsam}{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}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_des|trigger=button|text=}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_snc|trigger=button|text=}{sub-section}{sub-section: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|trigger=button|text=}{sub-section}{sub-section:*Sample*\\{div:class=sIndent}{code:language=javascript}
//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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=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{tr:id=name}{td}h6.excelExport{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}byte[]{span}{span:style=font-weight: bold;}excelExport{span}{span}\(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn){span}{td}{tr}{tr:id=retprs}{td}*ReturnsParameters*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_ret|trigger=button|text=}{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|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section: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|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_link|trigger=none}{sub-section}div: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
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}byte[]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number_sam|trigger=none}{code:language=javascript}
//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}