This is an excerpt from method of mine, which converts a DataTable (the dt variable) into an array and then writes the array into a Range on a worksheet (wsh var). You can also change the topRow variable to whatever row you want the array of strings to be placed at. object[,] arr = new … Read more
The good news is that if you need to make a case-sensitive query, it is very easy to do: SELECT * FROM `table` WHERE BINARY `column` = ‘value’
Actually, pywin32 and ctypes seem to be an overkill for this simple task. Tkinter is a cross-platform GUI framework, which ships with Python by default and has clipboard accessing methods along with other cool stuff. If all you need is to put some text to system clipboard, this will do it: from Tkinter import Tk … Read more
Here’s a flowchart based on “When to use each method of launching a subprocess in Ruby”. See also, “Trick an application into thinking its stdout is a terminal, not a pipe”.
Keep in mind that the message queue that Windows creates for an STA thread is already an implementation of a thread-safe queue. So just use it for your own purposes. Here’s a base class that you can use, derive your own to include your COM object. Override the Initialize() method, it will be called as … Read more
Are there any disadvantages using the IDisposable Interace Sure, it accomplishes absolutely nothing. Using Using or calling Dispose() is never an appropriate way to set a variable to Nothing. Which is all that your code does. We completely avoid to use the two dot rule. Feel free to continue to ignore it, it is nonsense … Read more
How do I properly clean up Excel interop objects?