Excel Operations
The CData Cmdlets PowerShell Module for Microsoft Excel allows you to manipulate Excel files in a variety of ways. The cmdlet supports reading data vertically and horizontally as well as from user-defined ranges and named ranges. Refer to Selecting Data and Modifying Data for examples of different ways of querying and modifying spreadsheet data.