excelxport plugin - how does it work?

Classic Servoy
1

I’ve been trying to get the excelxport plugin to work, but I think I’m missing something.
There’s a foundset on my form and then I run this script:

var fs, dp, file, bytes;
fs = forms.form_report.foundset;
dp = ["debnr","company_name"];
file = plugins.file.showFileSaveDialog("ServoyExport.xls");
bytes = plugins.excelxport.excelExport(fs, dp);
plugins.file.writeFile(file, bytes);

It prompts to save the file but when I open the Excel file there’s ony the header with the specified column names and no data.
What am I doing wrong?

Regards,

Marco

2

Is your foundset empty?
Do you need to do a fs.loadAllRecords() ?

3

Hi Thomas,

No, my foundset isn’t empty.
Do you know if the column names in Excel should match the column names in the database?

Regards,

Marco

4

yes, they should match!