topic Re: Macro csv export in QlikView

Macro csv export

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

i'm using the below macro to export a qv table into a csv file:

set ExportObject = ActiveDocument.GetSheetObject("CH1011")

ExportObject.Export "QV\Production\QVD\Monitor\Details.csv", ","

in the table I export (CH1011) there are 5 colums:

id, name, city, country, region

I only want to export the id, city and region columns. how can I do that?

thanks!

Re: Macro csv export

luciancotea — Mon, 23 May 2016 09:25:09 GMT

You create a copy of your pivot/table chart and leave only the columns you need. Export this copy..

Move it to a hidden sheet if you don't want to show it.

Re: Macro csv export

tamilarasu — Mon, 23 May 2016 10:01:03 GMT

Hi Naamamor,

Try this code,

Sub Test
Dim objExcel

FileName = "QV\Production\QVD\Monitor\Details.csv"

set ExportObject = ActiveDocument.GetSheetObject("CH1011")
ExportObject.Export FileName, ","
Set XLApp  = CreateObject("Excel.Application")
XLApp.Visible = False
XLApp.Workbooks.Open(FileName)
set XLSheet = XLApp.Worksheets(1)

XLSheet.Range("C:D").Delete
XLApp.DisplayAlerts = False
XLSheet.Saveas FileName 
XLApp.DisplayAlerts = True

XLApp.Application.quit  

set ExportObject = Nothiing
set XLSheet = Nothing  
set XLApp = Nothing  
Msgbox "Exported Sucessfully"  

End Sub

Re: Macro csv export

tamilarasu — Mon, 23 May 2016 12:44:34 GMT

Sorry. The correct column reference should be

XLSheet.Range("C:D").Delete

XLSheet.Range("B:B,D:D").Delete

Re: Macro csv export

Thu, 26 May 2016 12:40:54 GMT

thank you Tamil,

i receive this error msg: ActiveX component can't create object: 'Excel.Application'

Re: Macro csv export

m_woolf — Thu, 26 May 2016 12:57:09 GMT

Either macro settings are not set to System Access or Excel isn't installed on the computer.

Re: Macro csv export

jerrysvensson — Thu, 26 May 2016 13:13:00 GMT

He is using WebView and macros that uses CreateObject will not work there. Regardless security settings.

Use your current solution but create another object with only the dimension needed. As Lucian recommended.

Re: Macro csv export

tamilarasu — Thu, 26 May 2016 16:39:43 GMT

Naamamor,

As suggested by mwoolf‌, you must set the requested module security and current local security to "Allow System Access" in macro window.

Re: Macro csv export

hitha1512 — Tue, 16 Apr 2019 03:46:07 GMT

Hi ,

Could you please help me with a macro to export object data into .csv ?

Regards,

Hitha Dhani