Issue with Export to Excel

[riyazasma1009]

Hi All,

I have a pivot table as shown in the attachment. When I export this table to excel, the first row in which columns are merged together, does not come in the expected format in the exported excel.

Can someone please help me with this?

Thanks,

Asma

[alexandros17]

If you are using plugin try to install it again, it is not a Qlik problem but an excel or browser problem so take a look to these app. settings

[riyazasma1009]

Hi Alessandro,

Thanks for your quick reply!!

I am trying to export it to excel from my local QV Desktop itself. I am not opening it through browser.

Could you please let me know if there any settings that need to be done either in excel or in Qlikview to get the table exported in the same format.

Thanks,

Asma

[Mark_Little]

Hi,

Can you give a little more information. What exactly is the problem that you're seeing?

Mark

[riyazasma1009]

Hi Mark,

The table as present in Qlikview is as shown below:

After exporting to excel, it gets exported in the below format:

The merging of columns is lost.

Could you please let me know if I have missed out any settings that need to be done.

Thanks,

Asma

[settu_periasamy]

Hi,

If it is small table / Summary, Just Copy To ClipBoard -> FULL Table, And paste it in your excel. You will get the exact format.

[Mark_Little]

Hi,

I am sorry i am not sure you can change it,I am having a play now.

I get the same problem when exporting a pivot table, i think this is just the way it passes of the data to excel.

Mark

[riyazasma1009]

Hi,

After copying the data to clipboard and then pasting it in excel, works fine. But we want this sort of functionality to be achieved by using the in-built Export to Excel option. Users are mainly interested in exporting it using the export to excel icon and they want the same structure to be exported in excel as in exists in QV.

Is it possible in QV or is there any workaround for the same.

Thanks,

Asma

[riyazasma1009]

Hi Mark,

Thanks for the reply!

Is there any workaround available for the same.

Thanks,

Asma

[PradeepReddy]

try this macro, under button actions... Replace the object names with desired....

Merging cells while exporting to excel

sub xport2xl()

iRow = 1

set xlApp = CreateObject("Excel.Application")

xlApp.Visible = True

set xlWB = xlApp.Workbooks.Add

set xlSheet = xlWB.Worksheets(1)

set obj = ActiveDocument.getsheetobject(ChartName)

xlSheet.Activate

xlSheet.Cells.Clear

set txt = ActiveDocument.GetSheetObject("CH132")

txt.CopytableToClipboard TRUE

xlSheet.Cells(iRow,1).Select

xlSheet.Paste

while not (isempty(xlSheet.Cells(iRow,1)))

iRow = iRow+2

wend

set txt1 = ActiveDocument.GetSheetObject("CH132")

txt1.CopytableToClipboard TRUE

xlSheet.Cells(iRow,1).Select

xlSheet.Paste

end sub