User Guide > Map Connectors > Source and Target Map Connectors > Excel 365
Was this helpful?
Excel 365
Excel 365 is a single mode connector that provides source and target connections to the Excel 2007+ worksheets. This connector is like the older native connectors and is compatible with the existing 2007+ connector. On the Target side, a map can use this connector to write to only one worksheet, with one record type.
Note:  The traditional Excel 365 connector has been renamed to Excel 365 Multimode in DataConnect 12.0 and later versions, to better align capabilities with other Multimode connectors. When you load an existing Map that was created when Excel 365 referred to a multimode connector, the target will automatically select Excel 365 Multimode connector.
For information about using Excel 365 on AIX, see Dependencies on AIX.
Connector Parts
Connector parts are the fields you configure to connect with a data source or target.
The settings that are available depend on the connector you select.
For a list of all parts for source connectors, see Specifying Connector, Parts, and Properties.
For a list of all parts for target connectors, see Specifying Connector, Parts, and Properties.
Connector Properties
You can specify the following source (S) and target (T) properties:
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.
Supported Output Modes
Excel 365 connector supports the Replace, Append, and DeleteAndAppend output modes. For more information, see Target Output Modes.
Supported Data Types
The following data types are supported:
• Boolean
• Date
• DateTime
• Number
• String
• Time
Debugging Tips
The system log contains information about exceptions.
Additional Information
If you try to access the same workbook from different connector instances for writing, then it does not work. You can read from multiple worksheets in the same workbook. A worksheet in Microsoft Excel can contain maximum number of 1,048,576 rows and 16,384 columns. However, if you insert more than the maximum range, then the following error message is displayed:
Sending updates to DMS: Unknown exception 'java.lang.IllegalArgumentException' Invalid row number (1048576) outside allowable range (0..1048575)
Note:  The target field size must be set to 255 or lower, then the map runs successfully and the complete data is written. The maximum column width for an individual cell is 255 characters

After connecting to the Excel 365 connector, if your map’s schema does not match with your data schema, then the schema mismatch error is displayed. However, if you set the Schema Mismatch property to Error, a message is displayed to change your schema mismatch property to Use Connection, Match By Name, Connect and then click Refresh to get the new schema.
Note:  If you get this error, when executing a map: “Error 19 running transformation: Could not create new DataTarget: C:\Program Files\Actian\actian-dc-studio-12.1.0-SNAPSHOT\di-standalone-engine-12.1.0-SNAPSHOT\jre\bin\fontmanager.dll: Can't find dependent libraries”, then try setting the PATH variable to include the location of the jre/bin files. For a standard installation: “Set PATH=C:\Program Files\Actian\actian-dc-studio-12.1.0-SNAPSHOT\di-standalone-engine-12.1.0-SNAPSHOT\jre\bin;%PATH%”.
Last modified date: 02/09/2024