Kendo Grid导出Excel日期格式 [英] Kendo grid export excel date format

问题描述

我在asp.net mvc中使用kendo网格开发了一个报告.根据用户要求，我将kendo导出添加到excel选项.在单击导出Excel数据时，将数据传输到excel.我的网格中有一个日期列.它在报告中显示正常.但是在传输时，日期列格式已更改为数字.
提前致谢.请任何人尽早为我提供帮助.

我尝试过的事情:

我在telerik网站中搜索并用Google搜索，但是我没有为我的asp.net mvc kendo grid export excel找到合适的解决方案.

Hi,

I developed a report with kendo grid in asp.net mvc. As per user requirement, I added kendo export to excel option. while clicking export excel data transferred to excel. I have a date column in my grid. It displays fine in report. But while transferring, date column format was changed as number.
Thanks in advance. Please any one can help me as early as possible.

What I have tried:

I searched in telerik sites and googled but i didn''t get proper solution for my asp.net mvc kendo grid export excel

推荐答案

你好，

我将直接回答以下问题:
1.您可以使用 [ [ [ sheets.rows.cells.bold ]
[ sheets.rows.cells.format ]


问候，
尼克

Hello,

I will go straight to the questions:
1. You could use an approach [similar to the following one ]in the event in order to set custom background color to the Grid cells.
2. You could find all the possible configuration options for the Workbook at the [following documentation page]. For example:

[sheets.rows.cells.bold]
[sheets.rows.cells.format]


Regards,
Nick

这篇关于Kendo Grid导出Excel日期格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！