Parameters   Output Objects  

Searches Microsoft Excel data.

Syntax

Select-Excel [parameters]

Remarks

The Select-Excel cmdlet allows you to use a syntax similar to SQL SELECT statements to search Microsoft Excel data.

$conn = Connect-Excel -ExcelFile 'C:\MyExcelWorkbooks\SampleWorkbook.xlsx'
Select-Excel -Connection $conn -Table "Sheet" -Columns @("RowId","LastName") -Where "FirstName='Bob'"