topic Need Export to Excel to open Excel 2007 in QlikView

Need Export to Excel to open Excel 2007

Thu, 30 Apr 2009 01:53:02 GMT

Hey guys. I have a table with 100k+ rows that I want to export to Excel. I have Excel 2007 installed, but Qlikview always opens up in Compatibility Mode, so I'm still getting the 65k row limit. How do i configure Qlikview to open up in regular 2007 mode so I can load all the rows in one sheet? Thanks!

Need Export to Excel to open Excel 2007

yblake — Thu, 30 Apr 2009 02:58:46 GMT

did you try to use an export "button" object ?

Need Export to Excel to open Excel 2007

Wed, 27 May 2009 14:47:38 GMT

Hi!

I have the same problem. I need to save all excel files to 2007 format (I need more than 65k rows), right now it's done automatically useing macro. What should I do to save exported files to 2007 excel *.xlsx

I tried to change *.xls to *.xlsx but then excel could not open thouse files.

My macro:

ActiveDocument.Fields("Location").Clear
Set myList = ActiveDocument.Fields("Location").GetPossibleValues

for i = 0 to myList.Count - 1

ActiveDocument.Fields("location").Select myList.Item(i).text
strName = "F:\QlikView\" & UseSystemDateTime & "_" & "asukoht_" & myList.Item(i).text & ".xls"
set obj=ActiveDocument.GetSheetObject("CH15")
obj.exportBiff "F:\QlikView\" & year(now())&"."& month(now()) &"."& day(now()-1) & "_" & "location_" & myList.Item(i).text & ".xls"

Need Export to Excel to open Excel 2007

Thu, 28 May 2009 16:28:40 GMT

Anyone?

Need Export to Excel to open Excel 2007

Wed, 17 Jun 2009 01:04:55 GMT

Hi , i am also facing the same problem . Can somebody throgh some light on it..

Need Export to Excel to open Excel 2007

Wed, 17 Jun 2009 02:09:45 GMT

I asked QV the exact same question and the answer was that they are using BIFF formats to export so the 64k row limit is in effect even if you are exporting to Excel 07.

They have added to the "nice to have" features for a future release.

Regards,

Bruce

Need Export to Excel to open Excel 2007

Wed, 17 Jun 2009 03:02:04 GMT

Hi,

you can export it to a CSV and then import it to Excel. Not a nice solution, but it works.

Regards

Christian

Need Export to Excel to open Excel 2007

Wed, 17 Jun 2009 12:49:37 GMT

Yes, that is a solution, but csv removes all formats. For example if some numbers are starting with zeros, csv removes them and so on.

Feedback for QV about this nice to have. In small countries like I'm living is excel 2003 like windows 98

Need Export to Excel to open Excel 2007

Fri, 25 Feb 2011 20:18:45 GMT

We also need this feature, I would have thought with QV10 (latest SR1) that the XL button would open up in regular excel instead of compatability mode??? QlikTech...where are you on this???

Re: Need Export to Excel to open Excel 2007

Thu, 09 Oct 2014 14:42:47 GMT

2014 and QlikView 11 and still only supports opening xls....seriously!!!!