Question

Create Entity from Excel Spreadsheet

2

I would like to create an entity programmatically using the column headings from a spreadsheet. Has anyone ever done this? Is there an app in the app store that would be useful? I looked through the Excelmporter module and didn't see anything there that looked useful.

asked 2013-10-21

Mike Kumpf

2 answers

0

You cannot do this: entities cannot be created at run time, they are created at design time.

answered 2013-10-21

Rom van Arendonk

Chris de Gelder · Accepted Answer · 2013-10-21

You can make an XSD of the excel file and import that XSD. Choose to create entities from schema. Note: Creating and XSD from excel is a manual action, you might write a VBA script for that.