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

Learn PowerShell Scripting in a Month of Lunches, Second Edition

by James Petty, Jeffery Hicks, Don Jones
April 2024
Beginner to intermediate content levelBeginner to intermediate
336 pages
8h 51m
English
Manning Publications
Content preview from Learn PowerShell Scripting in a Month of Lunches, Second Edition

26 Storing data—not in Excel!

PowerShell offers the capability to generate and modify Excel documents dynamically. Yet just because it’s feasible doesn’t mean it’s the right approach. Excel isn’t designed to function as a database, and it’s disheartening to witness individuals grappling with it as such. Developing scripts that interact with Excel through PowerShell necessitates the use of Microsoft Office Programmability components, which are integrated into .NET when Office is installed. These components, in turn, rely on a Component Object Model (COM) interface that Microsoft hasn’t updated in ages.

It’s hard to watch administrators crafting scripts that involve extensive Excel-related code, resulting in a time-consuming, exasperating, and ...

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 PowerShell Scripting in a Month of Lunches

Learn PowerShell Scripting in a Month of Lunches

Jeffery Hicks, Don Jones
Learn PowerShell in a Month of Lunches, Fourth Edition

Learn PowerShell in a Month of Lunches, Fourth Edition

Tyler Leonhardt, Travis Plunk, James Petty

Publisher Resources

ISBN: 9781633438989Supplemental ContentPublisher SupportOtherPublisher WebsiteSupplemental ContentPurchase Link