Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Export Straight Table

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

4 Replies
tamilarasu
Champion
Champion

Hi Manoj

Change ServerSideExport to Export. It should work

set sObject = ActiveDocument.GetSheetObject("CH01")

sObject.Export sPath , ", ",0

Let me know.

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

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.

roger_stone
Creator III
Creator III

Export will work if you use the IE Plugin.

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

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.