ReportServer Forum

hfaber

Member

Registered: 2013-11-03

JXLS - insert creation date into cell

Hi,

is it possible to insert the creation date (runtime) to a cell of a jxls-report (dynamic list)?

Thanks,
Heiko

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: JXLS - insert creation date into cell

Hi Heiko,

the easiest is probably the following. Add a hidden date parameter that is set to "default now". If the parameter has key "today" then you can access the date within the jxls template as

${parameters.today}

(Remember to set the format of the cell to date as otherwise excel will display an integer version of the date.)

Cheers
-Arno

hfaber

Member

Registered: 2013-11-03

Re: JXLS - insert creation date into cell

Hi Arno,

this works fine.

Thanks!

Heiko