VB.NET中引用EXCEL报错。请教各位如何解决。
VB.NET中引用EXCEL报错。错误信息为：VB.NET中引用EXCEL报错。错误信息为：检索 COM 类工厂中 CLSID 为 {00020819-0000-0000-C000-000000000046。
我在前边加入了Imports Microsoft.Office.Interop.Excel.并且在项目添加引用中加入了micrsoft excel11 objects library
代码：
Dim ap As New Microsoft.Office.Interop.Excel.Application
Dim apbook As New Microsoft.Office.Interop.Excel.Workbook
Dim apsheet As New Microsoft.Office.Interop.Excel.Worksheet
apbook = ap.Worksheets.Add
apsheet = ap.Worksheets.Add
apsheet.Cells(1, 1) = "abc"
ap.Visible = True
总是出错，到Dim apsheet As New Microsoft.Office.Interop.Excel.Worksheet位置，
[解决办法]
你写错了，我声明了一个apbook对像，为什么把它当作一个工作表来添加呢，我给你改一下吧
Dim ap As New Microsoft.Office.Interop.Excel.Application
Dim apbook As Microsoft.Office.Interop.Excel.Workbook
Dim apsheet As Microsoft.Office.Interop.Excel.Worksheet
apbook = ap.Workbooks.Add
apsheet = ap.Worksheets.Add
apsheet.Cells(1, 1) = "abc"
ap.Visible = True
