topic Re: Table Name while exporting table to excel via access point in QlikView

Table Name while exporting table to excel via access point

Thu, 21 Apr 2016 22:32:12 GMT

Hi Guys,

Question

Is it possible to give a file name while exporting table to excel via access point?

What am I trying Achieve?

I have 4 different tables on the dashboard. I want to be able to export that table to excel and it should have the table name/title and current date as the file name..

Right now, when I export it to excel then it asks me to save the file but it shows name as below

Thank you.

Re: Table Name while exporting table to excel via access point

alexdataiq — Thu, 21 Apr 2016 23:13:51 GMT

I don't believe it's possible to do so, but maybe you could do it with a macro, asuming you use the IE plug-in.

Re: Table Name while exporting table to excel via access point

Fri, 22 Apr 2016 09:35:40 GMT

Thanks for the reply Alejandro,

I tried macro and it works fine on the local machine but not working via access point.

Tried enabling Macro settings on the server security but still no success.

Re: Table Name while exporting table to excel via access point

avinashelite — Fri, 22 Apr 2016 10:47:20 GMT

as per my knowledge if your using the ajax client it will not support macro ..check that once

Re: Table Name while exporting table to excel via access point

alexdataiq — Fri, 22 Apr 2016 14:23:22 GMT

Yes, most (if not all) macros won't work with the Ajax ZFC, only when you use the plug-in in Internet Explorer.

Cheers

Re: Table Name while exporting table to excel via access point

awhitfield — Fri, 22 Apr 2016 14:32:52 GMT

Hi Lokesh,

can't you just edit the file name in save as?

Andy

Re: Table Name while exporting table to excel via access point

Mon, 25 Apr 2016 04:28:19 GMT

Yes Of course i can

I was just checking if there it can do this or not

Re: Table Name while exporting table to excel via access point

Pulkit_Thukral — Mon, 25 Apr 2016 05:07:21 GMT

Maybe a macro can help you in this case .Use Macro in your application with below written script.

sub Server_Export2

SET XLApp = CreateObject("Excel.Application")

XLApp.Visible = False

SET XLDoc = XLApp.Workbooks.Add

SET XLSheet1 = XLDoc.Worksheets(1)

ActiveDocument.GetSheetObject("CH56").CopyTableToClipboard true

XLSheet1.Paste XLSheet1.Range("A1")

XLSheet1.Name = "Reports2"

XLApp.Visible = True

end sub