Fastest way to interface between live (unsaved) Excel data and C# objects

I’ll take this as a challenge, and will bet the fastest way to shuffle your data between Excel and C# is to use Excel-DNA – http://excel-dna.net. (Disclaimer: I develop Excel-DNA. But it’s still true…) Because it uses the native .xll interface it skips all the COM integration overhead that you’d have with VSTO or another … Read more

Using conditional statements inside ‘expect’

Have to recomment the Exploring Expect book for all expect programmers — invaluable. I’ve rewritten your code: (untested) proc login {user pass} { expect “login:” send “$user\r” expect “password:” send “$pass\r” } set username spongebob set passwords {squarepants rhombuspants} set index 0 spawn telnet 192.168.40.100 login $username [lindex $passwords $index] expect { “login incorrect” { … Read more

How to automate creation of new Xcode targets from Applescript/Automator/Shell Script

let me start with this script (for Xcode 4.2.1), Open an XCode project at /this/path/project.xcodeproj (done) Duplicate an existing target and rename it (not implemented) Edit the Build Settings of the new target (done) Add a group to the Source and Resources section, then rename them (done) Add source files to the groups, and add … Read more

What is the best automated website UI testing framework [closed]

I definitively recommend Selenium, you can use it from .NET, supports different browsers, works in automatic builds and CI processes (we use it from CCNet). The code is stable. It has a few quirks, but after all they all do. Whichever tool you choose, I recommend making your own test facade class(es) around it. The … Read more

How to create a zip file in the same format as the Finder’s “Compress” menu item?

I have a ruby script that makes iPhone App Store builds for me, but the zips it was generating wouldn’t get accepted by iTunes Connect. They were accepted if I used Finder’s “Compress” function. millenomi’s answer came close for me, but this command is what ended up working. iTunes Connect accepted my build, and the … Read more

referencing System.Windows.Automation

The UIAutomationClient.dll is located in this folder: C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0 If you can’t find in your Add Reference->.Net tab, then you have to use the Browse tab to go to the given path, and add the assembly (Right Click on the References, choose add reference, click browse tab).

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)