Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

2 Replies
m_woolf
Master II
Master II

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

el_aprendiz111
Specialist
Specialist

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