将GridView导出为Excel日期格式 [英] export gridview to excel date format

问题描述

你好，


在将网格数据导出到Excel时如何设置excel日期格式? />
如果是这样，请将格式设置为适合您的任何日期格式，因为excel会自动选择格式.

或者，您是说要更改After is发送给excel的格式吗?
如果是这样，那么一个简单的宏就可以完成更改.

您的问题尚不清楚，请提供更简洁答案的要求的更多详细信息.

什么是"EXCEL日期格式"?

您能否提供链接或以其他方式解释?

我认为您是在问这个问题...

将网格视图或数据网格导出到Excel，使用样式表格式化单元格mso-number-format [ ^ ]

将GridView数据导出到Excel，Word和&文本文件 [ ^ ]

我的建议是澄清您的问题，如果可能的话，在您的问题中包括您的代码等.

欢呼.

Hello,


How to set excel date format, while exporting a grid data to Excel

解决方案

Do you mean you want to format existing data to an excel format PRIOR to exporting?

If so just format to any date format that suits you, as excel will pick up the format automatically.

Or, do you mean you want to alter the format After is has been sent to excel?
If so then a simple macro will do the trick in changing it.

Your question is not clear, give more details of the requirement for a more succinct answer.

What is ''EXCEL Date Format''?

Could you provide a link or otherwise explain?

I think you are asking this...

Exporting Grid view or data Grid to Excel ,Formatting cells with style sheet mso-number-format[^]

Export GridView data to Excel,Word, & Text file[^]

My suggestion is clarify your question little bit more if possible include your code, etc., in your question.

cheers.

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