Use a PowerShell Module to Easily Export Excel Data to CSV

re: Use a PowerShell Module to Easily Export Excel Data to CSV

Jeffrey S. Patton — Mon, 21 May 2012 19:49:14 GMT

Ed, Jeremy

jrv came up with a very clean way of closing out of excel without using a loop. I'm hoping we'll be able to figure out a way to do it with a single call instead of one per object, but check out this tread over in the forums

social.technet.microsoft.com/.../81dcbbd7-f6cc-47ec-8537-db23e5ae5e2f

re: Use a PowerShell Module to Easily Export Excel Data to CSV

Richard — Tue, 24 Apr 2012 14:53:53 GMT

Please change the title to this article. This is not about exporting excel to csv file but instaad in article about how to work with an excel file.

re: Use a PowerShell Module to Easily Export Excel Data to CSV

zx38 — Thu, 21 Jul 2011 18:02:54 GMT

Jeremy,

Take a look at <a href="http://wp.me/p15IqD-2Y" target="_blank">Remove-ComObject function</a>; it cleans up ComObject leftovers very well.

PS: Ignore my previous comment :/

re: Use a PowerShell Module to Easily Export Excel Data to CSV

zx38 — Thu, 21 Jul 2011 17:58:19 GMT

Jeremy,

Take a look at <a href="wp.me/p15IqD-2Y">Remove-ComObject function</a>; it cleans up ComObject leftovers very well.