ReportServer Forum

danco

Member

Registered: 2022-03-02

Date format in Excel export

Is it possible to change the date format used for Excel exports?

When I export a dynamic list to Excel dates are formatted as mm/dd/yyyy.
Being from the UK I would prefer dd/mm/yyyy.

Here's the content of /xl/styles.xml from inside an exported xlsx file (reformatted for readability), notice the format in line 5:

<?xml version="1.0" encoding="UTF-8"?>
<styleSheet
	xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
	<numFmts count="1">
		<numFmt numFmtId="164" formatCode="MM/dd/yyyy hh:mm:ss"/>
	</numFmts>
	<fonts count="1">
		<font>
			<sz val="11.0"/>
			<color indexed="8"/>
			<name val="Calibri"/>
			<family val="2"/>
			<scheme val="minor"/>
		</font>
	</fonts>
	<fills count="2">
		<fill>
			<patternFill patternType="none"/>
		</fill>
		<fill>
			<patternFill patternType="darkGray"/>
		</fill>
	</fills>
	<borders count="1">
		<border>
			<left/>
			<right/>
			<top/>
			<bottom/>
			<diagonal/>
		</border>
	</borders>
	<cellStyleXfs count="1">
		<xf numFmtId="0" fontId="0" fillId="0" borderId="0"/>
	</cellStyleXfs>
	<cellXfs count="2">
		<xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0"/>
		<xf numFmtId="164" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="true"/>
	</cellXfs>
</styleSheet>

I have tried updating the <format> tags in localization.cf but they seem to have no effect on exported xlsx files.

danco

Member

Registered: 2022-03-02

Re: Date format in Excel export

#Bump

Is anybody able to offer a solution on this one?

malte_if

Administrator

Registered: 2023-05-10

Website

Re: Date format in Excel export

Hi danco,

please check if

<region>UK</region>

is in your /fileserver/etc/main/localization.cf file.

You can find an example here: https://github.com/infofabrik/reportser … ization.cf

danco

Member

Registered: 2022-03-02

Re: Date format in Excel export

Thank you for the reply.

/fileserver/etc/main/localization.cf did not contain <region> at all.

I have updated it to match https://github.com/infofabrik/reportser … ization.cf exactly but with <region>US</region> updated to <region>UK</region>. I then reloaded the config in the terminal with 'config reload'.

Reports exported as Excel are still in US format.

I'm wondering if the fact that my localization.cf did not contain <region> means I'm using a ReportServer version that does not support this?

I'm using version RS4.0.0-6057.

danco

Member

Registered: 2022-03-02

Re: Date format in Excel export

Looking through the sample localization.cf files at https://github.com/infofabrik/reportser … in/config/ it seems that <region> support was added in version 4.4 - <region> is present in the 4.4 sample but not the 4.3 sample.

So I'm guessing I will need to update ReportServer to get region support and solve my date format issue.

The next issue is how to update the Bitnami stack that I'm using when Bitnami stopped releasing installers at version 4.3.0-6080. I'll create a new thread for that one.