在vb.net中使用excel 2003
问题描述:
如何使用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