救命啊,怎么实现啊,导出EXCEL的问题
我的数据导出是这样实现的,现在的问题是比如银行帐号这项在导出以后就显示成科学记数法了,请问我该怎样才能格式化他成文本那
单引号我试了,写进去就变成 '691000000012563这样的了,打印的时候单引号也出来了,显示都显示出来了
请问除了这个单引号的方法还有别的吗?
分不够再加~~~~,谢谢了
Public Function ExportDataSetToExcel(ByVal ds As DataSet, ByVal filename As String) As Boolean
Dim i, j, CountR, CountC As Integer
CountR = ds.Tables(0).Rows.Count
CountC = ds.Tables(0).Columns.Count
Response.Clear()
Response.Charset = "GB2312"
Response.Buffer = True
Response.AppendHeader("Content-Disposition", "attachment;filename=" & filename.ToString & ".xls")
Response.ContentType = "application/ms-excel"
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312")
Dim headcontent As String
headcontent = ""
headcontent = "年" & vbTab & "月" & vbTab & "工号" & vbTab & "姓名" & vbTab & "银行帐号" & vbTab & "所在单位" & vbTab & "银行" & vbTab & "实发工资" & vbCrLf
Response.Write(headcontent)
For i = 0 To CountR - 1
Dim rowcontent As String
rowcontent = ""
For j = 0 To CountC - 1
If j = 4 Then
rowcontent = rowcontent & IIf(IsDBNull(ds.Tables(0).Rows(i)(j)), "0", ds.Tables(0).Rows(i)(j).ToString("mso-number-format:@")) & vbTab
Else
rowcontent = rowcontent & ds.Tables(0).Rows(i)(j) & vbTab
End If
Next
rowcontent = rowcontent & vbCrLf
Response.Write(rowcontent)
Next
Response.End()
End Function