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

This plugin allows the enabling/disabling of the Smart Client menuitems that expose the generic Excel import/export logic

HTML Table

class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#exportEnabled Enable the export feature of this plugin.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#importEnabled Enable the import feature of this plugin.

HTML Table

class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
byte[]

Table Cell (td)
#excelExport(foundSet, dataProviderIds, [templateXLS], [sheetName], [startRow], [startColumn]) Export to Excel data

HTML Table

id	property
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Property Details

Table Body (tbody)

id	exportEnabled
class	node

Table Row (tr)

id	name

Table Cell (td)
exportEnabled

Table Row (tr)

id	des

Table Cell (td)
Enable the export feature of this plugin.

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

plugins.excelxport.exportEnabled = true;
var isEnabled = plugins.excelxport.exportEnabled;

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	importEnabled
class	node

Table Row (tr)

id	name

Table Cell (td)
importEnabled

Table Row (tr)

id	des

Table Cell (td)
Enable the import feature of this plugin.

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

plugins.excelxport.importEnabled = true;
var isEnabled = plugins.excelxport.importEnabled;

Table Row (tr)

class	lastDetailRow

Table Cell (td)

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	excelExport
class	node

Table Row (tr)

id	name

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

byte[]

Span

style	float: left; font-weight: bold;
id	iets

excelExport

Span

style	float: left;
id	iets

(foundSet, dataProviderIds, [templateXLS], [sheetName], [startRow], [startColumn])

Table Row (tr)

id	des

Table Cell (td)
Export to Excel data

Table Row (tr)

id	prs

Table Cell (td)
Parameters foundSet dataProviderIds [templateXLS] [sheetName] [startRow] [startColumn]

Table Row (tr)

id	ret

Table Cell (td)
Returns byte[]

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

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);

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 16

New Version Current

Key

exportEnabled

importEnabled

excelExport