Discussion board where members can get started with QlikView.
I have a macro that exports a straight table to excel but once exported, the number format is ignored. Is there extra code i need to add into the macro to force a full number format?
Attached is a portion of the macro that I'm sure extra code needs to be inserted into.
Thank you in advance
Go to Solution.
In the macro script it has to be something like
XLDoc.WorkSheets("Sheet1").Range("A:B").NumberFormatLocal = "#.##0"
To export the ST table to excel. Why don't you try simple code as per API guide.
set obj = ActiveDocument.GetSheetObject("CH01") obj.ExportBiff "C:\test.xls"
set obj = ActiveDocument.GetSheetObject("CH01")
Hope it helps you
The exporting is working fine. I am having an issue with number formatting. When the report is expoted to excel, the comma seperators and decimals are lost. I need to force format within the Macro script but I am unsure how.
Change your dimension as =num(F2, '#,##0.##', '.' , ',' ) . Please find the attached file for your reference.
Still not working. It looks like it has to be forced withing the macro script. Just need to correct code.
Have you seen my qvw file? Otherwise please provide sample qvw file.
Thank you very much Vicky! Solved my problem. Works perfectly!!
Using this macro we can send data to excel. But is it possible to add dropdown of filter in the exported excel using macro?