Extended instructions
9.9 Recipes and Data logs
S7-1200 Programmable controller
502 System Manual, V4.2, 09/2016, A5E02486680-AK
Display CSV recipe data in Excel
The CSV file can be opened in Excel to make reading and editing easier. If the commas are
not recognized as decimal separators, use the Excel import function to output the data in
structured form
Program instructions that transfer recipe data
RecipeExport (Recipe export)
Table 9- 194 RecipeExport instruction
req:=_bool_in_,
done=>_bool_out_,
busy=>_bool_out_,
error=>_bool_out_,
status=>_word_out_,
Reci-
pe_DB:=_variant_inout_);
The "RecipeExport" instruction exports all
recipe records from a recipe data block to
the CSV file format. The CSV file contains
product names, component names, and start
values. The CSV file is stored in internal load
memory or external load memory, if an op-
tional external "program" memory card is
installed.
The export operation is triggered by the
"REQ" parameter. The BUSY parameter is
set to "1" during export processing. After the
execution of RecipeExport stops, BUSY is
reset to "0" and the completion of the opera-
tion is indicated with "1" at the DONE pa-
rameter. If an error occurs during execution,
then parameters ERROR and STATUS indi-
A recipe DB must be created before a recipe export is possible. The name of a recipe data
block is used as the file name of the new CSV file. If a CSV file with an identical name
already exists, then it is overwritten during the export operation.
You can use the File Browser page (Page 1037) of the CPU's built-in Web server to access
the recipe CSV file. The file is put in the recipe folder in the root directory of CPU load
memory.
To Next Page
Loading...
