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

20000

Remarks

The Pagesize property controls the maximum number of results returned per page from Microsoft Excel Online. Setting a higher value may improve performance by reducing the number of round trips, but will consume more memory per page. Special considerations: - SharePointSites table: Has a default page size of 500 and will not accept larger values. This table honours the Pagesize property independently without requiring UsePagination to be enabled. - Setting Pagesize to -1 enables dynamic page sizing, which optimizes performance by adjusting the page size based on the data being retrieved. With this setting, results will be retrieved in a serial manner rather than using parallel processing.