Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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
or
t2.ServerSideExportEx "D:\public\Rebaixa_Preco\rebaixaprecoqlikview.csv", ";" , true
QlikView - ServerSideExportEx · GitHub
Thank everyone....
Hi
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
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
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
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
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
or
t2.ServerSideExportEx "D:\public\Rebaixa_Preco\rebaixaprecoqlikview.csv", ";" , true
QlikView - ServerSideExportEx · GitHub
Thank everyone....