Property | Description |
|---|---|
HeaderRecordRow | Number that indicates a header row: • 0 indicates no header row • A positive value indicates the header row (for example, 37 is a valid value). When reading, it indicates the row that contains the field names. When writing, the header will be written to this row number, assuming this row number is in the range of records being written. Therefore, if the worksheet is cleared or does not exist, and if HeaderRecordRow is set to 50, and there are only 40 records being written, then the header is not written. Similarly, if output mode is Append, HeaderRecordRow is set to 50, and the worksheet already contains 100 records, then the header is not written. |
Flush Frequency | Number of records buffered in the memory before being written to the target. Default value is 0 (all records are written at once). When inserting many records, change the default to a higher value to improve performance. |
Batch Response | The file to which CRUD operation results are written. The format is one entry per record, indicating success or failure. If operation fails, information about cause of failure is returned. Default is to not write a batch response file. |
StyleSampleSize | Number of rows of the source worksheet that should be read to determine the field length and data type (format). The AutomaticStyling property must be set to TRUE when using this property. 0 indicates that all rows in the worksheet must be read. Default value is 5000. |
AutomaticStyling | If set to TRUE, determines the data type and field length by reading the source worksheet until the row number specified by the StyleSampleSize property is reached. Default value is False. Note: To view and write the data in the required format to the target, set the AutomaticStyling property to TRUE. |