excel export with column header and date column

Classic Servoy
1

Hello Everybody

From a given tableview form foundset i can copy data to excel with this:

var vfs   = forms.Auswahl_Kontakte.foundset;
 var vdp   = ["rbkontaktid","rbkontakt_to_rbobjekte.name1","rbkontakt_to_rbobjekte.objektbezeich","rbeingangsdatum","rbkontaktart","rbkontaktmelder","rbkontakttext"]
 var vfile = plugins.file.showFileSaveDialog("Kontakt_Export.xls");

 var vbytes = plugins.excelxport.excelExport(vfs, vdp); 
 plugins.file.writeFile(vfile, vbytes);

2 problems:
a)
Now i want to set different column headers:
rbkontakt_to_rbobjekte.name1 = Name
rbkontakt_to_rbobjekte.objektbezeich = Bezeichnung
b)
In my excel file the rbeingangsdatum ( a timestamp in my database ) is shown like this “16 Jan.”
I need the full timestamp “16.01.2012 16:43:17”

How to do this with servoy 6.0.7???

Best regards
Albert

2

HI Albert,

b) I think the data is in the Excelsheet,
did you try change the date column in EXCEL to a different notation? (timestamp)

3

Hello Harjo

Yes, but …
The excel file is for our customers. They can download it from our ticket-portal.
I don’t want to tell them:
Download, then correct the column headers, then format the columns containing a timestamp, then…

Regards
Albert