Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
helbre
Contributor
Contributor

QV to excel 2010?

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

8 Replies
khadeer_sparks
Specialist
Specialist

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

helbre
Contributor
Contributor
Author

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?

multiview
Creator II
Creator II

Yes, this is possible in v11.

Regards

MultiView

kouroshkarimi
Creator III
Creator III

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.

helbre
Contributor
Contributor
Author

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

kouroshkarimi
Creator III
Creator III

Yes as far as I am aware.

multiview
Creator II
Creator II

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
Contributor III
Contributor III

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