Page History

{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section: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 sSummary}{colgroup}{column:padding=0px|width=80px}{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:padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}byte[]{td}{td}[#excelExport]\(foundSet, dataProviderIds, \[templateXLS\], \[sheetName\], \[startRow\], \[startColumn\])
Export to Excel data{td}{tr}{tbody}{tbody}{tr}{td}byte[]{td}{td}[#excelExport]\(foundSet, dataProviderIds, templateXLS)
Export to Excel data{td}{tr}{tbody}{table}\\ 

{table:id=property|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=exportEnabled|class=node}{tr:id=name}{td}h6.exportEnabledtbody}{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}{tr:id=des}{td}{sub-section:exportEnabled_des|text=|trigger=button}{sub-section}{sub-section:exportEnabled_des|trigger=none|class=sIndent}Enable the export feature of this plugin.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:exportEnabled_snc|text=|trigger=button}{sub-section}{sub-section:exportEnabled_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\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:padding=0px|width=100%}{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}{tr:id=des}{td}{sub-section:exportEnabled_prsdes|text=|trigger=button}{sub-section}{sub-section:exportEnabled_prsdes|trigger=none|class=sIndent}{sub-Enable the export feature of this plugin.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=retsnc}{td}*ReturnsSince*\\{sub-section:exportEnabled_retsnc|text=|trigger=button}{sub-section}{sub-section:exportEnabled_retsnc|trigger=none|class=sIndent}[Boolean] Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:exportEnabled_seeprs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:exportEnabled_seeprs|trigger=none|class=sIndent}{sub-section}{div}{td}{tr}{builder-show}{builder-showtr:permissionid=editret}{tr:id=link}{td}*External linksReturns*\\{sub-section:exportEnabled_linkret|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:exportEnabled_linkret|trigger=none|class=sIndent}[Boolean]{sub-section}{div}{td}{tr}{builder-show:permission=edit}{tr:id=samsee}{td}*SampleAlso see*\\{sub-section:exportEnabled_samsee|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:exportEnabled_samsee|trigger=none}{code:language=javascript}
plugins.excelxport.exportEnabled = true;
var isEnabled = plugins.excelxport.exportEnabled;
{code}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:exportEnabled_link|text=|trigger=button}{sub-section}{div:class=sIndent}{tdsub-section:exportEnabled_link|trigger=none}{trsub-section}{tr:class=lastDetailRow}{tddiv}{td}{tr}{tbodybuilder-show}{tbody:id=importEnabled|class=node}{tr:id=namesam}{td}h6.importEnabled{td}{tr}{tr:id=des}{td}{*Sample*\\{sub-section:importEnabledexportEnabled_dessam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:importEnabledexportEnabled_dessam|trigger=none|class=sIndent}Enable the import feature of this plugin.{sub-section}{code:language=javascript}
plugins.excelxport.exportEnabled = true;
var isEnabled = plugins.excelxport.exportEnabled;
{code}{sub-section}{div}{td}{tr}{builder-showtr:permission=editclass=lastDetailRow}{td}{td}{tr:id=snc}{tdtbody}*Since*\\{sub-section:importEnabled_snc|text=|trigger=button}{sub-section{tbody:id=importEnabled|class=node}{tr:id=name}{td}h6.importEnabled{td}{tr}{tr:id=des}{td}{sub-section:importEnabled_des|text=|trigger=button}{sub-section}{sub-section:importEnabled_sncdes|trigger=none|class=sIndent}Enable Replace with version infothe import feature of this plugin.{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:importEnabled_prssnc|text=|trigger=button}{sub-section}{sub-section:importEnabled_prssnc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=retprs}{td}*ReturnsParameters*\\{sub-section:importEnabled_retprs|text=|trigger=button}{sub-section}{sub-section:importEnabled_retprs|trigger=none|class=sIndent}[Boolean]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=seeret}{td}*Also seeReturns*\\{sub-section:importEnabled_seeret|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:importEnabled_seeret|trigger=none|class=sIndent}[Boolean]{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linksee}{td}*ExternalAlso linkssee*\\{sub-section:importEnabled_linksee|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:importEnabled_linksee|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=samlink}{td}*SampleExternal links*\\{sub-section:importEnabled_samlink|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:importEnabled_samlink|trigger=none}{code:language=javascript}
plugins.excelxport.importEnabled = true;
var isEnabled = plugins.excelxport.importEnabled;
{code}{sub-section}{div}{td}{tr}{builder-show}{tr:classid=lastDetailRowsam}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=excelExport|class=node}{tr:id=name}{td}h6.excelExport*Sample*\\{sub-section:importEnabled_sam|text=|trigger=button}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tr:id=sigtbody}{tdtable}\\ 

{spantable: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}id=function|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{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=dessig}{td}{sub-section:excelExport_des|text=|trigger=button}{sub-section}{sub-section:excelExport_des|trigger=none|class=sIndent}Export to Excel data{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\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}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_sncStringArray_des|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_sncStringArray_des|trigger=none|class=sIndent}Export Replaceto withExcel version infodata{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prssnc}{td}*ParametersSince*\\{sub-section:excelExport-JSFoundSet_StringArray_prssnc|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_prsStringArray_snc|trigger=none|class=sIndent}foundSet
dataProviderIds
\[templateXLS\]
\[sheetName\]
\[startRow\]
\[startColumn\] Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:excelExport-JSFoundSet_StringArray_prs|text=|trigger=button}{sub-section}{sub-section: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}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:excelExport-JSFoundSet_StringArray_ret|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_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_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_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_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_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|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}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_des|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_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_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_des|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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}{tr:id=des}{td}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_des|text=|trigger=button}{sub-section}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_snc|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{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|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_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_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:excelExport-JSFoundSet_StringArray_byteArray_String_Number_sam|text=|trigger=button}{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}{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: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:excelExportexcelExport-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: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}
//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}