Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Just curious, why export to xls?
Business user wants to export to excel, maybe to send the report to outside user.
Suggestion:
You can export sheet objects as image.
Outside user may deal -manipulate- with this data