Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to Excel via macro-number format

Hi All,

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Ayron,

In the macro script it has to be something like

XLDoc.WorkSheets("Sheet1").Range("A:B").NumberFormatLocal = "#.##0"

decimal "#.##0,00"

percentage "#.##0,00%"

Regards

Vicky

View solution in original post

8 Replies
jagannalla
Partner
Partner

Hi,

To export the ST table to excel. Why don't you try simple code as per API guide.

Eg:

set obj = ActiveDocument.GetSheetObject("CH01")

  obj.ExportBiff "C:\test.xls"

Hope it helps you

Cheers!!

Jagan

Not applicable
Author

Hi Jagan,

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.

Regards,

Ayron

jagannalla
Partner
Partner

Change your dimension as =num(F2, '#,##0.##', '.' , ',' ) . Please find the attached file for your reference.

Not applicable
Author

Still not working. It looks like it has to be forced withing the macro script. Just need to correct code.

jagannalla
Partner
Partner

Have you seen my qvw file? Otherwise please provide sample qvw file.

Not applicable
Author

Hi Ayron,

In the macro script it has to be something like

XLDoc.WorkSheets("Sheet1").Range("A:B").NumberFormatLocal = "#.##0"

decimal "#.##0,00"

percentage "#.##0,00%"

Regards

Vicky

View solution in original post

Not applicable
Author

Thank you very much Vicky! Solved my problem. Works perfectly!!

Regards,

Ayron

Not applicable
Author

Hi All,

Using this macro we can send data to excel. But is it possible to add dropdown of filter in the exported excel using macro?

- Yojas