The Xport menu enabler plugin provides tools for exporting and importing data to and from Excel files, offering flexibility in managing worksheets, templates, and data structures. It supports enabling or disabling export and import functionalities through its exportEnabled and importEnabled properties, allowing seamless integration into applications. ## Primary Method
The plugin’s primary method, excelExport, facilitates exporting data from specified data sources to Excel files. Users can customize the process by:
Choosing data attributes
Applying templates
Setting sheet names
Defining column headers
Specifying starting rows and columns This ensures structured and well-formatted Excel outputs tailored to specific requirements.
Features
With features like template support, custom headers, and flexible positioning, excelxport simplifies the interaction with Excel files. It enhances workflows by enabling dynamic data handling and output formatting, making it an essential tool for data-driven applications requiring Excel integration.
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);
//export in new byte arrayvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name']);//export by adding to templateXLS in default (new) 'Servoy Data' worksheetvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS);//export by adding to templateXLS, in 'mySheet' worksheet, starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet');//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name' starting at default(1/1) row/columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name']);//export by adding to templateXLS, in 'mySheet' worksheet, starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet',3,5);*//export by adding to templateXLS, in 'mySheet' worksheet, with column names 'ID' and 'Name', starting at 3rd row and 5th columnvar bytes =plugins.excelxport.excelExport(forms.form1.foundset, ['id','name'],templateXLS,'mySheet', ['ID','Name'],3,5);