topic Re: Export Straight Table in QlikView

Export Straight Table

manojkulkarni — Mon, 23 Nov 2015 09:38:04 GMT

Hi All,

How to export multiple columns (straight table) as CSV from macro ? I tried using below code, i am getting column data along with html content. How to resolve this ?

set sObject = ActiveDocument.GetSheetObject("CH01")

sObject.ServerSideExport sPath , ", ",0

Re: Export Straight Table

tamilarasu — Mon, 23 Nov 2015 09:48:27 GMT

Hi Manoj

Change ServerSideExport to Export. It should work

set sObject = ActiveDocument.GetSheetObject("CH01")

sObject.Export sPath , ", ",0

Let me know.

Re: Export Straight Table

manojkulkarni — Mon, 23 Nov 2015 10:39:38 GMT

If I replace ServerSideExport to Export, then i cann't execute this from AccessPoint (browser). In my case, i have to export the data to csv thought browser.

Re: Export Straight Table

roger_stone — Mon, 23 Nov 2015 10:55:34 GMT

Export will work if you use the IE Plugin.

Re: Export Straight Table

manojkulkarni — Mon, 23 Nov 2015 11:15:11 GMT

Yes, but it is very difficult to ask everybody to install IE Plugin. Again, if some body want to use it in tablets/mobile then we cann't.