The macros are available in Confluence Server only.There are 3 facts that you should know about Table Excerpt and Table Excerpt Include

macros:

1. The macros do not create a copy of

1. the

1. table

You need to mark a table that you want to use as a source for building multiple pivot tables and charts in different places of your page. After this you can reference this table with the Table Excerpt Include macro.

Unlike the Include Page and Excerpt Include macros, the Table Excerpt Include macro will not render another copy of the table after the page saving. Please consider this while inserting the combination of these macros on your page.

1. . The Table Excerpt macro creates a reference to the source table and the Table Excerpt Include macro inserts the reference into the other macros (within the same page only).

2. The main objectives of using the macros are: 

   1. providing dynamic changing of pivot tables and charts when the source table changing;

   2. avoiding loss of productivity when working with large tables (compared to multiple copies of the table);

   3. comfort to operate in the edit mode, when there is only one large table with the small macros instead of multiple large tables

1. 1. .

And actually, why should I use these macros?

Using the Table Excerpt Macro

Adding the Table Excerpt macro to a page:

1. In the Confluence editor, choose Insert > Other Macros.
2. Find and select the required macro.
3. Enter the unique identifier for the macro.

1. Click Insert.

To edit an existing macro: Click the macro placeholder and choose Edit. A macro dialog window will open, where you can edit the parameters of the macro.

Image Removed

Adding a Table into the Table Excerpt Macro

1. Copy (cut) a table.
2. Paste the table into the Table Excerpt macro placeholder.

Image Removed

Configuring Parameters of the Table Excerpt Macro

1. Select the macro placeholder.
2. Click Edit.
3. Enter a unique name for the current macro instance.
4. Click Save.

You will be able to reference the marked table by inserting the Table Excerpt Include macro and entering the specified unique name. You can refer only to the Table Excerpt macros stored on the same page which the Table Excerpt Include macro is placed on.

Image Removed

Using the Table Excerpt Include Macro

To add Adding the Table Excerpt Include macro to a page:

1. In the Confluence editor, choose Insert > Other Macros.
2. Find and select the required macro.
3. Enter the excerpt name of the macro.
4. Select the "Show copy of the source table" checkbox in case you want to show a copy of a source table in the page view mode.
5. Click Insert.

To edit an existing macro: Click the macro placeholder and choose Edit. A macro dialog window will open, where you can edit the parameters of the macro.

Image Removed

Configuring Parameters of the Table Excerpt Include Macro

1. Select the macro placeholder.
2. Click Edit.
3. Enter a unique name of the Table Excerpt macro for outputting a specific table on the page.
4. Click Save.

Image Removed

Using the Same Table for Generating Multiple Charts

1. Insert Insert  the Table Excerpt macro on the page.
2. Place the table on the basis of which you want to build multiple charts or generate multiple pivot tables within the Table Excerpt macro.
3. Enter the unique name for the Table Excerpt macro.
4. Insert multiple instances of the Pivot Table and Chart from Table macrosand place the source table into the macro body according to the instructions above.
5. Insert the Table Excerpt Include macro and entert the unique name of the Table Excerpt macro (to reference it).Place the Table Excerpt Include macro into the combination of according to the instructions above and place it into the Pivot Table and or Chart from Table macros or their combination.
6. Adjust the parameters of the pivot tables and charts.
7. Save the page.

As the result, you will receive multiple charts generated on the basis of the same data table.

View mode:

Image Added

Edit mode:

Image Added

Image Removed

Image Removed