救命啊,怎么实现啊,导出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
单引号我试了,写进去就变成 '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
...全文
相关推荐
2021年事业单位人员辞职报告5篇.docx
2021年事业单位人员辞职报告5篇.docx
Java数据类型—String进阶之字符串常量池
作为最基础用的最多的引用数据类型,Java 设计者为String 提供了各种优化,其中就有为 String 提供了字符串常量池以提高其性能,主要就是为了降低内存开销,那么字符串常量池的具体原理是什么,我们带着以下三个问题,去理解字符串常量池
2021年事业单位员工辞职报告范文.docx
2021年事业单位员工辞职报告范文.docx
2021年6月事业单位辞职报告范文.docx
2021年6月事业单位辞职报告范文.docx
2016年事业单位人员辞职报告.docx
2016年事业单位人员辞职报告.docx


