topic Re: Export To Excel in QlikView

Export To Excel

Sat, 28 Feb 2015 09:44:06 GMT

HI all

I have a straigth table and iam using the MAcro to export it to excel which i found in the community ,After runing this i get the straight table exported to excel as it is .

I also have the list box (LT02) by name Region in the dashboard.and there is one more list box (LT10) by Branches

the macro iam using and the code for it is :

sub ExportToExcel_Divisionwise

Dim CLApp, XLDoc,XLSheet

set XLApp = CreateObject("Excel.Application") ' Define Object

XLApp.Visible = True 'Visible set as true

set XLDoc = XLApp.Workbooks.Add 'Open new workbook

set XLSheet = XLDoc.Worksheets.Add

ActiveDocument.GetSheetObject("CH09").CopyTableToClipboard TRUE

XLSheet.paste

this will give me the data like this attachment

But i want the second row of the generated excel to show me the Regions from the Region List Box and third row should show me the Branches from Branche List Box .

Thanks in Advance

Re: Export To Excel

fkeuroglian — Sat, 28 Feb 2015 14:02:39 GMT

Hi,

i see the macro works ok, export the table CH09 as you have in qlikview? you want to export some list box too?

what are the region and branch in your qlikview document?

is there export the object as you see in qlikvew? you want to add some object in the excel export?

Re: Export To Excel

Sat, 28 Feb 2015 19:14:38 GMT

HI fernando Thanks for the reply

Iam attching my qlikview file , U can see there i have Region And Branches ,

When export to Excel the first row should have the all Headers and second row in the excel should be region and the third row should be Branches .

I hope iam clear ,

Thanks in advance

Re: Export To Excel

fkeuroglian — Sun, 01 Mar 2015 19:10:34 GMT

Hi, no attached qvw in your respond

attach again ,thank you

Fernando

Re: Export To Excel

Mon, 02 Mar 2015 04:38:39 GMT

Thanks Fernando For ur reply ,

PLease find the attachement of the QVW