Hi, I need the format date dd-mm-yy (not only need this format in the text i need the format of the cell are Date) when i export one report to xlsx but i don't see this format in Date format text (attach the image).
Can you help me?
Change Date Format when export excel
Change Date Format when export excel
- Attachments
-
- DateFormatStimulsoft.png (22.61 KiB) Viewed 2218 times
-
- Posts: 6197
- Joined: Tue Mar 20, 2018 5:34 am
Re: Change Date Format when export excel
Hello,
Please try to set the Custom format.
Thank you.
Please try to set the Custom format.
Thank you.
Re: Change Date Format when export excel
The custom format is the format i select in the last image?Lech Kulikowski wrote: ↑Mon Apr 27, 2020 10:42 am Hello,
Please try to set the Custom format.
Thank you.
In this case i show me the date in the format dd/MM/yyyy not in dd-MM-yy. I see is possible to change the culture but any culture use my format.
-
- Posts: 6197
- Joined: Tue Mar 20, 2018 5:34 am
Re: Change Date Format when export excel
Hello,
As a way, you can use the ToString() method:
{datasource.column.ToString("dd-MM-yy")}
Thank you.
As a way, you can use the ToString() method:
{datasource.column.ToString("dd-MM-yy")}
Thank you.
Re: Change Date Format when export excel
In this case the result text is in format "dd-MM-yy" but when i export the cell in excel as text and i need this cell are in the format date.Lech Kulikowski wrote: ↑Fri May 01, 2020 12:00 pm Hello,
As a way, you can use the ToString() method:
{datasource.column.ToString("dd-MM-yy")}
Thank you.
Re: Change Date Format when export excel
Hello,
Please, try to
- set the Text Format to Date
- set the Excel Value with the necessary value
- set the next static option:
Thank you.
Please, try to
- set the Text Format to Date
- set the Excel Value with the necessary value
- set the next static option:
Code: Select all
StiOptions.Export.Excel.AllowExportDateTime = true;