Alternatively, the provider may attempt to parse the input string and heuristically determine an appropriate data type and value to place into the cell for example, when updating formatted spreadsheet cells. Deletion and Insertion Functions are provided to insert and delete rows. For all functions, the row numbers provide the position within the data set to which the row will be inserted. That is, the row inserted will have the index specified. Deletes cRows from the data set starting at row iRow .
Inserts cRows into the data set starting at row iRow .
The number of rows successfully inserted is returned in pcRowsInserted . Values for the inserted rows are not specified. Use the setVariant function to set the value of the cells inserted. Searching A function is provided that supports some basic searching capability on the data set. The goal of this function is to be fairly easy for the provider to implement while providing the client with a meaningful set of functionality to perform complex searching.