Graphical environments are designed to help novices -PowerShell Automates

by Doug Finke on June 28, 2009

in Automation,Excel,Neal Ford,PowerShell,Productive Programmer

Neal Ford, in his book “The Productive Programmer”, says

The very things that make casual users more productive can hamper power users

He adds

You can get more done at the command line for most development chores than you can through a graphical interface

He was on a project that required opening and updating several spreadsheets on a regular basis. He took a few minutes and wrote a Ruby script to do it.

Even though it didn’t take long to open the files by hand, the little time it took was still a waste of time, so I automated it

The PowerShell Version

Open-XLWB

 
image

DailyLogs

 
image

Result

image

image

For ISE

In the PowerShell Integrated Scripting environment you can launch DailyLogs from the command pane.

Note

Software development has lots of obvious automation targets: builds, continuous integration and documentation. There are less obvious but no less valuable ways to automate development chores

PowerShell is an automation platform, automation platform, automation platform (quote from Jeffrey Snover). Let the automating begin.

Downloads

Place the two scripts in a folder that is in your path.

{ 0 comments… add one now }

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>