topic Re: Export to excel in QlikView

Export to excel

sibin_jacob — Sun, 27 Jan 2013 10:41:57 GMT

Hi,

I am not getting header when I am exporting straight table to excel. Is there any settings to get the staright table header also in exporting to excel functionality?

Thanks,

Sibin Jacob.c

Re: Export to excel

Mon, 28 Jan 2013 09:49:07 GMT

I think You can't do it by an argument of CopyTableToClipboard

but

You can copy Label and then copy whole chart (without label)

try this code:

sub ExportExcel()

'create Excell

Set xlApp = CreateObject("Excel.Application")

xlApp.Visible = true

Set xlDoc = xlApp.Workbooks.Add()

Set xlSheet = xlDoc.Worksheets.Add

Set SheetObj = ActiveDocument.GetSheetObject("CH01")

'copy Label

chartCaption = SheetObj.GetCaption.Name.v

xlSheet.Range("A1") = chartCaption

'copy table content

SheetObj.CopyTableToClipboard true

xlSheet.Range("A2").PasteSpecial Paste = xlPasteValues

End sub

Re: Export to excel

sibin_jacob — Thu, 31 Jan 2013 18:22:33 GMT

Thanks pari, I need to know is there any option for exporting to excel without using macro ?

I need header of the table also...

Thanks,

Sibin Jacob.c