當前位置:編程學習大全網 - 編程軟體 - 請問如何在vs2010中用vb創建壹個excel文件?

請問如何在vs2010中用vb創建壹個excel文件?

VS 軟件太大,我沒有安裝 ,VB6中是可以的,供參考

Dim objExcel As Excel.Application

Dim objWorkBook As Excel.Workbook

Set objExcel = CreateObject("Excel.Application")

Set objWorkBook = objExcel.Workbooks.Add()

objExcel.Visible = False

Dim objSheet As Excel.Worksheet

Set objSheet = objExcel.Worksheets("sheet1")

objSheet.Cells(1,1) = "姓名" '對單元格賦值

objSheet.Cells(1,2) = Date

objSheet.Cells(1,3) = Time

objWorkBook.SaveAs App.Path & "\a.xls" '保存

objWorkBook.Close

objExcel.Quit

Set objSheet = Nothing

Set objWorkBook = Nothing

Set objExcel = Nothing

  • 上一篇:tiktok怎麽充值金幣 海外軟件代充教程
  • 下一篇:水果鋼琴窗裏面的陰影部分是什麽?
  • copyright 2024編程學習大全網