Page History

...

HTML Table

id
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 exportEnabled Enable the export feature of this plugin.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

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

HTML Table

id
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 excelExport(foundSet, dataProviderIds) Export to Excel data

Table Body (tbody)

tbody

Table Row (tr)

Table Cell (td)
byte[]

Table Cell (td)
#excelExport excelExport(foundSet, dataProviderIds, templateXLS) Export to Excel data

Table Row (tr)

Table Cell (td)
byte[]

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

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
byte[]

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

Table Row (tr)

Table Cell (td)
byte[]

Table Cell (td)
#excelExport 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

Table Row (tr)

id	name

Table Cell (td)
exportEnabled

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Enable the export feature of this plugin.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

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

Table Row (tr)

id	name

Table Cell (td)
importEnabled

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Enable the import feature of this plugin.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

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-JSFoundSet_StringArray

Table Row (tr)

id	name

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

byte[]

Span

style	font-weight: bold;

excelExport

Span
(foundSet, dataProviderIds)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Export to Excel data

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{JSFoundSet} foundSet

...

- the foundset on which to export
{String[]} dataProviderIds

...

- the ids of the dataproviders

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

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)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray

Table Row (tr)

id	name

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

byte[]

Span

style	font-weight: bold;

excelExport

Span
(foundSet, dataProviderIds, templateXLS)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Export to Excel data

Table Row (tr)

id	prs

Table Cell (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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

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)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray_String

Table Row (tr)

id	name

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

byte[]

Span

style	font-weight: bold;

excelExport

Span
(foundSet, dataProviderIds, templateXLS, sheetName)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Export to Excel data

Table Row (tr)

id	prs

Table Cell (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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

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)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray_String_Number

Table Row (tr)

id	name

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

byte[]

Span

style	font-weight: bold;

excelExport

Span
(foundSet, dataProviderIds, templateXLS, sheetName, startRow)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Export to Excel data

Table Row (tr)

id	prs

Table Cell (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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

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)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number

Table Row (tr)

id	name

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

byte[]

Span

style	font-weight: bold;

excelExport

Span
(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Export to Excel data

Table Row (tr)

id	prs

Table Cell (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

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

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 25

New Version 26

Key

exportEnabled

importEnabled

excelExport

excelExport

excelExport

excelExport

excelExport