File Name (Optional) is not working about sense-export

[lilianvallon]

Same here.
Optionnal name doesn't work.....
Tested on windows with IE and Firefox.
And i just want to define a static value, like file.xlsx instead of having an ID.

[rickpostprovelu]

We have the same problem. In the code we can see that the 'File name (optional)' is currently only possible in the 'CSV Tab separated' and with the 'CSV - Client side' options.

We checked this and it seems that only exporting to 'CSV - Client side' is working properly. The Tab separated file is probably deprecated since the last commit.

I will let you know if we found a fix for naming the exported Excel files.

[rickpostprovelu]

So, here is the answer about the filename exporting not working.

In short: It only works in Qlik Sense Desktop.

Long story:
For the options Open XML, Tab separated and Comma separated it uses the parameter qFileName. This option is only available in QS Desktop. To avoid this problem Stefan used a 3rd party code called FileSaver to export his function. In this function he collects all data and defined the styling for every row in a loop. This way you can make 'easily' a CSV-comma separated or tab separated. But an Excel file is too complicated to remake.

So the conclusion: In QS Enterprise only the client-side format works for naming to export.

See click documentation about the ExportData method used in this extension.
https://help.qlik.com/en-US/sense-developer/April2019/apis/EngineAPI/services-GenericObject-ExportData.html