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.
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.
Chris de Gelder
You cannot do this: entities cannot be created at run time, they are created at design time.