Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

gustavogerminar
New Contributor

Export to excel .xlsx on QV server 12.2

Good mornning, I update QV server from 11.2 to 12.2  because we need export 200.000 rows to Excel .

QlikView November 2017 - the latest feature release for QlikView - 12.20.   New features including:

  • Analytic Connections
  • WebClient improvements
  • Shared file stability improvements
    • Shared file cleaning
  • PGO buffering - improved user experience and performance
  • Export in XLSX format

after update when clik export  to Excel in a grid still apears xls format.

Could you help me?

Thanks

4 Replies
davidstrong
New Contributor

Re: Export to excel .xlsx on QV server 12.2

Is the export to xlsx feature something we need to enable? If so, how and were?

Highlighted
william_denholm
New Contributor III

Re: Export to excel .xlsx on QV server 12.2

Getting the same issue, is there a setting somewhere to use XLSX?

azimabadi
Contributor III

Re: Export to excel .xlsx on QV server 12.2

I have the same problem! It is very "strange" that on the same server, two clients with the same Excel version do the same thing differently!

With a client export to excel results a xlsx, but another client exports as xls!

Funny, isn't it?

And nobody has answered the question since Feb. 6, 2018!

Partner
Partner

Re: Export to excel .xlsx on QV server 12.2

Check the Easter egg function SendToExcelLegacyFormat=1 for exports to xls instead of xlsx

  • QV Server : Settings.ini
  • QV client -> help -> About QlikView -> right click Qlik icon