EditLive! 9 Documentation : excelImport

This element configures the manner in which EditLive! reacts when text is imported from Microsoft Excel.

Configuration Element Tree Structure

<editLive>
<excelImport>

<editLive>
     ...
     <excelImport ... />
     ...
</editLive>

Optional Attributes

styleOption

This attribute specifies the user prompting and behaviour of EditLive! upon detecting an import from Microsoft Excel. This attribute has four possible values:

• user_prompt - Users will be prompted as to whether they wish to import Microsoft Excel styles as inline or embedded styles, or strip them from the imported text. The dialog used to prompt the user is the same as the Paste Special dialog.
• merge_inline_styles - This setting will result in EditLive! importing styles from Microsoft Excel with style information applied inline in place of class attributes.
• clean - The clean setting will result in EditLive! stripping the Microsoft Excel styles from the imported text; only structural HTML elements will be imported, such as <b>, <p>, etc.
• plain_text - The plain_text setting will strip out all style information from the imported text.

cleanOption

This boolean value specifies whether the Clean HTML option will appear in the Paste Special... dialog.

Default value: true

mergeInlineStylesOption

This boolean value specifies whether the Styled HTML (Inline) option will appear in the Paste Special... dialog.

Default value: true

plainTextOption

This boolean value specifies whether the Plain Text option will appear in the Paste Special... dialog.

Default value: true

Example

The following example demonstrates how to set EditLive! to prompt the user with style import options every time a Microsoft Excel import is detected.

<editLive>
     ...
     <excelImport styleOption="user_prompt" />
     ...
</editLive> 

Remarks

The <excelImport> element can appear only once within the <editLive> element.

If the <excelImport> element is to be left blank then the element must be a complete tag; it cannot contain a tag body. Therefore the tag must be closed in the same line. It should appear as below:

<excelImport styleOption=... />