Restrictions on Excel data

(1) Number of fields that can be set

You can register a maximum total of 10,000 fields for a single cell and column.

(2) Character encoding used when linked with Excel data

In DataMagic, UTF-8 is used as the character encoding when an Excel file is input or output.

When non-UTF-8 encoded data is written to an Excel file, the data is automatically converted to UTF-8.

(3) Content that can be set for field names

The same field name cannot be specified for multiple fields, and the same field name cannot be specified for a cell and a table.

In addition, field names cannot contain commas (,), and field names cannot be set to "sheet".

(4) Input and output of Excel files protected by a password

You cannot input or output book files that are protected by a password.

Specify book files that are not password protected as the input or output target, or disable protection in advance.

(5) Output data to protected sheets

You cannot write data to the sheets that are protected by password.

Specify sheets that are not password protected as the output target, or disable protection in advance.