Importing tables created in microsoft excel – Rockwell Automation Allen-Bradley Plot Software User Manual User Manual
Page 33
THE INPUT SCREEN 33
The import of data from programs like Microsoft Excel is also possible via
the simple copy function. To do this, the data is marked and copied in the
other application (e.g. in Excel with Ctrl + C) and then pasted directly into
AB-Plot from the clipboard.
Various options can be selected here in order to recognize/generate project
fields.
For example, if a two-column table is created in Excel and the marked area
of the two columns A and B is copied to the clipboard, then one of the fol-
lowing paste variations may be chosen.
Figure 35 Importing Tables Created in Microsoft Excel
Ctrl + V The copied columns A and B are recognized as marker texts
and entered in the sequence: 1996, Jan, space, Feb, space, etc.
The data is read from left to right, with returns as well. This
corresponds to the normal "Paste" command in the "Edit"