topic Re: export to excel functality to hidden object in QlikView

export to excel functality to hidden object

Anonymous — Mon, 12 Nov 2012 19:50:05 GMT

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

Re: export to excel functality to hidden object

Gysbert_Wassenaar — Mon, 12 Nov 2012 19:55:40 GMT

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

Re: export to excel functality to hidden object

Mon, 12 Nov 2012 19:59:15 GMT

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

Re: export to excel functality to hidden object

Anonymous — Mon, 12 Nov 2012 20:02:34 GMT

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

Re: export to excel functality to hidden object

Anonymous — Mon, 12 Nov 2012 20:07:56 GMT

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

Re: export to excel functality to hidden object

Gysbert_Wassenaar — Mon, 12 Nov 2012 20:33:16 GMT

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.

Re: export to excel functality to hidden object

Anonymous — Mon, 12 Nov 2012 21:26:45 GMT

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

Re: export to excel functality to hidden object

Anonymous — Mon, 03 Dec 2012 16:43:57 GMT

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 ?