Was this helpful?
Excel 365 Multimode
Excel 365 Multimode is a multimode connector that provides target connections to 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, and the record operation must be Insert.
Note:  This connector appeared in DataConnect 11.6 and earlier versions as the Excel 365 connector. 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 Multimode 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 target connectors, see Specifying Connector, Parts, and Properties.
Connector Properties
You can specify the following target properties:
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 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
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
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.
Supported Operations
Excel 365 Multimode connector supports only Insert operations.
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 Multimode 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.
Last modified date: 02/09/2024