Tuesday, April 29, 2008  On Scripts  I spent pretty much the
entire day today onsite at a company for whom I've been working
on custom software in my off hours for the last few months. When
I had reached the point where I was ready to import all their
data (which is currently kept in a series of excel spreadsheets)
into my application, they told me that they were unable to get
all of it ready in time. They had most of it ready, the only
column that was missing in their spreadsheets was the "county"
column, which (of course) held the county for each record in the
spreadsheet. Currently they had somebody manually looking up the
zip code of each one of the 4000 records in the spreadsheet and
filling in it's county appropriately.  Wow, you couldn't ask for
a better opportunity to show off.  I asked them to give me an
hour with an Internet connection, and here's what I came up with
(code is in C#.NET):  static void Main(string[] args)
Excel.Application excel = new Excel.Application(); excel.Visible
= true; Workboo