Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dhirajkumar
Contributor

Same Formating of qlikview pivot table in Excel

Hi Everyone,

Here in qlikview I want to send a pivot table in Excel but in excel its not showing the same formatting  as in qlikview .

I'm attaching image and qvw file . Please anyone give me some solution that  we can fixed the Issue.

5 Replies

Re: Same Formating of qlikview pivot table in Excel

Hi,

I cannot access the file its corrupted.

But below macro will do the job.

  1. sub Export
  2.     set XLApp = CreateObject("Excel.Application") ' Define Object 
  3.         XLApp.Visible = True 'Visible set as true 
  4.         set XLDoc = XLApp.Workbooks.Add 'Open new workbook     
  5.         set table = ActiveDocument.GetSheetObject("TB04") 
  6.         rem set table = ActiveDocument.GetSheetObject("MB01") 
  7.         
  8.     set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted 
  9.         table.CopyTableToClipboard true 'Copy data to Clipboard
  10.         XLSheet.Paste XLSheet.Range("A1") 'Paste data into cell
  11.     
  12. end sub

Change the object ID's accordingly.

Regards

ASHFAQ

dhirajkumar
Contributor

Re: Same Formating of qlikview pivot table in Excel

Hi Ashfaq,

Thanks for the reply but here I'm not able to run this code . when we put the object id of pivot table in  place of TB04 then what we should put the id object in place of MB01.

Re: Re: Same Formating of qlikview pivot table in Excel

Hi

Please have a look at the attached application

Also make sure you give system access to Macro in module as per the attached image.

Hope it helps

Regards

ASHFAQ

dhirajkumar
Contributor

Re: Re: Same Formating of qlikview pivot table in Excel

Thank you so much ashfaq now its working...

Re: Same Formating of qlikview pivot table in Excel

Hi,

If it works, Please close the thread by selecting appropriate answer.

Regards

ASHFAQ