Skip to content

Latest commit

 

History

History
62 lines (45 loc) · 3.79 KB

README.md

File metadata and controls

62 lines (45 loc) · 3.79 KB
Raw
category order url menu-title meta-title-short
inserting-content
60
features/pastefromexcel
Paste from Excel
Paste from Excel

Pasting Content from Microsoft Excel

This feature was introduced in CKEditor 4.7. It is provided through the Paste from Word plugin that is included in the Standard and Full presets available from the official CKEditor 4 Download site. You can also {@link guide/dev/plugins/README add it to your custom build} with online builder.

The Paste from Word plugin allows you to also paste content from Microsoft Excel and maintain original content structure and formatting. As of CKEditor 4.7 some more advanced Excel features are not supported yet and will be added in future CKEditor 4 releases.

When the plugin is enabled, it automatically detects Excel content and transforms its structure and formatting to clean HTML. It also adds the Paste from Word toolbar button (Paste from Word toolbar button) which makes it possible to paste clipboard data this way only on demand.

Supported Features

The following formatting will be reatained when pasting from Microsoft Excel:

  • Text formatting
    • Text and background colors
    • Font name, style and size
    • Basic formatting (bold, italic, underline)
    • Font effects (strikethrough, superscript, subscript)
    • Heading levels
    • Text alignment
  • Cell formatting (size, background, borders, special characters)
  • Row and column size

Sample

The following sample content from a Microsoft Excel document:

{@img assets/img/pastefromexcel_01.png Sample Excel document}

will look like below after pasting to CKEditor 4 with the Paste from Word plugin enabled:

{@img assets/img/pastefromexcel_02.png Excel content pasted into CKEditor}

Paste from Excel Demo

See the {@linkexample pastefromexcel working "Pasting content from Microsoft Excel" sample} that showcases the using the Paste from Word plugin to paste Excel content.

Related Features

Refer to the following resources for more information about pasting content as well as support for tabular data:

  • The {@link features/table/README Table plugin} provides support for creating and editing complex tables including features like resizing, styling, custom selection and complex structural changes (merge, split, insert, remove cells, rows, columns).
  • The {@link features/pastefromword/README Pasting content from Microsoft Word} article contains more information about the Paste from Word plugin and its features.
  • The {@link features/pastefromgoogledocs/README Pasting content from Google Docs} article contains more information about the Paste from Google Docs feature.
  • The {@link features/pastefromlibreoffice/README Pasting content from LibreOffice Writer} article contains more information about the Paste from LibreOffice feature.
  • The {@link guide/dev/deep_dive/clipboard/README Clipboard Integration} article explains how Clipboard API is implemented in CKEditor 4.
  • The {@link guide/dev/integration/file_browse_upload/file_upload/README Uploading Dropped or Pasted Files} article describes drag&drop in CKEditor 4.
  • The {@link guide/dev/acf/README Content Filtering (ACF)} is an introduction to CKEditor's unique content filtering system.
  • The {@link features/styles/README Applying Styles to Editor Content} article discusses creating more semantically correct text styles.