Import from MS Excel Files

By default, importing Excel 97/2000/XP/2003 formats are supported out-of-the-box. To import spreadsheet data from Excel 2007 or newer, additional libraries are needed before using this procedure. See Import Data from MS Excel 2007 or Newer for instructions on adding the additional libraries.
Oxygen XML Editor offers support for importing MS Excel Files.

To import an Excel file into an XML file, follow these steps:

  1. Go to File > Import > MS Excel file.
  2. Select the URL of the Excel file.
    The sheets of the document you are importing are presented in the Available Sheets section of this dialog box.
  3. Click the Next button.
    Opens the Import criteria dialog box.

    Figure: Import Criteria Dialog Box

  4. Configure the settings for the conversion.
    1. The Import settings section presents the input data in a tabular form. By default, all data items are converted to element content ( symbol), but this can be overridden by clicking the individual column headers. Clicking a column header once causes the data from this column to be converted to attribute values ( symbol). Clicking a second time causes the column data to be ignored ( symbol) when generating the XML file. You can cycle through these three options by continuing to click the column header.
    2. First row contains field names - If this option is enabled, the default column headers are replaced (where such information is available) by the content of the first row. In other words, the first row is interpreted as containing the field names. The changes are also visible in the preview panel.
    3. Customize - This button opens a Presentation Names dialog box that allows you to edit the name, XML name, and conversion criterion for the root and row elements. The XML names can be edited by double-clicking the desired item and entering the label. The conversion criteria can also be modified by selecting one of the following option in the drop-down menu: ELEMENT, ATTRIBUTE, or SKIPPED.
    4. Import Settings - Clicking this button opens the Import Preferences page that allows you to configure more import options.
    5. Import formatted data (as displayed in Excel) - If this option is selected, the imported data retains the Excel styling. If deselected, the data formatting is not imported.
    6. The XML Import Preview panel contains an example of what the generated XML document looks like.
    7. Open in editor - If checked, the new XML document created from the imported file is opened in the editor.
    8. Save in file - If checked, the new XML document is saved in the specified path.
  5. Click Import to generate the XML document.
Parent topic: Importing Data
Previous topic: Import from Text Files
Next topic: Import Data from MS Excel 2007 or Newer