如何创建Excel.Application对象? [英] How to create Excel.Application object?

问题描述

我试图创建excel应用程序对象，但是却出现错误，例如-应用程序在名称空间Microsoft.Office.Interop.Excel中不明确".请帮我..

im trying to create excel application object but im getting error like -"Application is ambiguous in the namespace Microsoft.Office.Interop.Excel". Pls help me..

推荐答案

1.add Interop.Microsoft.Office.Interop.Excel.dll参考.
2.导入Microsoft.Office.Interop命名空间
3.添加以下代码

1.add Interop.Microsoft.Office.Interop.Excel.dll reference.
2.Imports Microsoft.Office.Interop name space
3.add following code

Dim myApplication As Excel.Application
        Dim myWorkBook As Excel.Workbook
        Dim myWorkSheet As Excel.Worksheet
        Dim misValue As Object = System.Reflection.Missing.Value
        Dim myrange As Excel.Range

多数民众赞成在没有工作的情况下尝试此操作.我将提供解决方案.

thats it.try this if it is not work i will provide soln.

这篇关于如何创建Excel.Application对象?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！