You can use this property to enforce read-only access to Microsoft Excel Online from the provider.

Syntax

Connect-ExcelOnline -Readonly SwitchParameter

Data Type

bool

Default Value

false

Remarks

If this property is set to true, the cmdlet will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.