The order in which columns will be returned.

Syntax

Select-ExcelOnline -OrderBy string

Remarks

The order in which columns will be returned. The value of this parameter has the same syntax as the ORDER BY clause of an SQL statement. You can specify multiple columns and the order to sort each by in a comma-separated list.

Select-ExcelOnline -Connection $connection -Table "Test_xlsx_Sheet1" -Columns "Column1 ASC" -Where "Column2 = 'Bob'"