Question

请高手指教vb.net连接Excel该怎么写

Answer 1

在项目中添加Excel类库的引用，然后在VB中定义Excel 的Application，WorkBook和Worksheet
然后对Worksheet中的Range进行操作，不用像Access那样建立ADO什么的连接。
比如
Dim exlApp as Excel.Application = Createobject("Excel.Application")
if exlApp is Nothing then exit sub
dim xBook as Excel.WorkBook=exlApp.Workbook.add
if xBook is Nothing then exit sub
dim xSheet as excel.WorkSheet =xbook.WorkSheet.Add
if xSheet is Nothing Then exit sub
with xSheet
.Range("A1").value="Excel Application Test"
.Range("B1" & ":D2").Merge
.Range("B1" & ":D2").Value="合并表格内容"
end with！