topic Re: How to export data in excel file from a classical report along with chart title. in QlikView

How to export data in excel file from a classical report along with chart title.

debanjan_k — Wed, 25 Nov 2020 16:16:04 GMT

How to export data in excel file from a classical report along with chart title.

Re: How to export data in excel file from a classical report along with chart title.

pooja_prabhu_n — Mon, 10 Sep 2018 05:38:42 GMT

Hi,

You can try using macros

Refer this link for more information:

How to export to Excel include Title Caption?

Thanks,

Pooja

Re: How to export data in excel file from a classical report along with chart title.

boraste-sagar — Mon, 10 Sep 2018 05:49:10 GMT

You could create a text object and make it look similar to the title, but you cannot export the title without macros.

Sub ExcelExpwCaption

'Set the path where the excel will be saved

filePath = "E:\TestBB.xls"

'Create the Excel spreadsheet

Set excelFile = CreateObject("Excel.Application")

excelFile.Visible = true

'Create the WorkBook

Set WorkBook = excelFile.WorkBooks.Add

'Create the Sheet

Set Sheet = WorkBook.WorkSheets(1)

'Get the chart we want to export

Set tableToExport = ActiveDocument.GetSheetObject("LB02")

Set chartProperties = tableToExport.GetProperties

tableToExport.CopyTableToClipboard true

'Get the caption

chartCaption = tableToExport.GetCaption.Name.v

'MsgBox chartCaption

'Set the first cell with the caption

Sheet.Range("A1") = chartCaption

'Paste the rest of the chart

Sheet.Paste Sheet.Range("A2")

excelFile.Visible = true

'Save the file and quit excel

WorkBook.SaveAs filePath

WorkBook.Close

excelFile.Quit

'Cleanup

Set WorkBook = nothing

Set excelFile = nothing

End Sub

Re: How to export data in excel file from a classical report along with chart title.

debanjan_k — Mon, 10 Sep 2018 06:00:25 GMT

Actually I want a generic solution for all classical reports used in my qlikview application not for a single or particular fixed classical report.

Re: How to export data in excel file from a classical report along with chart title.

boraste-sagar — Mon, 10 Sep 2018 06:02:12 GMT

will try and l.u.k