topic Re: QV to excel 2010? in QlikView

QV to excel 2010?

Anonymous — Wed, 30 Jan 2013 07:48:10 GMT

We want QV to export to excel 2010. Is that possible in a newer release? We use 10

Re: QV to excel 2010?

khadeer — Wed, 30 Jan 2013 07:59:53 GMT

Qv expoerts into excel, and it will open on that version which u installed in ur server.

Re: QV to excel 2010?

Anonymous — Wed, 30 Jan 2013 08:09:13 GMT

We have excel 2010 installed both on the server where we run our applications and our users have it installed on their pc:s but the format is stil ____.xls when we export instead of ____.xlsx

Have you got any tips on how to fix this?

Re: QV to excel 2010?

Anonymous — Wed, 30 Jan 2013 09:45:51 GMT

Yes, this is possible in v11.

Regards

MultiView

Re: QV to excel 2010?

kouroshkarimi — Wed, 30 Jan 2013 09:59:34 GMT

QV version 10 & 11 will export an .xls file which is compatible with Excel 2010. It should open in whatever program windows has associated with the .xls extension.

Re: QV to excel 2010?

Anonymous — Wed, 30 Jan 2013 11:06:54 GMT

Ok, so it will always be exported with the .xls extension regardless of QV Version?

Re: QV to excel 2010?

kouroshkarimi — Wed, 30 Jan 2013 11:10:50 GMT

Yes as far as I am aware.

Re: QV to excel 2010?

Anonymous — Fri, 01 Feb 2013 10:37:13 GMT

As of version 11, QlikView default export to excel support only xls format. You can put a seperate button on top of the table with its action set to execute the macro below.

Sub exportExel

set ExcelSheetApp = CreateObject("Excel.Application")
ExcelSheetApp.Visible = false

set ExcelWB= ExcelSheetApp.Workbooks.Add
ExcelWB.Sheets(1).name = "QV-Export"
set XLSheet = ExcelWB.Worksheets(1)
set QVData = ActiveDocument.GetSheetObject("CH01")

set XLSheet = ExcelWB.Worksheets(1)
QVData.CopyTableToClipboard true

XLSheet.Paste XLSheet.Range("A1")

ExcelWB.SaveAs "C:\(path)\temp.xlsx", 51

ExcelWB.Close
ExcelSheetApp.Application.Quit

End Sub

The key bit in this macro is the fileformat is 51. For the complete list of file types please click here

Make sure you provide a valid path for this to save the temp.xlsx file successfully.

I hope this helps!

Regards

MultiView

Re: QV to excel 2010?

heimo_ernst_wei — Thu, 14 Feb 2013 10:03:55 GMT

Thanks for this nice idea!

It works fine when I am working in QV11 for Windows.

However in the web-browser (IE) I get an error message:

QlikOcx

Macro parse failes. Functionality was lost

Export Excel

Error: Pase method of Worksheet class failed