NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Deleted old Excel macro. Apparently, it's no longer supported.

You can import a Microsoft Excel worksheet into Confluence in multiple ways:

  • If you want to import a worksheet into Confluence as a table and edit the table in Confluence from now on, you can paste the cells into the Confluence editor and save the page.
  • If you want to import a worksheet into Confluence as a file, you can import it with the Excel macro. An example follows.

    Office Excel
    nameExcel_Spreadsheet_Row_Two_Yellow_508_compliant.xls

    For instructions, refer to the Excel for Confluence documentation:

    https://confluence.atlassian.com/conf73/view-file-macro-991928244.html#excel

    Multiexcerpt include
    MultiExcerptNameExitDisclaimer
    nopaneltrue
    PageWithExcerptwikicontent:Exit Disclaimer to Include

Wiki Markup
{scrollbar:icons=false}

Importing Excel worksheets into Confluence

This page contains two examples of importing worksheets into Confluence. As a test, one row was colored and the color is not rendered in Confluence.

The viewfile macro may also be used to embed an Excel file into a Confluence page.

Example 1. Excel worksheet pasted into MS Word as RTF with second row colored yellow in MS Word; g,h,i added in Confluence and heading markup added in Wiki Markup view; the row color is not rendered by Confluence.

One

Two

Three

A

b

c

d

e

f

g

h

i

Example 2. Excel worksheet imported with Excel plugin with second row colored yellow in Excel; the row color is not rendered by Confluence. The markup is:

Code Block
{excel:file=^ExcelSpreadsheetRowTwoYellow.xls}

Excel
file^ExcelSpreadsheetRowTwoYellow.xls

...