606
7 APPLICATION INSTRUCTIONS
7.6 Reading/Writing Data Instructions
■When reading data after converted to CSV format
• Elements in the CSV format file (cells in Excel
) are read by each row and stored in the device.
• If the extension of the target file is omitted, the extension will be ".CSV".
• If the specified file does not exist, an error occurs.
• If the position is specified exceeding the existing file size, 0 point of data is read and the processing completes successfully.
• The number of data specified by (d1)+2 is read from the beginning of the file. If the last data in the file is read before
reaching to the number specified, only the available number of data is read.
• When the number of columns is set to 0, the data are read by ignoring the rows in the CSV format file.
• The string data in the CSV file and the value stored in the device after it is read are determined by the execution/completion
type.
Execution/completion type Data (one element) in the CSV
file
Value stored in the device Remarks
0100H: Decimal (16-bit data) -32768 to -1 -32768 to -1
(32768 to 65535)
The value should be within the range of -
32768 to -1 as signed 16-bit data and within
the range of 32768 to 65535 as unsigned 16-
bit data. The same value is stored in the
device.
0 to 32767 0 to 32767
32768 to 65535 -32768 to -1
(32768 to 65535)
The value should be within the range of -
32768 to -1 as signed 16-bit data and within
the range of 32768 to 65535 as unsigned 16-
bit data. The same value is stored in the
device.
• Numeric values other than above
• String containing alphabets and
symbols
0 Filled with 0 since it cannot be converted.
0110H: Decimal (32-bit data) -2147483648 to -1 -2147483648 to -1
(2147483648 to 4294967295)
The value should be within the range of -
2147483648 to -1 as signed 32-bit data and
within the range of 2147483648 to
4294967295 as unsigned 32-bit data. The
same value is stored in the device.
0 to 2147483647 0 to 2147483647
2147483648 to 4294967295 -2147483648 to -1
(2147483648 to 4294967295)
The value should be within the range of -
2147483648 to -1 as signed 32-bit data and
within the range of 2147483648 to
4294967295 as unsigned 32-bit data. The
same value is stored in the device.
• Numeric values other than above
• String containing alphabets and
symbols
0 Filled with 0 since it cannot be converted.
0120H: Hexadecimal (16-bit data) 0H to FFFFH 0H to FFFFH
• Numeric values other than above
• String containing alphabets other
than A to F and symbols
0000H Filled with 0 since it cannot be converted.
0121H: Hexadecimal (32-bit data) 0H to FFFFFFFFH 0H to FFFFFFFFH
• Numeric values other than above
• String containing alphabets other
than A to F and symbols
00000000H Filled with 0 since it cannot be converted.
0130H: String (ASCII data) String (up to 1999 characters) String (up to 1999 characters) NULL (00H) is added to the end of the string.
When the number of bytes of the string in the
CSV file is even, 0000H is stored in the next
one word.
When the string in the CSV file contains 00H,
it is ignored.
String (2000 characters or more) If the number of characters in one element
exceeds 1999, characters until the 1999th
character are read as one element. The
2000th character and after are not read and
the next element is read.
To Next Page
Loading...
