Page tree
Skip to end of metadata
Go to start of metadata

There are 5 macros available within the DataView addon.

#Macro NameDescription
1dataviewThis is the main entry macro. This macro is required for all other macros to work. Allows you to specify the attachment, sheet number etc.
2dataviewresultsDisplays the results of the filter/search on the page. Updated dynamically
3dataviewfilterAllows you to search for a value in a specific column froma drop down selection
4dataviewsearchAllows you to search for a value in a specific column(s) or all columns
5dataviewexportAllows exporting the currently viewed set of results to an Excel file

Macro: dataview

The dataview macro has the following parameters:


ParameterTypeRequiredDefault ValueDescription
1pageconfluence page nameYes
Confluence page where the attachment is stored
2attachment nameselectYes

Attachment on the selected page to use

3hasHeadersbooleanNoTrueWhether the Excel sheet has headers in the first row
4sheetsstringYes0The sheet(s) to index, currently only allows numbers, but future releases should allow for named sheets also
5dateFormatenumerationNodd/mm/yyyyThe default date format to use if Excel doesn't specify


Macro: dataviewresults

The dataviewresults macro has the following parameters:


ParameterTypeRequiredDefault ValueDescription
1sheetstringNo0The sheet to search
2maxRowsintNo
The max. number of rows to display initially on the page when visiting for the first time
3colsstringNo
The columns to display. Currently limited to the Excel character representation, A, B etc.
4useFormattedValuesbooleanNoFalseDisplays the content as formatted values rather than the underlying values as Excel stores. Useful for dates and number values


Macro: dataviewfilter

The dataviewfilter macro has the following parameters:


ParameterTypeRequiredDefault ValueDescription
1sheetstringNo
The sheet to search
2columnstringNo
The columns to filter. Currently limited to the Excel character representation, A, B etc.
3joinenumerationNoANDOnly AND is available at present
4isNumericDatabooleanNoFalseIf the content of this column is numeric data, displays the correct numerical representation. Excel stores all numbers as floating point values, enabling this will display 1 as 1 instead of 1.0


Macro: dataviewsearch

The dataviewsearch macro has the following parameters:


ParameterTypeRequiredDefault ValueDescription
1sheetstringNo
The sheet to search
2restrictColumnstringNo
The columns to limit the search. Currently limited to the Excel character representation, A, B etc., can be multiple columns like "A,B,Y,Z"


Macro: dataviewexport

The dataviewexport macro has the following parameters:


ParameterTypeRequiredDefault ValueDescription
1sheetstringNo
The sheet to search
2exportColumnsstringNoall available columnsThe columns to export. Currently limited to the Excel character representation, A, B etc., can be multiple columns like "A,B,Y,Z"



  • No labels