Parameters   Output Objects  

Searches Excel Services data.

Syntax

Select-ExcelServices [parameters]

Remarks

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

$conn = Connect-ExcelServices -Url 'https://myorg.sharepoint.com' -User '[email protected]' -Password 'password' -File 'Book1.xlsx'
Select-ExcelServices -Connection $conn -Table "Account" -Columns @("Id","Name") -Where "Industry='Floppy Disks'"