我有一个数据网格的格式问题。我已经应用了格式化属性aDataColumn.DataFormatString = "{0:d}"
Private Function CreateColumnFromNode(ByVal aDisplayPropertyNode As XmlNode) As BoundColumn
Dim PropertyKey As String = cXMLDoc.AttributeToString(aDisplayPropertyNode, "PropertyKey")
Dim ColumnHeader As String = ConfigurableText(cXMLDoc.AttributeToString(aDisplayPropertyNode, "ColumnHeader"))
If PropertyKey = "" Then Return Nothing
Dim aDataColumn As New BoundColumn()
aDataColumn.DataField = PropertyKey
aDataColumn.HeaderText = IIf(ColumnHeader = "", PropertyKey, ColumnHeader)
<b> aDataColumn.DataFormatString = "{0:d}"</b>
Return aDataColumn
End Function
到数据网格。当导出到excel时,它采用系统的默认设置。
我使用了以下代码进行导出。不是自定义代码。
它使用asp.net属性。
Dim response As HttpResponse = HttpContext.Current.Response
response.Clear()
response.Charset = ""
' set the response mime type
response.ContentType = "application/vnd.ms-excel"
response.AddHeader("Content-Disposition", "attachment;filename=" + aFileName)
' create a string writer
Using sw As System.IO.StringWriter = New System.IO.StringWriter()
Using htw As HtmlTextWriter = New HtmlTextWriter(sw)
' instantiate a datagrid
DataGrid1.RenderControl(htw)
response.Write(sw.ToString())
End Using
End Using
response.End()
谢谢. .
我建议您在导出到Excel时获得默认系统设置的原因是因为Excel的自动单元格格式功能,它将查看单元格的值内容并自动应用其预定义格式之一,除非用户指定了特定格式以覆盖此格式。
因为我们看不到你的Excel导出代码,我假设你自己在做,在这种情况下,你需要在代码中添加一行来设置该列的日期时间格式,或者将其格式设置为文本。为了测试这一点,打开一个您已经导出的电子表格,并将列的格式更改为文本,看看它是否会返回原始数据。