Oxygen XML Editor offers
support for importing MS Excel Files. To import Excel files, go to and in the Import dialog box select the file you want to
import. In the Available Sheets section of this dialog, the sheets of
the document you are importing are presented. Select a sheet and click next to move on to the
second Import dialog box. 
Figure: The "Import" Dialog Box - Import Criteria
The Settings section presents the data from the Excel sheet in a
tabular form. It also contains the following options:
- First row contains field names - Uses the content from the first row to name the columns.
- Import formatted data (as displayed in Excel) - Keeps the Excel styling.
- Change labels - Opens the Presentation
Names dialog box. The following options are available:
- Root Element - allows you to edit the name of the Root element.
- Row Element - allows you to edit the name of the Row element.
- Real Name - contains the original name of each Heading.
- XML Name - allows you to modify the names of the Headings.
- Criterion - allows you to transform the Heading elements to attributes of the Root element.
Import
settings - Opens the XML / Import preferences page.
The XML Import Preview section displays the Excel document in an XML format.
The Output File section contains the following options:
- Open in Editor - Opens the imported document in the Editor;.
- Save in File - Saves the imported documented in the specified location.
When you finish configuring the options in these dialogs, click Import.