To create a recipe using a spreadsheet, first create the spreadsheet in Microsoft Excel, save it as a CSV file, and then save it to an external storage device.
Open Microsoft Excel and enter items ":DATE", ":Group NO.", ":GROUP NAME", "ITEM NAME", and "VALUE" to the appropriate locations and enter the recipe data.
(The display unit transfers the data according to these parameters.)
:DATE
Enter the data creation date.
:GROUP No.
Enter the Condition Number to transfer.
:GROUP NAME
Enter an optional Condition Name.
ITEM NAME
You can use the area below the ITEM NAME field to enter comments or additional information as necessary. Do not use a comma or decimal for a title. It may not be read correctly.
VALUE
You can use the area below the VALUE to enter any other information.
Only the data portion will be transferred to the device via Transfer CSV Data. Enter the Condition Number, the Condition Name, and comment as required. When transferring data, regardless of Condition Number and Condition Name, they are transferred according to the conditions set in the [Transfer CSV Data (Condition) (T)]. You can access these from the [Recipe (R)] under [Common Settings (R)].
When there are two or more commas in a single row, data after the second comma is not read.
Save the file to the USB storage device.
Specify the destination to save the file in the external storage "file" folder.
Select "CSV" for the file. Set the file name to "ZR*****.csv", where ***** is a 5-digit file number from 00000 to 65535.
The Recipe is created.
If your computer does not have CF Card drivers (or SD Card drivers), set the destination folder and save. You can transfer the recipe in the CF Card Folder (or SD Card Folder) to the CF Card (or SD Card) in the display unit.
To select the CF Card Folder (or SD Card Folder) in GP-Pro EX, from the [Project (F)] menu, point to [Information (I)] and select [Destination Folder (C)].
3.6.2 Procedure - Setting the Destination Folder
Editing in Microsoft Excel data transferred from the device/PLC to external storage
You can edit in Microsoft Excel and save data transferred from the device/PLC to the external storage device. When opening the CSV file in Microsoft Excel, the following appears:
:DATE
Records the date when the file was saved to the external storage device. The date is recorded using a 4-digit year (for example, "2005/4/30").
:GROUP No.
The Condition Number set in the conditional settings is written.
:GROUP NAME
The Condition Name set in the conditional settings is written.
ITEM NAME
The area below this item is blank.
VALUE
The area below this item contains the transferred data.