Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
gustavogerminar
Contributor
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
Contributor
Contributor

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

william_denholm
Contributor III
Contributor III

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

azimabadi
Creator III
Creator III

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!

p_verkooijen
Partner
Partner

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