Indicates whether to use the efficient insert mode, which forces inserts to append new lines to the bottom of the spreadsheet.

Syntax

Connect-Excel -UseFastInsert SwitchParameter

Data Type

bool

Default Value

false

Remarks

When this connection property is set to True, the cmdlet always appends inserted values onto the end and cannot insert rows in the middle of the sheet with the ROWID. This allows INSERT queries to have better performance at the cost of flexibility regarding where rows are inserted. The results of insertions are reflected immediately in the workbook file containing the sheet you're inserting into, regardless of how the BufferChanges connection property is set.

When this connection property is set to False, INSERT queries targeting a specific ROWID are supported. If data already exists on the row corresponding to the ROWID, the cmdlet updates the data -- otherwise, data is inserted in that row.