{div: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 AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR{div} {div:id=description}This plugin allows the enabling/disabling of the Smart Client menuitems that expose the generic Excel import/export logic{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}{tr:id=name}{td}h6.exportEnabled{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[Boolean]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} plugins.excelxport.exportEnabled = true; var isEnabled = plugins.excelxport.exportEnabled; {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=importEnabled}{tr:id=name}{td}h6.importEnabled{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[Boolean]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} plugins.excelxport.importEnabled = true; var isEnabled = plugins.excelxport.importEnabled; {code}{div}{td}{tr}{tr:class=lastDetailRow}{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=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){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 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}byte[]{div}{td}{tr}{tr:id=sam}{td}*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}{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){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 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}byte[]{div}{td}{tr}{tr:id=sam}{td}*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}{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){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 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}byte[]{div}{td}{tr}{tr:id=sam}{td}*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}{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){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:id=sam}{td}*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}{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=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 \{[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}{tr:id=sam}{td}*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}{table} |