export to excel functality to hidden object

[Anonymous]

Hi,

    I have some metrics in text box that needs to exported to excel .i wrote a macro but this macro is not working (because of using ajax plugin).

as a workaround .. i want try it   having those parameters in a hidden straight table and have a export option enabled in that text box

will this be possible

thanks

[Gysbert_Wassenaar · Accepted solution]

Can't you enable the caption of the text box and the Menu icon? The menu will have an option Send to Excel.

[#3]

Hi,

try to create an hidden straight table and one button with an Export Action.

Look this post

http://community.qlik.com/thread/25105

Hope this helps

MC

[Anonymous]

ohh thanks alot ..but funniest part is that i tried to enable exprt to excel option but i don't see that working ..but with menu option it is working ..

thanks alot

[Anonymous]

let me add some more to it ..when exporting to excel , the format is getting distrubed

how to export this as BIFF exports

or any work around you suggests

[Gysbert_Wassenaar]

Well, a text box has text (or an image, but let's ignore that for now) so export to excel will just export the text and the formatting of the text. If you want to export a table with a macro create a button, add an action to it, External->Run Macro, use for example Exp2XL as name and choose Edit Module and add this code to export object TB01:

sub Exp2XL

    set Chart = ActiveDocument.GetSheetObject("TB01")

     Chart.ExportBiff "testtest.xls"

End Sub

Change TB01 to the ID of the object you want to export.

[Anonymous]

we are using Ajax pulgin ..macros are  not working and when i see this menu option in access point i don't see any export to excel option why is this missing

at full client (dev side) i can see ---> export from menu dropdown.. but when same app  in ajax client then ..we don't see send to excel option

why is this  so ?

is it a Bug

[Anonymous]

Let me put it this way how to add expression to the setup of export

in short i have a straight table with 6 different expression s..

the way i want it ------to be like where i can give an object Id and by clicking on it the object should be exported

how can we do this ?