4.1.3 Editing the Database with Excel

You can manage the database externally using Microsoft Excel.

Editing the Database with Excel

(1) Copying from the database to Excel

a) Select the tag or tags to be copied to Excel. You can select multiple tags using [Shift + Left-click] or [Ctrl + Left-click]. When you select a group tag, the subordinate tags are also selected.

b) Copy (Ctrl + C) the selected tags to the clipboard.

c) Paste (Ctrl + V) the contents directly into Excel. Each column stores a different tag attribute. Please refer to the table in the next section for details.

d) Edit the database in Excel. You can automatically create consecutive tags with Excel’s increment/decrement feature. Note: Excel’s auto-increment feature does not work for hexadecimal values. Please double-check that word and bit addresses for real tags follow the correct device address format.

(2) Pasting from Excel to the database

a) Select the rows to copy.

b) Copy (Ctrl + C) the rows to the clipboard and paste (Ctrl + V) them to the XpanelDesigner Database manager. Tags with the same name will be replaced by the pasted contents.

Excel Column Tag Attributes (based on tag type)