topic Re: Qlikview Excel exporting issue in QlikView

Qlikview Excel exporting issue

sfloberg — Thu, 04 May 2017 16:03:04 GMT

I used to be able to export all tables (up to 1000k) from QlikView to Excel.

Now I have gotten a new computer and when I export files over 65k then open up in CSV format insted of Exceö. How come?

Is it Excel or QlikView that is the problem? How can I fix it?

Anonymous — Thu, 04 May 2017 16:04:51 GMT

just save the csv file in Excel as xlsx

I think they decided to export it to csv because xlsx is also limited by number of rows and columns

Digvijay_Singh — Thu, 04 May 2017 16:06:48 GMT

check this out -

sfloberg — Thu, 04 May 2017 16:31:00 GMT

You mean rename the CVS-file to filename.xlsx?

Anonymous — Thu, 04 May 2017 16:31:59 GMT

no, open the csv with Excel --> save as --> select filetype xlsx --> save

sfloberg — Thu, 04 May 2017 16:39:37 GMT

I can try it. But how come I could open bigger files before? It should work the same now.....

Anonymous — Thu, 04 May 2017 16:44:18 GMT

I've never seen QlikView exporting natively to xlsx.

Could it be that Excel was the default opening program for csv files on the other computer?!?

If export from QlikView to Excel and the rownumber is >65k , Excel opens the csv, then I save it as xlsx...