610
7 APPLICATION INSTRUCTIONS
7.6 Reading/Writing Data Instructions
• When the number of columns differs in each row, the data are also read by ignoring the rows.
Ex.
When the number of columns differs in each row
This type of file in which the number of columns vary with individual rows cannot be created by Excel. It is
created when the CSV file is modified by a user.
(1) Loaded data
(2) File name
(3) Control data
D10: Execution/completion type
D11: Completion status
D12: Number of read-target data
D13: Maximum number of read data
D14, D15: File position
D16: Number of columns
D17: Data type specification
D99: Number of data actually read
D100: Since "Main/sub item" is not a numerical value, the conversion data, 0, is stored.
D101: Since " " is not a numerical value, the conversion data, 0, is stored.
D102: Since "Measured value" is not a numerical value, the conversion data, 0, is
stored.
D103: Since "Excess" is not a numerical value, the conversion data, 0, is stored.
D104: Since "Length" is not a numerical value, the conversion data, 0, is stored.
D105: Since "Temperature" is not a numerical value, the conversion data, 0, is stored.
D106: Since "-21" is a numerical value, it is converted to a binary value.
,
,
CR LF
CR LF
,
-21
,
CR LF
,
[Data saved in CSV format]
Main/sub item
Measured value
Excess
Length
Temperature
SP.FREAD
D10
K2
U0
"ABCD"
D99
M0
(1)
(2)
(3)
[Data to be loaded to the device]
D10
D11
D12
D13
D14
D15
D16
D17
0100H
-
K7
K0
K0
K0
K0
K0
[Control data]
D99
D100
D101
D106
D105
D103
D102
D104
K7
K0
K0
K0
K0
K-21
K0
K0
[Loaded data]
Содержание 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: ......