macro ExportEx excel, no columns header...

[dariof]

Hello.

I've a problem with Qlikview and the exporting to Excel via macro with obj.ExportEx.

We have Qlikview Server (11.20 SR17) but the exporting is done by a Windows Server schedule and a cmd with "C:\Program Files\QlikView\Qv.exe" /r "D:\test.qvw" (because exporting it is fired by reload and on QVS there is no other way, at least that I know, to fire the OnReload macro).

The code is simple and it is like this:

ActiveDocument.ClearAll false
ActiveDocument.Fields("DATE").Select "*"
set obj = ActiveDocument.GetSheetObject("CH613")
obj.ExportEx "c:\test.xls", 5

but on the exported Excel there is no header!!!

I read many forum posts about delete the header, that the header is present by default and so on...but I have the opposite problem.

Any idea?

Thanks.

[dariof · Accepted solution]

Ciao to everyone.

I've tried the suggestions that you gave to me (no updating Qlik server), but the only one that worked was to recreate from scratch the graph!

Now I can export (XLS or CSV) with the header without problems.

Thank you very much for your help.

Dario