topic Re: Macro .csv in QlikView

Macro .csv

Anonymous — Tue, 06 Sep 2016 20:39:45 GMT

Hi folks.

Recently i open a discussion about macro to export to excel in qlikview server, and we come to conclusion that is not possible if excel is not instaled in server...so i keep trying the others ways and i got this:

Sub ExportToCSV

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set t2 = ActiveDocument.GetSheetObject("CH58")

t2.Export "\\10.234.239.156\WeCanDoThat\teste.csv", ";", , TRUE

Set objTextFile = objFSO.OpenTextFile ("\\10.234.239.156\WeCanDoThat\teste.csv", 8, True)

objTextFile.WriteLine("")

objTextFile.Close

Set t2 = ActiveDocument.GetSheetObject("CH59")

t2.Export "\\10.234.239.156\WeCanDoThat\teste.csv", ";", , TRUE

Set objTextFile = objFSO.OpenTextFile ("\\10.234.239.156\WeCanDoThat\teste.csv", 8, True)

objTextFile.WriteLine("")

objTextFile.Close

Set t2 = ActiveDocument.GetSheetObject("CH60")

t2.Export "\\10.234.239.156\WeCanDoThat\teste.csv", ";", , TRUE

End Sub

I export to .csv, in server it works, it create and save the file...but in qlikview web, nothing happening...

I read some text about this, and saw something about ajax client, and ie plugin, but i dont undestand very well...

Anyone know what i do wrong....or it is not possible and i have to give up....XD

note: i allow all macro options in qliview.

Thanks!!!

Re: Macro .csv

krishnacbe — Tue, 06 Sep 2016 21:05:35 GMT

You have two questions here. Ajax and IE Plugin are two modes of viewing the dashboard in access point.

if you View Details Link in the thumb nail of the Dashboard you can switch to IE Plugin mode.

Macros doesn't work in Ajax mode. you need to switch to IE Plugin.

Hope this helps

Re: Macro .csv

marcus_sommer — Wed, 07 Sep 2016 07:20:13 GMT

Couldn't the user simply use the export-to-excel feature within the ajax-client (I assume that it's installed on the local user machines)?

- Marcus

Re: Macro .csv

Anonymous — Thu, 08 Sep 2016 11:18:32 GMT

Yes, he could, but he can export a chart once, and my objective(sorry, i not explained this in text above) is create a macro to export all chart one time for the same Excel spreadsheet...Because this i want create a macro =/...

Thaks

Re: Macro .csv

marcus_sommer — Thu, 08 Sep 2016 17:05:47 GMT

Then you need to use the IE plugin as client or to install excel on the server. I know it's against pure IT doctrine " a server is a server and not ... bla bla bla" - but I couldn't see a real vulnerability regarding to security or performance.

- Marcus

Re: Macro .csv

Anonymous — Fri, 23 Sep 2016 13:00:09 GMT

Hi...i found a way to export .txt or .cvs using macro in ajax client

ServerSideExportEx

Use in VBscript like this:

t2.ServerSideExportEx "D:\public\Rebaixa_Preco\rebaixaprecoqlikview.txt", ";" , true

t2.ServerSideExportEx "D:\public\Rebaixa_Preco\rebaixaprecoqlikview.csv", ";" , true

QlikView - ServerSideExportEx · GitHub

Thank everyone....