Parameters   Output Objects  

Searches Microsoft Excel Online data.

Syntax

Select-ExcelOnline [parameters]

Remarks

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

$conn = Connect-ExcelOnline
Select-ExcelOnline -Connection $conn -Table "Test_xlsx_Sheet1" -Columns @("Id","Column1") -Where "Column2='Bob'"