The maximum number of results to return per page from Microsoft Excel Online when UsePagination is True.

Syntax

Connect-ExcelOnline -Pagesize int

Data Type

int

Default Value

-1

Remarks

The Pagesize property affects the maximum number of results to return per page from Microsoft Excel Online. Setting a higher value may result in better performance at the cost of additional memory eaten up per page consumed. A value of -1 indicates the maximum possible page size for the driver.