2015 Aug 16, 9:56 2015 Aug 2, 10:14 2015 Mar 8, 9:44 2015 Feb 12, 6:29 2013 Aug 15, 10:04
PowerShell nicely includes ConvertTo-CSV and ConvertFrom-CSV which allow you to serialize and deserialize your PowerShell objects to and from CSV. Unfortunately the CSV produced by ConvertTo-CSV is
not easily opened by Excel which expects by default different sets of delimiters and such. Looking online you'll find folks who recommend using automation via COM to create a new Excel instance and
copy over the data in that fashion. This turns out to be very slow and impractical if you have large sets of data. However you can use automation to open CSV files with not the default set of
delimiters. So the following isn't the best but it gets Excel to open a CSV file produced via ConvertTo-CSV and is faster than the other options:
$excel = New-Object -ComObject Excel.Application
$xlDelimited=1 # 1 = delimited, 2 = fixed width
$xlTextQualifierDoubleQuote=1 # 1= doublt quote, -4142 = no delim, 2 = single quote
$consequitiveDelim = $False;
$tabDelim = $False;
$semicolonDelim = $False;
$commaDelim = $True;
See Workbooks.OpenText documentation
for more information.
2011 Oct 18, 4:52
I haven't been updating my blog recently. But I have three excellent reasons:
2010 Jun 29, 1:24
An excellent movie I'd never heard of. An entertaining and humorous sci-fi indie romance comedy. It stars Emma Caulfield (who I recognize as Anya from Buffy the Vampire Slayer) who obsesses over
her timer, an implanted device that counts down to when she'll meet the love of her life. Thematically its similar to Eternal Sunshine of the Spotless Mind which similarly adds a scifi device to
society in order to examine the value of failed relationships on a persons life.
2010 Jun 3, 6:32
Angie's photos from my wedding. There are some excellent bunny slipper photos in there.
2010 Jan 28, 2:32
A typical blog post with typical blog post comments... "This comment gives a link to a YouTube video which is proffered as an excellent example of the thesis of the post, but, is actually only
tangentially so at best."
2009 Dec 12, 12:56
Gizmodo has a list of some excellent Android apps. Includes an OpenTable app, Flixster, and others. But doesn't mention the Aldiko, the ebook reader I like.
2009 Feb 5, 7:31
Excellent retro intro! Be sure to watch the other two high-five videos too.
2008 Oct 2, 9:37
Cool graphical ANTLR IDE! They didn't have this the last time I used ANTLR. "ANTLRWorks is a novel grammar development environment for ANTLR v3 grammars written by Jean Bovet (with suggested use
cases from Terence Parr). It combines an excellent grammar-aware editor with an interpreter for rapid prototyping and a language-agnostic debugger for isolating grammar errors. ANTLRWorks helps
eliminate grammar nondeterminisms, one of the most difficult problems for beginners and experts alike, by highlighting nondeterministic paths in the syntax diagram associated with a grammar."
2008 Sep 9, 8:33
Wired's excellent and awesome photos from CERN's LHC. "On November 27, 2006, the final superconducting main magnet was delivered to CERN's Large Hadron Collider (LHC) -- the most ambitious physics
experiment ever created."
2008 Sep 9, 8:29
Article on the data centers that backup the Internet Archive and handle CERN's LHC's data. "CERN embodies borderlessness. The Swiss-French border is a drainage ditch running to one side of the
cafeteria; it was shifted a few metres to allow that excellent establishment to trade the finicky French health codes for the more laissez-fair Swiss jurisdiction. And in the data sphere it is
2008 Aug 10, 3:33
Doctor Horrible's Sing Along Blog is an Internet only show you may have already watched and heard everything about. If you missed this
somehow, its a musical by Joss Whedon (Buffy the Vampire Slayer, Firefly) staring Neil Patrick Harris as an aspiring super villian who can't get up the courage to talk to his laundromat crush. Its
very funny, fairly geeky, and on the Internet so of course I've enjoyed it thoroughly and have some links to share. It surprised me how many blogs that I don't usually see posting the same things
telling me about it: first on Eric's blog, then The Old New Thing,
and even Penny-Arcade.
Dr. Horrible's again available online via Hulu with commercial interruption.
Check out the official fan site. They link to such things as the owner of Dr. Horrible's house.
He had appeared on Monster House, a reality show about remaking people's homes like Monster Car or Pimp My Ride is about remaking folk's cars, and had his house turned into a evil scientist's lab.
Consequently its a perfect fit for Dr. Horrible and in return the owner appears in one of the final scenes and in the credits as the 'Purple Pimp'. Apparently the purple suit is his. Also on his
blog you can find out what's happened on that big chair that appears in the show. All I'll say about that is, good thing Neil Patrick
Harris wears a lab coat while sitting on it.
At the recent Comic Con some attendees took video of the Dr. Horrible
Comic Con panel (video clips contain spoilers) some of which I've grouped together. Besides the videos containing the creators and stars of the musical who are all hilarious (see Felicia Day's comment on twittering) there's also some excellent bits about a possible second installment and information on the impending DVD. To
finish off this series of Dr. Horrible links check out this Venn Diagram of Felicia Day's work.
2008 Jun 19, 11:10
Most excellent! "Because time travel is still one of the most interesting motifs used in games, movies and on TV, we bring you this fine piece of cotton. Oh, and it comes from the future!"
2008 Mar 19, 11:30
Excellent rant on the history and state of IE8's decision to default to super-standards mode vs IE7 mode.
2008 Feb 15, 6:47
A bug in Excel causes values that should be 65k to be 100k.
2007 Oct 22, 4:47
I purchased the Orange Box
off of Steam a bit ago and like
others before me who have discussed elsewhere
, I already owned two of the five games that come from the Orange Box. However, the combined price of
HL2E2 and Portal, the two games I actually wanted was supposedly equivalent to the price of the Orange Box bundle. Incidentally, if anyone would like HL2 or HL2E1 I can gift
them to you.
HL2E2 was excellent of course but the big surprise for me was Portal. (Mild spoilers follow) It has a sort of zen simplicity: there are a few simple game-play mechanics, a handful of textures and
objects, and a deceptively simple story all used well and tied together to produce an entertaining and polished game. It seems a bit short but its probably better to end with the gamer demanding
more. The humor and the sort of play within a play
aspect of the game is what really sold me though. It has the funniest ending theme
I've heard (also blogged by the creator
). The voices of the automated turrets are so adorable I would feel compelled to hug them if they weren't
always trying to kill me. Additionally the weighted companion cube
seems like an experiment in understanding gamers'
attachment to NPCs. In this case the NPC is a box and yet I still felt awful incinerating it. The whole time I was vaguely reminded of Solitary
the reality show
that sticks contestants alone in small rooms forcing them to endure various tests all the while being watched by a humorous computer with a female voice. Someone should sue...
RPS has articles on Portal including a Portal review
, a page suggesting Portal is a tale of
, and others