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.
Содержание MELSEC iQ-R Series
Страница 1: ...MELSEC iQ R Programming Manual Instructions Standard Functions Function Blocks ...
Страница 2: ......
Страница 24: ...22 INDEX 2092 INSTRUCTION INDEX 2093 REVISIONS 2104 WARRANTY 2105 TRADEMARKS 2106 ...
Страница 34: ...32 MEMO ...
Страница 35: ...33 PART 1 PART 1 OVERVIEW This part consists of the following chapter 1 OVERVIEW ...
Страница 68: ...66 1 OVERVIEW 1 5 Precautions on Programming MEMO ...
Страница 204: ...202 5 SEQUENCE INSTRUCTIONS 5 3 Output Instructions Operation error There is no operation error ...
Страница 470: ...468 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 472: ...470 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 479: ...6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions 477 6 Operation error There is no operation error ...
Страница 504: ...502 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 518: ...516 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 520: ...518 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 754: ...752 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 756: ...754 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 758: ...756 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 760: ...758 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 895: ...7 APPLICATION INSTRUCTIONS 7 16 Ramp Signal Instruction 893 7 Operation error There is no operation error ...
Страница 917: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 915 7 Operation error There is no operation error ...
Страница 919: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 917 7 Operation error There is no operation error ...
Страница 1415: ...13 SFC PROGRAM INSTRUCTIONS 13 1 SFC Control Instructions 1413 13 Operation error There is no operation error ...
Страница 1448: ...1446 14 REDUNDANT SYSTEM INSTRUCTIONS 14 2 Disabling Enabling System Switching MEMO ...
Страница 1795: ...25 TYPE CONVERSION FUNCTIONS 25 1 Converting BOOL to WORD 1793 25 Operation error There is no operation error ...
Страница 1805: ...25 TYPE CONVERSION FUNCTIONS 25 10 Converting WORD to DINT 1803 25 Operation error There is no operation error ...
Страница 1819: ...25 TYPE CONVERSION FUNCTIONS 25 21 Converting INT to DWORD 1817 25 Operation error There is no operation error ...
Страница 1950: ...1948 32 STRING FUNCTIONS 32 2 Extracting String Data From the Left Right Operation error There is no operation error ...
Страница 1972: ...1970 33 TIME DATA TYPE FUNCTIONS 33 4 Division MEMO ...
Страница 2067: ...APPX Appendix 5 PID Control Program Examples 2065 A 252 Set PID control data for loop 2 ...
Страница 2082: ...2080 APPX Appendix 6 Process Control Program Examples 129 Set the default value of the loop tag ...
Страница 2093: ...APPX Appendix 7 List of Loop Tag Memory Areas Used by Process Control Instructions 2091 A MEMO ...
Страница 2109: ......