2,462
社区成员
发帖
与我相关
我的任务
分享
Dim strFName As String
strFName = Tname & "wncinfo.xls"
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
Dim xlsBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlsSheet As New Microsoft.Office.Interop.Excel.Worksheet
Try
xlsApp = CreateObject("Excel.Application") '生成Excel
xlsBook = xlsApp.Workbooks.Add
xlsSheet = xlsBook.Worksheets(1)
Dim i As Integer
Dim k As Integer
Dim S() As String
For i = 0 To ListBox3.Items.Count - 1 '行数
For k = 0 To ListBox3.Items.Count - 1
S = Split(ListBox3.Items(k), ",")
Dim j As Integer
For j = 0 To UBound(S) - 1
xlsSheet.Cells(k + 1, j + 1) = Trim(S(j))
xlsSheet.Columns(k + 1).HorizontalAlignment = 3 '居中
Next j
Next k
Next i
MsgBox("数据已经成功导出到:" & strFName & "", MsgBoxStyle.OkOnly, "温馨提示")
xlsBook.SaveAs(strFName) '保存上面生成excel
xlsSheet = Nothing '释放资源
xlsBook.Close() '关闭工作簿
xlsBook = Nothing '释放资源
xlsApp.Quit() '退出excel应用程序
xlsApp = Nothing
Catch ex As Exception
MsgBox(ex.Message)
End Try
If (u > 26) Then ' 注意 u 是列的“数量”,不是数组下标的上界值
u = u - 1
sCol = Chr$(64 + u \ 26) & Chr$(65 + u Mod 26)
Else
sCol = Chr$(64 + u)
End If
然后,执行这一句应该就可以了:
xlsSheet.Range("A:" & sCol).HorizontalAlignment = 3
[/quote]
感谢感谢 大神就是厉害!If (u > 26) Then ' 注意 u 是列的“数量”,不是数组下标的上界值
u = u - 1
sCol = Chr$(64 + u \ 26) & Chr$(65 + u Mod 26)
Else
sCol = Chr$(64 + u)
End If
然后,执行这一句应该就可以了:
xlsSheet.Range("A:" & sCol).HorizontalAlignment = 3
Dim strFName As String
strFName = Tname & "wncinfo.xls"
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
Dim xlsBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlsSheet As New Microsoft.Office.Interop.Excel.Worksheet
Try
xlsApp = CreateObject("Excel.Application") '生成Excel
xlsBook = xlsApp.Workbooks.Add
xlsSheet = xlsBook.Worksheets(1)
Dim i As Integer
Dim k As Integer
Dim S() As String
For i = 0 To ListBox3.Items.Count - 1 '行数
For k = 0 To ListBox3.Items.Count - 1
S = Split(ListBox3.Items(k), ",")
Dim j As Integer
For j = 0 To UBound(S) - 1
xlsSheet.Cells(k + 1, j + 1) = Trim(S(j))
xlsSheet.Columns(k + 1).HorizontalAlignment = 3 '居中
Next j
Next k
Next i
MsgBox("数据已经成功导出到:" & strFName & "", MsgBoxStyle.OkOnly, "温馨提示")
xlsBook.SaveAs(strFName) '保存上面生成excel
xlsSheet = Nothing '释放资源
xlsBook.Close() '关闭工作簿
xlsBook = Nothing '释放资源
xlsApp.Quit() '退出excel应用程序
xlsApp = Nothing
Catch ex As Exception
MsgBox(ex.Message)
End Try