There are two methods to import a table headings from an Excel or CSV file as a schema class. Both ways accomplish the same thing, but have subtle and important differences.

  • Importing a Schema Class by Using the Wizard
  • Importing a Schema Class by Dragging the File to a Class Diagram

Once the plugin has imported the schema class, you can see the imported class in the Containment tree and on the diagram pane. You can undo your last import by clicking Edit on the main menu, and then Undo.

The Import Table Heading from Excel menu in the Import Data from Excel and Create Mapping dialog opens the wizard that helps you import table headings as schema classes and table rows as instance specifications of the schema class. The Import Table Heading from Excel wizard contains options that allow you to:

  • Select which file to import schema classes from (Excel or CSV file).
  • Select a delimiter (CSV file).
  • Select a specific row to start importing schema classes.
  • Import table rows as instance specifications.
  • Map an imported schema class with a target element through the Create Mapping wizard.
  • Create a class diagram that shows all imported schema classes.

This section shows you how to import schema classes from an Excel or CSV file only. For more information about importing instance specifications, see Importing Data to a Schema Class or Importing Data Through a Class Mapping or Mapping a Schema Class to an Element For more information about mapping a schema class, see section Mapping a Schema Class to an Element.

The following sections show you how to use the wizard and drag-and-drop operation to import a table heading as a schema class.