excelxport

Unknown macro: {sub-section}

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

Unknown macro: {table}

{column:padding=0px|width=80px}{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:padding=0px|width=80px}{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, [templateXLS], [sheetName], [startRow], [startColumn])
Export to Excel data

Unknown macro: {table}

{column:padding=0px|width=100%}{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}

Unknown macro: {sub-section}

Enable the export feature of this plugin.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Boolean

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

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}

Unknown macro: {sub-section}

Enable the import feature of this plugin.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Boolean

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

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

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {table}

{column:padding=0px|width=100%}{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, [templateXLS], [sheetName], [startRow], [startColumn])

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Export to Excel data

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

foundSet
dataProviderIds
[templateXLS]
[sheetName]
[startRow]
[startColumn]

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

byte[]

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

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

No labels

Child pages

excelxport

exportEnabled

importEnabled

excelExport