7.2 - Adding Features with the Excel add-in

Datasheets & Powersheets

Now that we have added the add-in to Elfsquad. Can we start adding features in Elfsquad. In this case we only add features to Elfsquad, you still have to assemble them into a configuration model in Elfsquad yourself of course. Building a full model with our add-in is also possible, however, this requires you to already have quite some knowledge of our add-in, so we will not cover this within these academy videos.

First, let's look at a datasheet. Make sure you have Excel open and logged in to the add-in. You will now see several data sheets and power sheets. Find the data sheet 'features' and click on it, then you will see a number of options:

• Open sheet: Clicking here opens the selected sheet. 
• Highlight changes: When you have made changes to the opened sheet you can highlight the changes made with this function.
• Update changes: After you have made changes in the opened sheet you can make them by clicking update changes.
• Filters: Before you open a sheet, you can also choose to set some filters. This way you can ensure that only the features you want to change are shown in the opened sheet.

Adding the first Feature

We are now going to add the first Feature.

1. Click on the datasheet 'Features'

2. Click on open sheet

3. Scroll all the way to the bottom and add a new feature by entering a name in the appropriate column for name, you can find this under column P in Excel.

4.  Then also add an item code to the feature, in this example we will use the code 1000.

5. Click on the update changes

When you look in Elfsquad, you will see that the feature you just created has been added. 

Creating multiple features simultaneously

You can also add multiple features to Elfsquad at once. Below we have prepared an Excel file that you can use to do a first feature import, download the file and open it. 

1. Select all feature names in column A of the file.

2. Copy these and then paste this in the data sheet Features of the add-in, these are names so we will paste it in Column P.

3. After pasting, you can see that the add-in has registered 100 changes. 

4. Click on update changes

Download: Excel add-in - Features

Assignment

Now also paste the other data from the first sheet of the file into the correct columns. So in this case, the feature code, sales price and customfield1.