Scripting Blog

A place to learn about PowerShell and share stories of automation

ADO.NET - Scripting Blog

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (04/03/09)

April 4, 2009 Apr 4, 2009 04/4/09
ScriptingGuy1
Troubleshooting the Application of Two WMI Classes   Hey, Scripting Guy! The examples produced from the "Scriptomatic Version 2.0 by The Microsoft Scripting Guys" for the entries Win32_ServiceSpecification and Win32_ServiceControl both return error 0x80041002 under Windows Server 2003. I can't find another WMI class that exposes the ...

Hey, Scripting Guy! How Can I Write to Excel Without Using Excel?

September 16, 2008 Sep 16, 2008 09/16/08
ScriptingGuy1
Hey, Scripting Guy! I need to be able to write information to an Excel file. I do not want to install Microsoft Office Excel on my server, but the spreadsheet format is a nice way to store information. I can then give it to my pointy-headed boss, and he can create pivot tables, charts, or whatever exactly it is he does all day. Basically, ...

Hey, Scripting Guy! How Can I Read from Excel Without Using Excel?

September 12, 2008 Sep 12, 2008 09/12/08
ScriptingGuy1
Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server. How can I use this spread sheet without installing Office on my server (which I understand is ...