Extract EagleML via Excel - About the New Workbook

The new Excel workbook is created after the extract is generated.

The new workbook contains the following worksheets:

1 Extract Worksheet
2 Profile Worksheet
3 Extract Result Worksheet

Extract Worksheet

The Extract worksheet (Extract %objectType% where %objectType% is the EagleML object type) contains data for the object type for which the extract is requested, for example, Extract SMF, Extract GenericEntity, etc.

This worksheet is a copy of the worksheet in which the EXTRACT button was clicked, with the exception of the Profile section which is moved to a separate worksheet and the EXTRACT button which is renamed to Refresh.

Profile Worksheet

The Profile worksheet contains a copy of the Profile from the worksheet on which the EXTRACT button was clicked. The state of the checkboxes (checked or unchecked) is saved.

In this worksheet, the Select all and Unselect all functionality selects or deselects all the checkboxes.

The following macro is used for Select all:

Sub selectAll()
Dim checkBox As Object
For Each checkBox In ActiveSheet.CheckBoxes
checkBox.Value = xlOn
Next
End Sub

The following macro is used for Unselect all:

Sub unselectall()
Dim checkBox As Object
For Each checkBox In ActiveSheet.CheckBoxes
checkBox.Value = xlOff
Next
End Sub

Extract Result Worksheet

The Extract result worksheet contains a table representation of the EagleML extract (each row corresponds to one EagleML object), based on the specified values of the extract parameters. The selection of columns is based on fields defined in the Profile section.