topic Re: Exporting an xls file with a predefined name in QlikView

Exporting an xls file with a predefined name

Anonymous — Wed, 04 Feb 2015 14:19:58 GMT

hi all,

i would like to export a table to an excel file,

with the name of the table + today's date,

do you know how to do this?

thanks,

Nir

Re: Exporting an xls file with a predefined name

Anonymous — Wed, 04 Feb 2015 14:31:16 GMT

try this....

public function Export

set obj = ActiveDocument.GetSheetObject("EXPORT")

ActiveDocument.GetApplication.WaitForIdle

fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".xlsx"

ActiveDocument.GetApplication.WaitForIdle

obj.Export vFolder & fileName

end function

Re: Exporting an xls file with a predefined name

Wed, 04 Feb 2015 14:31:23 GMT

Hi, Nir, Good resources here.

give default name to excel-export | Qlik Community

Re: Exporting an xls file with a predefined name

Anonymous — Wed, 04 Feb 2015 14:48:41 GMT

still the same gibrish..

the oly thing i changed is the EXPORT to the object ID in the report

obj.Export vFolder & fileName // what is vFolder? should i create it?

Re: Exporting an xls file with a predefined name

Anonymous — Wed, 04 Feb 2015 16:48:26 GMT

it's a variable defining the path to export to

here's an example that uses a slightly different approach...same principle though

Re: Exporting an xls file with a predefined name

Anonymous — Thu, 05 Feb 2015 08:31:32 GMT

Thanks for your help!

I think i understand it now,

the thing is i need to implement this for users that QV by access point,

while this works only on desktop client

Re: Exporting an xls file with a predefined name

Anonymous — Thu, 05 Feb 2015 14:56:24 GMT

Okay - then, yes, there are a couple of constraints.

Most (probably safe to say all) macro scripts will not execute within the AJAX client.

If you need to utilize a macro from access point for users then you could use the IE Plugin with IE as your browser....or you could have them open the qvw from the server using the qlikview desktop client.