Whether or not the CData ADO.NET Provider for Microsoft Excel Online should use client side paging.

Syntax

Connect-ExcelOnline -UsePagination SwitchParameter

Data Type

bool

Default Value

false

Remarks

Whether or not the CData Cmdlets PowerShell Module for Microsoft Excel Online should use client side paging. We suggest you set this to true in case of a large dataset.