concept Excel in category powershell

This is an excerpt from Manning's book Learn PowerShell Scripting in a Month of Lunches.
Later in this book, we’re going to teach you how to use SQL Server as a data store for PowerShell scripts. We can’t express how important a skill this is in today’s business world. If we could physically print this paragraph in bold, italicized, blinking text at 64 point, we’d do it. Watching administrators struggle to use Excel as a “database” by digging into its deprecated, decade-old, COM-based automation model makes us sad. Excel isn’t a database, and it isn’t your friend when it comes to data storage.
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, frustrating, and wasteful. Please don’t do it.

This is an excerpt from Manning's book PowerShell in Practice.
The final section of the chapter deals with applications. The Office applications Word and Excel have been chosen as examples because they can be found in most Windows environments. You can combine the discovery scripts presented in the first section with the information regarding Office applications to create a system to document and report on the machines in your environment. But before we can do that, we need to learn how to discover that information.
It’s a fair assumption to say that the Microsoft Office applications will be found on almost every desktop machine in work environments. It’s possible to work with most of the Office applications using PowerShell. There are COM objects representing most of the them. In this section, we’ll concentrate on using Word and Excel, as these are the two applications we’re most likely to use as administrators. We’ll start with Excel by looking at how we can create a spreadsheet and then put data into it. Spreadsheets seem much more useful when they have data. In the same way, we’ll look at creating a Word document and how to push text into the document.