Cmdlets for Microsoft Excel Online

Build 24.0.9060

MaxRows Parameter (Connect-ExcelOnline Cmdlet)

Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.

Syntax

Connect-ExcelOnline -MaxRows int

Data Type

int

Default Value

-1

Remarks

Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060