blocks|key|1576375|text|别。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1576376|我知道这听起来很陈词滥调，但在使用C#时，VB要比C#简单得多。即使你使用PIA而不是全力以赴的后期绑定，你还是最好使用VB。|1576377|(注意:当C#+4发布时，所有这些评论都会立即变得错误。)|1576378|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Don't. 

I know it sounds trite, but VB is many, many times easier to use than C# when working with Excel. Even if you use PIA instead of all-out late binding, you are still better off using VB.

(Note: all these comments will become instantly wrong when C# 4 is released.)

blocks|key|1576411|text|请使用AccessibleObjectFromWindow的以下定义：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1576412|++++[DllImport("Oleacc.dll")]
++++private+static+extern+int+AccessibleObjectFromWindow(
++++++++int+hwnd,+uint+dwObjectID,
++++++++byte[]+riid,
++++++++[MarshalAs(UnmanagedType.IUnknown)]ref+object+ptr);|code-block|syntax|javascript|1576413|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Use this definition of AccessibleObjectFromWindow instead:

<pre><code> [DllImport("Oleacc.dll")]
 private static extern int AccessibleObjectFromWindow(
 int hwnd, uint dwObjectID,
 byte[] riid,
 [MarshalAs(UnmanagedType.IUnknown)]ref object ptr);
</code></pre>

blocks|key|1576447|text|第一个答案中的代码非常有效。Word也是如此，在底部添加了一点.NET+4.0动态操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1576448|//+http://stackoverflow.com/questions/779363/how-to-use-use-late-binding-to-get-excel-instance
//+ReSharper+disable+InconsistentNaming

using+System;
using+System.Runtime.InteropServices;
using+System.Globalization;
using+System.Reflection;
using+System.Text;

namespace+LateBindingWord+{
++++///+<summary>+Interface+definition+for+Word.Window+interface+</summary>
++++[Guid("00020962-0000-0000-C000-000000000046")]
++++[InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
++++public+interface+IWordWindow+{
++++}

++++///+<summary>
++++///+This+class+is+needed+as+a+workaround+to+http://support.microsoft.com/default.aspx?scid=kb;en-us;320369
++++///+Excel+automation+will+fail+with+the+follwoing+error+on+systems+with+non-English+regional+settings:
++++///+"Old+format+or+invalid+type+library.+(Exception+from+HRESULT:+0x80028018+(TYPE_E_INVDATAREAD))"+
++++///+</summary>
++++class+UiLanguageHelper+:+IDisposable+{
++++++++private+readonly+CultureInfo+_currentCulture;

++++++++public+UiLanguageHelper()+{
++++++++++++//+save+current+culture+and+set+culture+to+en-US+
++++++++++++_currentCulture+=+System.Threading.Thread.CurrentThread.CurrentCulture;
++++++++++++System.Threading.Thread.CurrentThread.CurrentCulture+=+new+CultureInfo("en-US");
++++++++}

++++++++public+void+Dispose()+{
++++++++++++//+reset+to+original+culture+
++++++++++++System.Threading.Thread.CurrentThread.CurrentCulture+=+_currentCulture;
++++++++}
++++}

++++class+Program+{
++++++++[DllImport("user32.dll",+SetLastError+=+true)]
++++++++static+extern+IntPtr+FindWindow(string+lpClassName,+string+lpWindowName);

++++++++[DllImport("Oleacc.dll")]
++++++++static+extern+int+AccessibleObjectFromWindow(int+hwnd,+uint+dwObjectID,+byte[]+riid,+out+IWordWindow+ptr);

++++++++public+delegate+bool+EnumChildCallback(int+hwnd,+ref+int+lParam);

++++++++[DllImport("User32.dll")]
++++++++public+static+extern+bool+EnumChildWindows(int+hWndParent,+EnumChildCallback+lpEnumFunc,+ref+int+lParam);

++++++++[DllImport("User32.dll")]
++++++++public+static+extern+int+GetClassName(int+hWnd,+StringBuilder+lpClassName,+int+nMaxCount);

++++++++public+static+bool+EnumChildProc(int+hwndChild,+ref+int+lParam)+{
++++++++++++var+buf+=+new+StringBuilder(128);
++++++++++++GetClassName(hwndChild,+buf,+128);
++++++++++++Console.WriteLine(buf.ToString());

++++++++++++if+(buf.ToString()+==+"_WwG")+{+
++++++++++++++++lParam+=+hwndChild;
++++++++++++++++return+false;
++++++++++++}
++++++++++++return+true;
++++++++}

++++++++static+void+Main()+{
++++++++++++//+Use+the+window+class+name+("XLMAIN")+to+retrieve+a+handle+to+Excel's+main+window.
++++++++++++//+Alternatively+you+can+get+the+window+handle+via+the+process+id:
++++++++++++//+int+hwnd+=+(int)Process.GetProcessById(excelPid).MainWindowHandle;
++++++++++++//+var+p=Process.GetProcesses().FirstOrDefault(x+=>+x.ProcessName=="WINWORD");
++++++++++++var+hwnd+=+(int)+FindWindow("OpusApp",+null);

++++++++++++if+(hwnd+==+0)+
++++++++++++++++throw+new+Exception("Can't+find+Word");

++++++++++++//+Search+the+accessible+child+window+(it+has+class+name+"_WwG")+//+http://msdn.microsoft.com/en-us/library/windows/desktop/dd317978%2528v=vs.85%2529.aspx
++++++++++++var+hwndChild+=+0;
++++++++++++var+cb+=+new+EnumChildCallback(EnumChildProc);
++++++++++++EnumChildWindows(hwnd,+cb,+ref+hwndChild);

++++++++++++if+(hwndChild+==+0)+
++++++++++++++++throw+new+Exception("Can't+find+Automation+Child+Window");

++++++++++++//+We+call+AccessibleObjectFromWindow,+passing+the+constant+OBJID_NATIVEOM+(defined+in+winuser.h)+
++++++++++++//+and+IID_IDispatch+-+we+want+an+IDispatch+pointer+into+the+native+object+model.
++++++++++++const+uint+OBJID_NATIVEOM+=+0xFFFFFFF0;
++++++++++++var+IID_IDispatch+=+new+Guid("{00020400-0000-0000-C000-000000000046}");
++++++++++++IWordWindow+ptr;

++++++++++++var+hr+=+AccessibleObjectFromWindow(hwndChild,+OBJID_NATIVEOM,+IID_IDispatch.ToByteArray(),+out+ptr);

++++++++++++if+(hr+<+0)+
++++++++++++++++throw+new+Exception("Can't+get+Accessible+Object");

++++++++++++//+We+successfully+got+a+native+OM+IDispatch+pointer,+we+can+QI+this+for
++++++++++++//+an+Excel+Application+using+reflection+(and+using+UILanguageHelper+to+
++++++++++++//+fix+http://support.microsoft.com/default.aspx?scid=kb;en-us;320369)
++++++++++++using+(new+UiLanguageHelper())+{
++++++++++++++++var+wordApp+=+ptr.GetType().InvokeMember("Application",+BindingFlags.GetProperty,+null,+ptr,+null);

++++++++++++++++var+version+=+wordApp.GetType().InvokeMember("Version",+BindingFlags.GetField+%7C+BindingFlags.InvokeMethod+%7C+BindingFlags.GetProperty,+null,+wordApp,+null);
++++++++++++++++Console.WriteLine("Word+version+is:+{0}",+version);

++++++++++++++++dynamic+wordAppd+=+ptr.GetType().InvokeMember("Application",+BindingFlags.GetProperty,+null,+ptr,+null);
++++++++++++++++Console.WriteLine("Version:+"+%2B+wordAppd.Version);
++++++++++++}
++++++++}
++++}
}|code-block|syntax|javascript|1576449|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The code in the first answer worked like a charm. Here's the same thing for Word, plus a bit of .NET 4.0 Dynamic action at the bottom.

<pre><code>// http://stackoverflow.com/questions/779363/how-to-use-use-late-binding-to-get-excel-instance
// ReSharper disable InconsistentNaming

using System;
using System.Runtime.InteropServices;
using System.Globalization;
using System.Reflection;
using System.Text;

namespace LateBindingWord {
 /// &lt;summary&gt; Interface definition for Word.Window interface &lt;/summary&gt;
 [Guid("00020962-0000-0000-C000-000000000046")]
 [InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
 public interface IWordWindow {
 }

 /// &lt;summary&gt;
 /// This class is needed as a workaround to http://support.microsoft.com/default.aspx?scid=kb;en-us;320369
 /// Excel automation will fail with the follwoing error on systems with non-English regional settings:
 /// "Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" 
 /// &lt;/summary&gt;
 class UiLanguageHelper : IDisposable {
 private readonly CultureInfo _currentCulture;

 public UiLanguageHelper() {
 // save current culture and set culture to en-US 
 _currentCulture = System.Threading.Thread.CurrentThread.CurrentCulture;
 System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
 }

 public void Dispose() {
 // reset to original culture 
 System.Threading.Thread.CurrentThread.CurrentCulture = _currentCulture;
 }
 }

 class Program {
 [DllImport("user32.dll", SetLastError = true)]
 static extern IntPtr FindWindow(string lpClassName, string lpWindowName);

 [DllImport("Oleacc.dll")]
 static extern int AccessibleObjectFromWindow(int hwnd, uint dwObjectID, byte[] riid, out IWordWindow ptr);

 public delegate bool EnumChildCallback(int hwnd, ref int lParam);

 [DllImport("User32.dll")]
 public static extern bool EnumChildWindows(int hWndParent, EnumChildCallback lpEnumFunc, ref int lParam);

 [DllImport("User32.dll")]
 public static extern int GetClassName(int hWnd, StringBuilder lpClassName, int nMaxCount);

 public static bool EnumChildProc(int hwndChild, ref int lParam) {
 var buf = new StringBuilder(128);
 GetClassName(hwndChild, buf, 128);
 Console.WriteLine(buf.ToString());

 if (buf.ToString() == "_WwG") { 
 lParam = hwndChild;
 return false;
 }
 return true;
 }

 static void Main() {
 // Use the window class name ("XLMAIN") to retrieve a handle to Excel's main window.
 // Alternatively you can get the window handle via the process id:
 // int hwnd = (int)Process.GetProcessById(excelPid).MainWindowHandle;
 // var p=Process.GetProcesses().FirstOrDefault(x =&gt; x.ProcessName=="WINWORD");
 var hwnd = (int) FindWindow("OpusApp", null);

 if (hwnd == 0) 
 throw new Exception("Can't find Word");

 // Search the accessible child window (it has class name "_WwG") // http://msdn.microsoft.com/en-us/library/windows/desktop/dd317978%28v=vs.85%29.aspx
 var hwndChild = 0;
 var cb = new EnumChildCallback(EnumChildProc);
 EnumChildWindows(hwnd, cb, ref hwndChild);

 if (hwndChild == 0) 
 throw new Exception("Can't find Automation Child Window");

 // We call AccessibleObjectFromWindow, passing the constant OBJID_NATIVEOM (defined in winuser.h) 
 // and IID_IDispatch - we want an IDispatch pointer into the native object model.
 const uint OBJID_NATIVEOM = 0xFFFFFFF0;
 var IID_IDispatch = new Guid("{00020400-0000-0000-C000-000000000046}");
 IWordWindow ptr;

 var hr = AccessibleObjectFromWindow(hwndChild, OBJID_NATIVEOM, IID_IDispatch.ToByteArray(), out ptr);

 if (hr &lt; 0) 
 throw new Exception("Can't get Accessible Object");

 // We successfully got a native OM IDispatch pointer, we can QI this for
 // an Excel Application using reflection (and using UILanguageHelper to 
 // fix http://support.microsoft.com/default.aspx?scid=kb;en-us;320369)
 using (new UiLanguageHelper()) {
 var wordApp = ptr.GetType().InvokeMember("Application", BindingFlags.GetProperty, null, ptr, null);

 var version = wordApp.GetType().InvokeMember("Version", BindingFlags.GetField | BindingFlags.InvokeMethod | BindingFlags.GetProperty, null, wordApp, null);
 Console.WriteLine("Word version is: {0}", version);

 dynamic wordAppd = ptr.GetType().InvokeMember("Application", BindingFlags.GetProperty, null, ptr, null);
 Console.WriteLine("Version: " + wordAppd.Version);
 }
 }
 }
}
</code></pre>

I'm using

<pre><code>[DllImport("Oleacc.dll")]
static extern int AccessibleObjectFromWindow(
int hwnd, 
uint dwObjectID, 
byte[] riid,
ref Excel.Window ptr);</code></pre>

to get an Excel Instance using his handle, which I get from the process ID of the excel instance.

This is how it looks like when I use these function

<pre><code>const uint OBJID_NATIVEOM = 0xFFFFFFF0;
Guid IID_IDispatch = new Guid("{00020400-0000-0000-C000-000000000046}");
Excel.Window ptr = null; 
int hr = AccessibleObjectFromWindow(hwndChild, OBJID_NATIVEOM, 
 IID_IDispatch.ToByteArray(), ref ptr);

Object objApp = ptr.Application;</code></pre>

This peace of code works great but the only problem is that I had to add a reference to the Office 2003 Primary Interop Assemblies.

As you can see, the last param in the function is the reason why I needed to add the reference to the Pias, so my question is if there is a way of avoiding the use of Interop Assemblies, I have tried with late binding but perhaps I've been doing it wrong because I haven't been able to make it work.

How to use use late binding to get excel instance?

我正在使用[DllImport("Oleacc.dll")]static extern int AccessibleObjectFromWindow(int hwnd, uint dwObjectID, byte[] riid,ref Excel.Window ptr);使用他的句柄获取Excel实例，这个句柄是从ex...

问如何使用后期绑定来获取excel实例？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用后期绑定来获取excel实例？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用后期绑定来获取excel实例？
EN