Create Multiple elements from Excel sheet

[vladap]

Hi All,

I am looking for a good solution how to create/import multiple elements from a list which I have in the Excel sheet.
I don´t want to create 50 elements one by one if I already have a list of there names in a sheet, I would like to use this list as and input
for creating these lements?

Is there a function for that or do I need to write a JV script?

[qwerty]

There's a CSV import and a more adanced script in EA's lib. I guess that Geert will chip an and point you to his solution on github ;-)

q.

[Geert Bellekens]

There's a CSV import and a more adanced script in EA's lib. I guess that Geert will chip an and point you to his solution on github ;-)

q.

I'ts not actually on github, but you can download it for free from my website
https://bellekens.com/product/ea-excel-import-export/

But if you only need elements and not attributes or tagged values, you can also use the standard CSV import.

Geert

[Uffe]

Hello,

If you're on the Ultimate edition there is an Office integration package. There's a free trial as well if you only need to use it once.

/Uffe

[Giu Platania]

More and more I use Prolaborate "add elements" to mass create specific elements.

advantages:
1. Prolaborate supports stereotypes, so as long the MDG language is defined you have the proper mask
2. Yo can not only import files (excel and SVS) but also copy paste values
3. It's possible to directly edit values in the mask and save them

Disavantages:
1. you need ProCloudServer and Prolaborate

Hi All,

I am looking for a good solution how to create/import multiple elements from a list which I have in the Excel sheet.
I don´t want to create 50 elements one by one if I already have a list of there names in a sheet, I would like to use this list as and input
for creating these lements?

Is there a function for that or do I need to write a JV script?

[vladap]

ok guys, thanks for the precious advises. I see there is more options. For my case it looks fine to use csv import only 

[Takeshi K]

Hi all.

The simplest way if Excel has only name:
1. Select cells in Excel and press Ctrl+C (cells must be vertical)
2. Ctrl+Right click on the EA diagram background and select 'Create Multiple Elements...'
3. Change 'Type' in the list in the dialog to which you want to create, the click the list to apply the change
4. right-click on the list and select 'Import Names from Clipboard' and press OK button

Not only Excel, but every text is okay at step 1 if the text contains line breaks

HTH,