Embed an Excel-like table in a Confluence page which can also be exported back to Excel.
Why would you use this macro instead of simply adding a table to your page? In a word, formulas.
You can either create and edit data in your spreadsheet from scratch, or import from an existing Excel spreadsheet
Clicking on Full Screen will open the table in a more Excel-like view, with the ability to do simple sorting and filtering.
Clicking on Edit will give you full editing capability.
Though Elements Spreadsheet looks a lot like Excel, there are a couple differences in the menu bar, highlighted below
Adding a sheet (aka tab) is at the top of the table rather than the bottom.
You must indicate header rows and columns using the formatting buttons in order to properly sort and filter using headers.
To return to the Confluence page, click the X in the upper right.
Elements Spreadsheets supports around 400 formulas, including vlookup, sum, and countif. Just like in Excel, type = in the cell, followed by the first few letters of your formula and ES will give you a list of formulas to choose from.
Feel free to mess around with the sample spreadsheet below.