在vb.net中使用excel 2003 [英] use excel 2003 in vb.net

问题描述

如何使用vb.net代码在Excel工作表中添加行或列，或设置单元格，行和列的格式

how add row or column or format cells,rows and columns in excel sheet using vb.net code

推荐答案

像这样的东西?
(根据要求进行更改)

Something like this?
(Change as per requirement)

Private oNewApp As Excel.Application

Private Sub Command1_Click()
Dim oWorkBook As Excel.Workbook
oNewApp.Visible = True
Set oWorkBook = oNewApp.Workbooks.Open("D:\My Documents\Book1.xls")
oWorkBook.Sheets("Sheet1").Rows("10:10").Select
Selection.Insert Shift:=xlDown
End Sub

Private Sub Form_Load()
Set oNewApp = New Excel.Application
End Sub 

这篇关于在vb.net中使用excel 2003的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！