topic Re: Export to csv on Access Point using Button in QlikView

Export to csv on Access Point using Button

Thu, 26 Jun 2014 06:40:27 GMT

Hi All ,

I want to give the Send to Excel action to a button on Access Point. How Can i do this?

Thanks

sajith

Re: Export to csv on Access Point using Button

ashfaq_haseeb — Thu, 26 Jun 2014 06:57:05 GMT

Hi,

Look at the attached example

Fine tune code accordingly.

Regards

ASHFAQ

Re: Export to csv on Access Point using Button

ashfaq_haseeb — Thu, 26 Jun 2014 07:04:08 GMT

To simplify

use the below code.

sub Export

set XLApp = CreateObject("Excel.Application") ' Define Object

XLApp.Visible = True 'Visible set as true

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "C:\test.csv"

end sub

Regards

ASHFAQ

Re: Export to csv on Access Point using Button

Thu, 26 Jun 2014 07:36:47 GMT

Hey ASHFAQ ,

Thanks for Quick Replay. I tried your codes in my local client , it works fine . But when i put the qvw on server and try out trough the Access point, i can`t download the file.

Thanks

sajith

Re: Export to csv on Access Point using Button

jerrysvensson — Thu, 26 Jun 2014 08:39:39 GMT

ASHFAQs code only works if you use plugin as client, in Ajax this will not work.

If you are using plugin, make sure you have correct securti settings in the macro.

Re: Export to csv on Access Point using Button

ashfaq_haseeb — Thu, 26 Jun 2014 08:42:14 GMT

Hi,

Macro only works with IE Plugin.

Try by opening IE Plugin.

Regards

ASHFAQ