Skip to end of metadata
Go to start of metadata


The Confluence wiki has an Office Excel macro that enables you to attach a spreadsheet to a wiki page and then show a specified worksheet and region of the Excel file on the page. To do this:

  1. add a page to your wiki using the Add menu
  2. save the page
  3. add an attachment to that page via the Add menu
  4. click the Insert/Edit Macro icon in the toolbar 
  5. Type "excel" into the search box of the Select Macro window and press enter
  6. Click the Office Excel item
  7. You'll see a dialog box come up (see screenshot in the right column). Select the spreadsheet you attached from the File Name popup menu
  8. Optionally, if you'd like to show a specific worksheet or row/column range, specify those values in the provided fields
  9. Click Insert and then save your page

The macro editor will write the wiki markup for you which will look something like:

{viewxls:name=sample.xlsx|sheet=Summary|row=13|col=3}

Tip: If you ever need to revise your spreadsheet, simply revise it and upload it to the wiki page using the same filename as before. The wiki will save the previous version of the file and use the new one to render the spreadsheet contents on the page.

Note: The Office Excel macro does not support Excel 95 format and earlier. If you attach a spreadsheet and it's contents don't display, open it with Excel and confirm that it is saved in a format later than that such as Excel 97-2004 or the current xlsx format.

Example of an Embedded Spreadsheet

Overall Summary
% of Available
NUs Available41,776,550,159
NUs Requested73,002,261,024174.7%
NUs Allocated37,485,866,79589.7%
NUs Delivered27,440,814,05365.7%
% of Delivered
Allocated27,183,839,63299.1%
Specific26,007,022,32894.8%
Roaming391,233,6711.4%
Discretionary90,538,6410.3%
Staff166,435,7800.6%

1 Comment

  1. Markus, is the "viewxls" macro going to be installed for use on wiki.ucar.edu?

    fg