topic Additional Empty space created with the values while exporting to excel using macro in QlikView

Additional Empty space created with the values while exporting to excel using macro

Wed, 28 Jun 2017 13:15:22 GMT

i Am trying to export excel from qlikview using macro, When the excel created there are some empty spaces created with the excel values, When i directly give send to excel from the chart there is not empty spaces with the values

Eg:

Date field will be like "Date " So i need to remove the space from the excel

Please help me as soon as possible

Re: Additional Empty space created with the values while exporting to excel using macro

m_woolf — Tue, 11 Jul 2017 12:11:47 GMT

You might post your macro code and a sample of the exported Excel.

Re: Additional Empty space created with the values while exporting to excel using macro

el_aprendiz111 — Tue, 11 Jul 2017 19:16:11 GMT

Hi,

Look this works fine.

sub Rpt_excelll
SET CHART = ActiveDocument.GetSheetObject("CH27")
SET X = Chart.GetProperties
Chart.SendToExcel
SET CHART=NOTHING
SET X = NOTHING
end sub