Excel Interface Configuration Category

The Excel Interface Configuration Category consists of the Settings sub-category:

Export to Excel - excelout Section

This section is used to select the format of Excel spreadsheets exported from AVEVA P&ID: Item Type or Item Group.

If a spreadsheet is in the Item Type format, data for each item type that was exported is displayed on its own worksheet.

If a spreadsheet is in the Item Group format, item type data is grouped into item categories: pipes, instruments, equipment, valves, line fittings, reducers, nozzles and offsheet connectors. There is a worksheet for each category.

Import to P&ID - excelin Section

This section is used to select the item types imported from Excel spreadsheets into AVEVA P&ID, e.g. drawing attributes, equipment, pipes etc, are to have data imported from the NEW columns on the spreadsheets.

Filter for Excel - excelfilter Section

This section is used to select the default types of items to be exported to Excel spreadsheets from AVEVA P&ID, e.g. drawing attributes, equipment, pipes etc. If required, a different set of item types from these defaults can be selected for each individual export procedure.

Specify the location for Excel In/Out Section

In the Excel Location field, specify where the Excel spreadsheets are to be exported to and imported from.