Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Excel spreadsheet - Scripting Blog [archived]

How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?

February 20, 2007 Feb 20, 2007 02/20/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I specify the number of decimal places to be displayed in an Excel spreadsheet?-- JS(image) (image) (image) Hey, JS. Yes, it is Presidents Day here in the US, a day on which schools, banks, and government offices are all closed. Fortunately, though, the Scripting Guys are open and ready for business. Why...

Hey, Scripting Guy! How Can I Convert an Office Excel Spreadsheet to XML?

January 26, 2007 Jan 26, 2007 01/26/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I convert an Office Excel spreadsheet to XML?-- KE (image) (image) (image) Hey, KE. We apologize in advance if today’s column seems a little rushed; at the moment, we’re sitting in an office, surrounded by boxes and packing crates and waiting for the movers to come in and clear everything out...

How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?

December 5, 2006 Dec 5, 2006 12/5/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I convert a tilde-delimited file to Microsoft Excel format?-- JN(image) (image) (image) Hey, JN. You know, to tell you the truth we’re beginning to rethink our approach to this column. After all, usually we tell people how easy things are, and how – without much effort – they can write a script that ...

How Can I Search Active Directory for User Names Stored in an Excel Spreadsheet?

December 1, 2006 Dec 1, 2006 12/1/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I take user names from an Excel spreadsheet, search for those users in Active Directory, and then indicate whether or not each user was found?-- SD(image) (image) (image) Hey, SD. You know, one of the drawbacks to writing a daily scripting column is that people never seem to believe you. For one thing, ...

How Can I Add a Total Row to an Excel Spreadsheet?

November 15, 2006 Nov 15, 2006 11/15/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I add a bunch of rows to an Excel spreadsheet and then stick a total row at the bottom?-- MW(image) (image) (image) Hey, MW. Could we ask you a favor: is there any chance that you could write back later with this question? As you may or may not know, the University of Washington men’s basketball team is ...