User Guide : Map Connectors : Source and Target Map Connectors : Excel 2007, Excel 2010, and Excel (xlsx)
 
Share this page                  
Excel 2007, Excel 2010, and Excel (xlsx)
The Excel 2007, Excel 2010, and Excel (xlsx) connectors allows users to retrieve, insert, update, and delete data from excel files that follow the OpenXML format. The Excel (xslx) connector supports the xlsx format of Microsoft Excel.
The Excel 2007, Excel 2010, and Excel (xlsx) are the same connectors with different aliases.
Properties
You can set the following source (S) and target (T) properties.
Property
S/T
Description
HeaderRecordRow
ST
Optional. Row number used to read the column header names. Default is 0. The row number of the first row is 1.
Batch Size
S
Optional. Number of records the connector caches before processing them.
Flush Frequency
T
Optional. The number of records buffered in memory before being written to the Excel file. Default is 0 (all records are written at once).
Batch Response
T
Optional. 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.
Operations
The Excel 2007, Excel 2010, and Excel (xlsx) connectors supports the following operations:
• Create
• Read
• Update
• Delete
• Upsert
Data Types
The following data types are available:
• Text
• Numeric
Debugging Tips
The system log contains helpful information about exceptions.
Additional Information
Query Statement and Query File
Query Statement and Query File source options are not supported.
Temporary Files
The connectors uses the System temp directory to save temporary files. The temp directory must have read and write permissions.
Header Record
The connectors cannot read a source file if a column name of the header record contains any of the following special characters: &, (, ), single quotation mark, or double quotation mark.
Optimal Performance Settings
Optimal performance settings for using this connector with large data sets are as follows (determined against data sets of 100,000 records):
• Flush Frequency: 10,000
• Target Batch Size: 25,000
• Source Batch Size: 10,000