topic Re: Export to MS Excel 2010 in QlikView

Export to MS Excel 2010

Thu, 10 Nov 2011 08:51:52 GMT

Hi,

I have QlikView 9. When exporting to excel, it considers the old excel sheet number of records -65000-, so if the report more than 65000, it distributes the result into multiple sheets.

Is there a way to export to xlsx format, by other hand, exporting to excel with new excel version -2007 or 2010- that allows more than a milion record?

Thanks in advance.

Export to MS Excel 2010

Thu, 10 Nov 2011 08:56:26 GMT

Hi, I had the same problem, but with office 2007 and QV10 SR1, once I updated it to QV10 SR3, I started to get the exports that exceed the 65 536 records as csv. And in csv it is all in one sheet. The only problem is that in csv there is no cyrillic support for me and so I get all cyrillic values as ????. if u have no t3ext in other then the standart characters it is ok to update and just start getting the csv exports instead of the xls.

Hope this helped you.

Re: Export to MS Excel 2010

Thu, 10 Nov 2011 09:03:46 GMT

Ahh, just remember I tryed to use this function in vbscript:

sub Excel
set obj = ActiveDocument.GetSheetobject("SO  Table - Нов")
obj.exportbiff("C:\Test1.xlsx")
obj.Export "C:\Test2.xlsx",","  //if not mistaken this one needs the file to exist.
end sub

These where the two ways I have found people used to create the xlsx exports,

but it didn't work for me. It just didn't create any valid excel files for me.

Hope it will help you.

Export to MS Excel 2010

Michiel_QV_Fan — Thu, 10 Nov 2011 10:25:41 GMT

Just curious, why export to xls?

Export to MS Excel 2010

Mon, 14 Nov 2011 07:41:31 GMT

Business user wants to export to excel, maybe to send the report to outside user.