Excel Import Options Dialog Box

Use this dialog box to set the options for importing Microsoft Excel table data into Arbortext Editor. When you have set the options to your desired values, click the OK button to start the table import or click the Cancel button to cancel the table import. Refer to Importing Excel tables for a list of limitations and considerations when working with Excel tables.

During import, a dialog box will display a progress bar for the import. You can click the Cancel button on this dialog box if you wish to stop the import process.

◦ Table Element Name — Use this list to select a valid table element to hold your imported table. The contents of this list may change depending on which document type you are using.

If your document type has more than one table model in it (including custom tables), then this option shows both the name of the table model and the top level element name for the table. For example: OASIS Exchange:table and OASIS Exchange:informaltable

◦ Use First Row as Table Title — When checked, Arbortext Editor will take the first row of copied Excel data, combine the contents of all the cells, and place the result in a title element for the table. The subsequent rows of data will be used to construct a table.

Because this feature combines the content for all the cells in the first row, you should make sure to proofread the resulting title for accuracy.

Since the title needs to be stored in an element, enter the desired element name in the Title Element Name field immediately below the check box. If the table model you choose has a defined title element, that element is inserted into this option by default. Otherwise, the default value is title. The Font Options on this dialog box do not affect the content of the table title.

Arbortext Editor will notify you if the combination of Table Element Name and Title Element Name is illegal for your document type.

◦ Number of Header Rows — Enter the number of header rows contained in the table data in the paste buffer. These rows will be tagged as header rows. The maximum number of header rows is 25.

You can elect to preserve the font characteristics for your imported table data. The font information is preserved on a cell-by-cell basis, and does not preserve font changes to individual characters or words within a cell. These options also do not affect the table title (if that option is checked).

In OASIS Exchange tables, changes to font characteristics are saved as processing instructions, which are typically not compatible with other SGML editors.

◦ Preserve Size — When checked, the imported table data will retain each cell's font size (to the nearest tenth of a point). By default, this option is checked.

◦ Preserve Name — When checked, the imported table data will retain the name of each cell's specified font. By default, this option is checked.

If you intend to move your document to another system, you should verify that the specified font is available on that system. By default, this option is checked.

◦ Preserve Weight — When checked, the imported table data will retain the weight (that is, plain or bold) of each cell's specified font. By default, this option is checked.

◦ Preserve Posture — When checked, the imported table data will retain the posture (that is, plain or italic) of each cell's specified font. By default, this option is checked.

◦ Preserve Horizontal Alignment — When checked, each cell will retain its horizontal alignment setting. The supported settings are:

When unchecked, all cells are set for Left horizontal alignment. By default, this option is checked.

◦ Preserve Vertical Alignment — When checked, each cell will retain its vertical alignment setting. The supported settings are:

When left unchecked, all cells are set for Top vertical alignment. By default, this option is checked.

◦ Apply Borders to All Cells — When checked, table borders will be turned on for all cell borders and the table's outer border. If unchecked, the table will have no cell borders or outer borders. By default, this option is checked.

◦ Use Absolute Column Widths — When checked, table columns will retain the width they had in the Excel spreadsheet. When unchecked, the columns are inserted as relative width columns. Each column will maintain its proportionate size with respect to the other columns, but the overall table width will be limited to the Default display width setting on the Table tab of the Preferences dialog box.