export to excel

[Anonymous]

Hi

I have an straight table chart when I export that  a  "Network Access" text want to appear at the footer of the chart.It want to come automatically when I press the export to excel button.what I want to do for that whether I want to write any macros or I want make any settings change in the documents.?

Please help..

Thanks in advance

[bbi_mba_76]

Hi,

without macro I think you have to write the text as total or in the caption...

[Anonymous]

How can I do that without macro ?

I want that text two lines below the excel report for eg:

If my excel table finishes at A10 means text should come at A12

[its_anandrjs]

No need of macro you can export without the macro and send to excel by right click.

[#5]

Sara, your in effect adding a footer which you couldnt do without a macro.  If you want a flat export then right click export to excel if the footer is a requirement create a macro

[Anonymous]

Yes you are right footer is my requirement can I get any examples for my requirements.

[Anonymous]

I am not sure without macro I cant able to achieve this...

[its_anandrjs]

Please explain more about the requirement because it is unclear or another way is you can use N-Printing facilities from qlikview on that you can achieve that type of requirement.

[bbi_mba_76]

Without a macro you export to excel only the table content.

So you could add to generated row to have the text in excel, or you have to use total/caption, or another element of the table to add something. But you have not so possibility to move the text where you want

With a macro you could copy and paste the second macro

http://luciancotea.wordpress.com/2013/07/18/qlikview-macros-useful-collection/

and then you have to add

objExcel.Cells(r+2,c).Value = "Your text" before the end function

[Anonymous]

Hi

when I export the table chart it should want to export automatically with a text at a bottom of my chart

Eg :

Thanks in advance