c# -类未注册-使用vide用宏创建Excel电子表格
本文关键字:创建 Excel 电子表格 vide 使用 -类 注册 | 更新日期: 2023-09-27 18:02:55
使用VS2010,我不能使用vide互操作DLL。有人可以看看他们是否可以在他们的PC上复制-代码直接从http://support.microsoft.com/kb/303872
-
参考这两个dll:
C:'Program Files'Microsoft Visual Studio 10.0'Visual Studio Tools for Office'PIA'Office14'Microsoft.Vbe.Interop.dll
和C:'Program Files'Microsoft Visual Studio 10.0'Visual Studio Tools for Office'PIA'Office14'Microsoft.Office.Interop.Excel.dll
-
在Form_load中输入以下代码:
//Using statments
using Excel = Microsoft.Office.Interop.Excel;
using VBIDE = Microsoft.Vbe.Interop;
using System.Reflection;
Excel.Application excelApp = null;
Excel._Workbook excelWorkbook;
Excel._Worksheet excelSheet;
excelApp = new Excel.Application();
excelApp.Visible = true;
excelWorkbook = (Excel._Workbook)(excelApp.Workbooks.Add(Missing.Value));
excelSheet = (Excel._Worksheet)excelWorkbook.ActiveSheet;
VBIDE.VBComponent oModule = new VBIDE.VBComponent(); //<--BAM throws an error
使用CLSID为组件检索COM类工厂{BE39F3DA-1B13-11D0-887F-00A0C90F2744}由于以下原因失败错误:80040154类未注册(来自HRESULT的异常:0 x80040154 (REGDB_E_CLASSNOTREG)) .
工作代码:
VBIDE.VBComponent oModule;
oModule = excelWorkbook.VBProject.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule);