Field list
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
||
|---|---|---|---|---|---|---|
|
ID |
|
Alphanumeric characters and symbols (#1) |
No |
50 bytes or fewer |
||
|
Business group |
|
A business group for which general users have access permissions. Alternatively, a business group whose only purpose is to be used for filter conditions. |
Yes |
|
||
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
||
|
I/O category |
The value is specified in the dialog box. |
Input or Output |
No |
|
||
|
I/O category = Input |
||||||
|
|
Target sheets |
All sheets |
All sheets, Specify sheets to read, Specify sheets to exclude |
No |
|
|
|
Management Excel file |
|
|
Yes |
|
||
|
Sheet name |
The value cannot be specified. |
If Target sheet is All sheets, the setting cannot be specified. |
Yes |
|
||
|
|
If Target sheet is Specify sheets to read or Specify sheets to exclude, the setting is the sheet name included in the Excel file for input data. |
No |
255 bytes or fewer To specify multiple sheet names, delimit the sheet names with forward slashs (/). The maximum length of a sheet name is 31 characters. |
|||
|
Handling cells with errors |
Treat as errors |
Treat as errors, Treat as empty data |
No |
|
||
|
Single cell tab |
||||||
|
|
No. |
|
Serial number starting from 1 |
No |
The maximum number of fields is 10000 including individual cells and tables. |
|
|
Cell |
|
Excel row or column address Input format (A1 to XFD1048576) |
No |
Only uppercase alphabetic characters and numeric characters can be input.If lowercase alphabetic characters are entered, they are converted to uppercase alphabetic characters. You cannot select the same cell among single cells. |
||
|
Field name |
|
Excel field name (#3) "Sheet" cannot be specified. |
No |
255 bytes or fewer |
||
|
Field type |
|
Field type
|
No |
|
||
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
||
|
|
Table tab |
|||||
|
|
No. |
|
Serial number starting from 1 |
No |
The maximum number of fields is 10000 including individual cells and tables. |
|
|
Column |
|
Excel row or column address Input format (A to XFD) |
No |
Only uppercase alphabetic characters and numeric characters can be input. If lowercase alphabetic characters are entered, they are converted to uppercase alphabetic characters. You cannot select the same column within a table. |
||
|
Field name |
|
Excel field name (#3) "Sheet" cannot be specified. |
No |
255 bytes or fewer |
||
|
Field type |
|
Field type
|
No |
|
||
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
||
|
Initial row number |
|
Number |
No |
7 bytes or fewer |
||
|
End position |
End of data |
End of data, Empty record, Empty row in a specified column, Specified row, Row containing an empty cell |
No |
|
||
|
Specified column |
|
The row number to be specified as the end position (halfwidth uppercase letter) |
No |
If End position is a row whose specific column is empty: 4 bytes or fewer |
||
|
Final row number |
|
The target column to be specified as the end position (halfwidth number) |
No |
If End position is Specified row: 7 bytes or fewer |
||
|
I/O category = Output |
||||||
|
|
Target sheet |
Use a fixed value |
Use a fixed value, Use a field value |
No |
|
|
|
Management Excel file |
|
|
Yes |
|
||
|
Sheet name |
|
Halfwidth alphanumeric characters, halfwidth kana characters, halfwidth spaces, symbols (#4), and other characters (#5) |
No |
If Target sheets is Use a fixed value: 31 characters or fewer |
||
|
Use a template |
(unselected) |
|
Yes |
|
||
|
Template file name |
|
Alphanumeric characters, halfwidth kana characters, halfwidth spaces, symbols (#4), and other characters (#5) |
No |
200 bytes or fewer |
||
|
Template sheet name |
|
Alphanumeric characters, halfwidth kana characters, halfwidth spaces, symbols (#4), and other characters (#5) |
No |
If Use a template is selected: 31 characters or fewer |
||
|
Single cell tab |
||||||
|
|
No. |
|
Serial number starting from 1 |
No |
The maximum number of fields is 10000 including individual cells and tables. |
|
|
Cell |
|
Excel row or column address Input format (A1 to XFD1048576) |
No |
Only uppercase alphabetic characters and numeric characters can be input.If lowercase alphabetic characters are entered, they are converted to uppercase alphabetic characters. You cannot select the same cell among single cells. |
||
|
Field Name |
|
Excel field name (#3) "Sheet" cannot be specified. |
No |
255 bytes or fewer |
||
|
Field type |
|
Field type
|
No |
|
||
|
Comments |
|
Characters (#2) |
Yes |
255 bytes or fewer |
||
|
Table tab |
||||||
|
|
No. |
|
Serial number starting from 1 |
No |
The maximum number of fields is 10000 including individual cells and tables. |
|
|
Column |
|
Excel row or column address Input format (A to XFD) |
No |
|
||
|
Field name |
|
Excel field name (#3) "Sheet" cannot be specified. |
No |
255 bytes or fewer |
||
|
Field type |
|
Field type
|
No |
|
||
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
||
|
Initial row number |
|
halfwidth number |
No |
7 bytes or fewer |
||
|
#1 |
: |
You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()). |
|
#2 |
: |
No line breaks can be registered. |
|
#3 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), ampersands (&), commas (,), or external characters. Operations are not guaranteed if you use any platform-dependent characters. |
|
#4 |
: |
The following symbols cannot be specified: "/" (slash), "\" (backslash), "[" (left square bracket), "]" (right square bracket), ":"(colon), "," (comma), "*" (asterisk), "?" (question mark). |
|
#5 |
: |
External characters cannot be used. Operations are not guaranteed if you use any platform-dependent characters. |
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|
|---|---|---|---|---|---|
|
Select Excel sheet |
|
Excel image to be imported. Display only |
|
|
|
|
Excel image |
|
Excel image to be imported. Display only |
|
|
|
|
Add as a single cell (Only Cell) |
|
Specify the cell from the displayed Excel image. The address of a selected cell in an Excel sheet (for example, A1 or B3) is stored. The field name is left empty. |
|
The maximum number of fields for the field settings is 10000 including individual cells and tables. |
|
|
Add as a single cell (Cell and Field Name) |
|
Specify the cell and field name from the displayed Excel image. If two cells next to each other are specified, the value of the left cell is stored in the field name, and the address of the right cell in the Excel sheet (for example, A1 or B3) is stored in the cell. If two cells vertically next to each other are specified, the value of the upper cell is stored in the field name, and the address of the lower cell in the Excel sheet (for example, A1 or B3) is stored in the cell. |
|
The maximum number of fields for the field settings is 10000 including individual cells and tables. |
|
|
Add as a column of a table |
|
Specify the range selected in the table format in the Excel image. If you do not select the range, an error occurs. In addition, if you do not select two cells or more, an error occurs. |
|
The maximum number of fields is 10000 including individual cells. |
|
|
Single cell tab |
|||||
|
|
No. |
|
Serial number starting from 1 |
No |
The maximum number of fields is 10000 including individual cells and tables. |
|
Cell |
|
Excel row or column address Input format (A1 to XFD1048576) |
No |
Only uppercase alphabetic characters and numeric characters can be input. If lowercase alphabetic characters are entered, they are converted to uppercase alphabetic characters. You cannot select the same cell among single cells. |
|
|
Field name |
|
Characters (#1) |
No |
255 bytes or fewer |
|
|
Field type |
M |
M: Variable-length characters D: Date type Z: Numeric character string |
No |
|
|
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
|
|
Table tab |
|||||
|
|
No. |
|
Serial number starting from 1 |
No |
The maximum number of fields is 10000 including individual cells and tables. |
|
Column |
|
Excel row or column address Input format (A to XFD) |
No |
|
|
|
Field Name |
|
Characters (#1) |
No |
255 bytes or fewer |
|
|
Field type |
M |
M: Variable-length characters D: Date type Z: Numeric character string |
No |
|
|
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
|
|
Initial row number |
|
Display only |
|
|
|
|
End position |
|
Display only |
|
|
|
|
Final row number |
|
Display only |
|
|
|
|
Specified column |
|
Display only |
|
|
|
|
#1 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), ampersands (&), or commas (,). |
|
#2 |
: |
No line breaks can be registered. |