Page top

page-top

Omron uses cookies to improve your experience on this website. By continuing to use the website, you hereby agree to our Privacy and Cookie Policy

Lead Contents

PLC: Store Changeover Data in CSV Format

FAQ No. FAQ01167

Primary Contents

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.