关于导出为excel的问题?
Dim nWidth As Int16
Dim nInitWidth As Int16
Dim strValue As String
strValue = "4001,4002,4002,4002,4002,4002,4002,4002,4002,4003"
Dim xlSheet As New SpreadsheetClass()
xlSheet.ActiveSheet.Range(xlSheet.Cells(1, 1), xlSheet.Cells(1, 1)).Select()
nInitWidth = strValue.Length
nWidth = xlSheet.Selection.width()
xlSheet.Selection.Cells.f()
xlSheet.Selection.ColumnWidth = nInitWidth * 10 + nWidth
xlSheet.ActiveSheet.Cells(1, 1) = strValue
xlSheet.ActiveSheet.Export("c:\test.xls", SheetExportActionEnum.ssExportActionNone)
'------我导出之后,这里的"4001,4002,4002,4002,4002,4002,4002,4002,4002,4003"变成了"4,001,400,240,024,000,000,000,000,000,000,000,000,000",请问如何设置.这里应该为文本形式,而显示时当成了货币形式.谢了.