.Net Excel Interop Deleting a worksheet
After more than one hour looking I found the answer: xlApp.DisplayAlerts = false; worksheet.Delete(); xlApp.DisplayAlerts = true;
interop
Java and C# interoperability
I am author of jni4net, open source interprocess bridge between JVM and CLR. It’s build on top of JNI and PInvoke. No C/C++ code needed. I hope it will help you.
Java Scala interop: transparent List and Map conversion
Trust me; you don’t want transparent conversion back and forth. This is precisely what the scala.collection.jcl.Conversions functions attempted to do. In practice, it causes a lot of headaches. The root of the problem with this approach is Scala will automatically inject implicit conversions as necessary to make a method call work. This can have some … Read more
Using C/inline assembly in C#
It’s actually very easy and does not even require reflection. [SuppressUnmanagedCodeSecurity] [UnmanagedFunctionPointer(CallingConvention.Cdecl)] private delegate int AssemblyAddFunction(int x, int y); [DllImport(“kernel32.dll”)] private static extern bool VirtualProtectEx(IntPtr hProcess, IntPtr lpAddress, UIntPtr dwSize, uint flNewProtect, out uint lpflOldProtect); ……………………………… byte[] assembledCode = { 0x55, // 0 push ebp 0x8B, 0x45, 0x08, // 1 mov eax, [ebp+8] 0x8B, 0x55, … Read more
Can I overlay a WPF window on top of another?
I’ve worked around this problem by using a Popup rather than a transparent Window Update I ended up with a subclassed Popup which I call AirspacePopup. What AirspacePopup does Follow its PlacementTarget. Is not always-on-top, but placed relative to the Window in which it is being placed. This solution comes from Chris Cavanagh’s Blog. Is … Read more
Converting a C char array to a String
The C array char name[8] is imported to Swift as a tuple: (Int8, Int8, Int8, Int8, Int8, Int8, Int8, Int8) The address of name is the same as the address of name[0], and Swift preserves the memory layout of structures imported from C, as confirmed by Apple engineer Joe Groff: … You can leave the … Read more
How to get type of COM object
Add reference to Microsoft.VisualBasic.dll and then: Microsoft.VisualBasic.Information.TypeName(someCOMObject) MSDN reference here.
git forces refresh index after switching between Windows and Linux
You are completely correct here: The thing you’re using here, which Git variously calls the index, the staging area, or the cache, does in fact contain cache data. The cache data that it contains is the result of system calls. The system call data returned by a Linux system is different from the system call … Read more
Referencing Google’s V8 engine from a .NET app
I realize that this may not be an exact answer to your question, but I figured I would put my 2 cents worth in as I doubt to many people have tried this. I got it to work by created a managed wrapper using mixed mode C++. There are other ways to do it, but … Read more