Skip to Main Content
Learn PowerShell Scripting in a Month of Lunches
book

Learn PowerShell Scripting in a Month of Lunches

by Jeffery Hicks, Don Jones
December 2017
Beginner content levelBeginner
352 pages
10h 31m
English
Manning Publications
Content preview from Learn PowerShell Scripting in a Month of Lunches

Chapter 26. Storing data—not in Excel!

PowerShell can programmatically create and update Excel documents. You can also jump off the roof of your house into a pile of sharp glass. But just because you can do those things, doesn’t mean you should do them. Excel isn’t a database, and it pains us to see people struggling to use it as one. Programming against Excel, in PowerShell, requires you to use the Microsoft Office Programmability components, which are added into .NET when you install Office. Those components, in turn, use a decade-old Component Object Model (COM) interface that Microsoft hasn’t updated in, well, ever. We cry when we see administrators write scripts that literally include hundreds of lines of Excel-related code. It’s time consuming, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learn Windows PowerShell in a Month of Lunches, Third Edition

Learn Windows PowerShell in a Month of Lunches, Third Edition

Don Jones

Publisher Resources

ISBN: 9781617295096Publisher SupportOtherPublisher WebsiteSupplemental ContentPurchase Link