Import Data from Excel

Electrical Engineer includes facilities to data associated with a specific datasheet form type into the AVEVA Electrical project database from a Microsoft Excel Workbook.

To import an Excel datasheet:

1. With the Browse Data By Form Type open and the form type selected, click From Excel in the Import section of the Manage tab.

2. The Import Items window is then displayed:

   

3. The window enables users to specify which type or types of data are to be imported. Check the appropriate checkboxes and click Save.

4. The Select excel workbook to import window is then displayed for the first type of item (for example, datasheet list data) the user specified was to be imported. Select the spreadsheet that the first type of data is to be imported from and click Open.

5. The import procedure then continues in the standard way, as described in the Common Functionality User Guide.

6. Once the import for the first selected item type is completed (or if it is cancelled), the user will be prompted to select a spreadsheet for the next selected data type (if there is one), until all import procedures are completed.

   Note:
   Whenever the import detects a duplicate column name, it will append the column number on the end, so the end will result will be, for example, "Rating_A" and "Rating_B".