topic export to excel in QlikView

export to excel

Wed, 21 Jul 2010 05:36:21 GMT

Hi ,

Not able to export to excel in the access point.Any one can help me on this

I have done this using the macro it is working fine at the tool level .But the same is not working when i am trying to export in the Access point. Is there any specific setting has to be changed.

Please advice.

Regards,

XXX

Regards,XXX

export to excel

manishkumar75 — Wed, 21 Jul 2010 06:58:27 GMT

Can u plz share the code which you have written in Macro ?

export to excel

Wed, 21 Jul 2010 07:26:23 GMT

Sub xl

set

XLApp = CreateObject("Excel.Application")

XLApp.Visible=True

set XLDoc = XLApp.Workbooks.Add

set

table = ActiveDocument.GetSheetObject("CH27")

set

XLSheet = XLDoc.Worksheets("Sheet1")

table.CopyTableToClipboard

true

XLSheet.Paste XLSheet.Range( "A1"

)

End

Sub

It is working fine at application but not working at the deployment and is there any idea how tio export the graph in to excel ???

export to excel

Wed, 21 Jul 2010 08:04:54 GMT

Do you have

Requested Module Security set to "System Access"

and

Current Local security set to "Allow System Access"

Anders

export to excel

manishkumar75 — Wed, 21 Jul 2010 08:25:51 GMT

For exporting the graph in to excel , do you mean exporting the Graph Image to Excel. If it is so then the code is as below :-

Sub

ExportDetails()

Dim

kost

Set

XLApp = CreateObject("Excel.Application"

)

TRUE

Set

XLDoc = XLApp.Workbooks.Add

"Sheet1"

"CH02"

).CopyBitmapToClipboard

'Copy the charts value

"A"

& 1).

Select

"CH03"

).CopyBitmapToClipboard 'Copy the charts value

"A"

& 12).

Select

End

Sub

export to excel

Wed, 21 Jul 2010 10:27:54 GMT

Thanks Manish,

Macros are not working. Yes Security is choosen as System Access and Allow System Acess in the Edit Module Section.

I am struggling with this as the macros are working fine in the Server in the Tool . When it is deployed and when u are trying to run the macro it is not working. And throwing error as well.

I am trying to run the Macro through the Button.

Can any one help me on this.

Regards,XXX

export to excel

manishkumar75 — Wed, 21 Jul 2010 10:35:10 GMT

One suggestion I want to give is to use the "Send To Excel" feature of QlikView. It works fine in all cases.

export to excel

Wed, 21 Jul 2010 10:57:57 GMT

Thanks manish,

That is working fine. Now i have changed the logic to export the charts to ppt and send it as a mail. Again the same issue it is working fine with the tool. But in Java or Ajax Clients it is not working.

Is it the BUG? or is there any specific Settings has to be enabled so that the macros will work..........

Waiting for Updates?

And is there any documents which will give the know issues in Qlik View??????????

Regards,

XXX

export to excel

Wed, 21 Jul 2010 15:34:14 GMT

Hi,

Finally i got some solution for macros. It is working with IE Plugins.

Regards,XXX

export to excel

manishkumar75 — Thu, 22 Jul 2010 06:57:11 GMT

Hi,

Can you please share the solution for Macros ?

- Manish

export to excel

Thu, 22 Jul 2010 13:40:35 GMT

Hi Manish,

I didnt do any changes in Macros it is the same macro. Intially i was not having the IE plugin in Access Point. Now i have downloaded the IE Pulgin and installed. And the macros are working with IE plugin. But still not working with Java and Ajax web Client.

Regards,XXX