Is there a easy of importing excel file into DeltaV ARRAY?
Have you looked into bulk importing?
http://www3.emersonprocess.com/systems/support/bol1131/source/extfile/b_theory/html/import_export.htm
Array values are defined as MODULE/PARAMETER[x].CV
where x is row and y is the column numbers.
In reply to Youssef.El-Bahtimy:
I have tried Bulk Editing not Bulk Import, it didn't work
What didn't work? Did you get an error message?
I should said creating format spec file looked a formidable, I'll give it one more try
I see. Creating the format spec file means having to define each element of the array first, via the GUI.
You can manually edit the .fmt to potentially make this go faster, but it is probably not any faster than the GUI.
thanks, I finally successfully created the format spec file and now using it, saving 10 times the amount of time I was manually entering the field values. Although bit of work to convert native excel file format to format spec file format, as all the fields in the spec file shows up in a row, but it is still lot better than entering each value manually. Thanks again
In reply to mnizami:
Great news. Good luck.