Question
How do I store changeover data in the file memory in CSV format, and use the FREAD instruction to copy the data to specific words in the DM Area?
Answer
Refer to control data specifications for the FREAD instruction in the CS/CJ Series Programmable Controllers Instructions Reference.
The file format to read from the Excel file is specified.
The delimiter is specified with bits 12 to 15.
The carriage return is specified with bits 8 to 11.
The above settings are relevant to the data specifications.
When specifying the CSV format, you specify the number of digits in each data cell when you specify the delimiter.
When using words, the delimiter is placed after every 4 digits. When using long words, the delimiter is placed after every 8 digits.
For the carriage return specification, one field equals one cell.
Example:
Refer to the image of Excel as below.
Create this type of data in Excel and save it in CSV format.
 
       What products are recommended as substitutes for the C200H-CPU01 Programmable Controller?
What products are recommended as substitutes for the C200H-CPU01 Programmable Controller?
                 How can I connect a C200H Programmable Controller's CPU Unit with an IBM PC/AT or compatible computer?
How can I connect a C200H Programmable Controller's CPU Unit with an IBM PC/AT or compatible computer?
                 Why communication error occurs during CX-Programmer FA Integrated Tool Package get online with Programmable Controller?
Why communication error occurs during CX-Programmer FA Integrated Tool Package get online with Programmable Controller?