excelxport

Unknown macro: {div}

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 'class' inside the {div} macro with 'id=description'

Unknown macro: {div}

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

Unknown macro: {table}

{column:width=80px|padding=0px}{column}{column}{column}

Unknown macro: {tr}

Unknown macro: {th}

Property Summary

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Boolean

Unknown macro: {td}

exportEnabled
Enable the export feature of this plugin.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Boolean

Unknown macro: {td}

importEnabled
Enable the import feature of this plugin.

Unknown macro: {table}

{column:width=80px|padding=0px}{column}{column}{column}

Unknown macro: {tr}

Unknown macro: {th}

Method Summary

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

byte[]

Unknown macro: {td}

excelExport(foundSet, dataProviderIds)
Export to Excel data

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

byte[]

Unknown macro: {td}

excelExport(foundSet, dataProviderIds, templateXLS)
Export to Excel data

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

byte[]

Unknown macro: {td}

excelExport(foundSet, dataProviderIds, templateXLS, sheetName)
Export to Excel data

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

byte[]

Unknown macro: {td}

excelExport(foundSet, dataProviderIds, templateXLS, sheetName, startRow)
Export to Excel data

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

byte[]

Unknown macro: {td}

excelExport(foundSet, dataProviderIds, templateXLS, sheetName, startRow, startColumn)
Export to Excel data

Unknown macro: {table}

{column:width=100%|padding=0px}{column}

Unknown macro: {tr}

Unknown macro: {th}

Property Details

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

exportEnabled

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Boolean

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

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

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

importEnabled

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

Boolean

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

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

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {table}

{column:width=100%|padding=0px}{column}

Unknown macro: {tr}

Unknown macro: {th}

Method Details

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

excelExport

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

byte[]

Unknown macro: {span}

excelExport

Unknown macro: {span}

(foundSet, dataProviderIds)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

byte[]

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

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

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

excelExport

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

byte[]

Unknown macro: {span}

excelExport

Unknown macro: {span}

(foundSet, dataProviderIds, templateXLS)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{JSFoundSet} foundSet – the foundset on which to export
{String[]} dataProviderIds – the ids of the dataproviders
{byte[]} templateXLS – the xls template to export in

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

byte[]

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

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

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

excelExport

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

byte[]

Unknown macro: {span}

excelExport

Unknown macro: {span}

(foundSet, dataProviderIds, templateXLS, sheetName)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{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

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

byte[]

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

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

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

excelExport

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

byte[]

Unknown macro: {span}

excelExport

Unknown macro: {span}

(foundSet, dataProviderIds, templateXLS, sheetName, startRow)

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{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

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

byte[]

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

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

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

excelExport

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

byte[]

Unknown macro: {span}

excelExport

Unknown macro: {span}

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

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {div}

{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

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {div}

byte[]

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {div}

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

Unknown macro: {tr}

Unknown macro: {td}

Child pages

excelxport

exportEnabled

importEnabled

excelExport

excelExport

excelExport

excelExport

excelExport