QV to excel 2010?

[Anonymous]

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

[khadeer]

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

[Anonymous]

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?

[Anonymous]

Yes, this is possible in v11.

Regards

MultiView

[kouroshkarimi]

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.

[Anonymous]

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

[kouroshkarimi]

Yes as far as I am aware.

[Anonymous]

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

[heimo_ernst_wei]

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