Property | S/T | Description |
|---|---|---|
HeaderRecordRow | S/T | 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 | T | Number of records that are buffered in the memory before being written to the Excel file. 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 | T | File to which the CRUD operation results are written. The format is one entry per record, indicating success or failure. If the operation fails, then information about the cause of failure is returned. |
StyleSampleSize | S/T | 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 | S/T | 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. |