Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-06 07:32 AM

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

2,830 Views
0 Likes
4 Replies
davidstrong
Contributor
Contributor
‎2018-02-09 08:36 AM

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

1,976 Views
0 Likes
william_denholm
Contributor III
Contributor III
‎2018-02-16 11:29 AM

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

1,976 Views
0 Likes
azimabadi
Creator III
Creator III
‎2018-04-09 10:31 AM

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!

1,976 Views
0 Likes
p_verkooijen
Partner - Specialist
Partner - Specialist
‎2018-04-23 07:04 AM

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
1,976 Views
0 Likes