Page History

{div:style=}

Wiki Markup

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.

\\ \\ Enter additional information related to this

Enter additional information related to this 'class'

inside

the

\

{div}

macro

with

'id=description'

{div} {div:id=description}This plugin allows the

Div

id	description

This plugin allows the enabling/disabling

...

of

...

the

...

Smart

...

Client

...

menuitems

...

that

...

expose

...

the

...

generic

...

Excel

...

import/export

...

logic

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

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
byte[]

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
byte[]

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
byte[]

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

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

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

); {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

);

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray

}{

Table Row (tr)

:

id

=

	name

}{td}h6.excelExport{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}

byte[]

{span}{span:style=

Span

style	font-weight:

bold;

}

excelExport

{span}{span}\

Span
(foundSet,

dataProviderIds,

templateXLS)

{span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Export to Excel data{div}{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 \

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 {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}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray_String

}{

Table Row (tr)

:

id

=

	name

}{td}h6.excelExport{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}

byte[]

{span}{span:style=

Span

style	font-weight:

bold;

}

excelExport

{span}{span}\

Span
(foundSet,

dataProviderIds,

templateXLS,

sheetName)

{span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Export to Excel data{div}{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 \

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 {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}

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray_String_Number

}{

Table Row (tr)

:

id

=

	name

}{td}h6.excelExport{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}

byte[]

{span}{span:style=

Span

style	font-weight:

bold;

}

excelExport

{span}{span}\

Span
(foundSet,

dataProviderIds,

templateXLS,

sheetName,

startRow)

{span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Export to Excel data{div}{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 \

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

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)

; {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	excelExport-JSFoundSet_StringArray_byteArray_String_Number_Number

}{

Table Row (tr)

:

id

=

	name

}{td}h6.excelExport{td}{tr}{tr:id=sig}{td}{span:style=

Table Cell (td)
excelExport

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right:

5px;

}

byte[]

{span}{span:style=

Span

style	font-weight:

bold;

}

excelExport

{span}{span}\

Span
(foundSet,

dataProviderIds,

templateXLS,

sheetName,

startRow,

startColumn)

{span}{td}{tr}{tr:id=des}{td}{div:class=sIndent}Export to Excel data{div}{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 \

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

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

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 24

New Version 25

Key

exportEnabled

importEnabled

excelExport

excelExport

excelExport

excelExport

excelExport