Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separatorpipe

...

Selected from the Macro BrowserExcel
Markup Shortcut{excel}

Screenshot

Parameters

...

highlightColor#ffffec
rowStylesbackground:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;,
multiplefalse
stylebackground-color:white;
autoNumbertrue

...

Parameter

...

Default

...

Macro Browser Label

...

Description

...

Macro Editor LabelDefaultDescriptionMacro Parameter
Output

Specify how the output is

...

treated. The options are as follows:

  • html - data is entered as standard HTML directly in the macro body
  • xhtml - data is treated as XHTML and rendered with the Confluence XHTML renderer prior to display
  • wiki - data is surrounded by a noformat macro. This is a very special case.
output
Page of attachment

Enter the location of data. If specified, the included data follows the body data (if any).

  • ^attachment - Data is read from an attachment to the current page.
  • page^attachment - Data is read from an attachment to the page name provided.
  • space:page^attachment - Data is read from an attachment to the page name provided in the space indicated.
page
Name of attachment

...


Enter the name of the attachment. By default, the attachment

...

is presumed to be on the current page.

...

name
Profile

Enter a profile name. Administrators set up profiles to connect to other applications such as GitHub or GitLab.

Contact your administrator to know more about the profiles used in your instance. To know more about how profiles are configured, refer to this link.

profile
URL to Excel file

...


Enter the relative path to the Markdown file(s) to be displayed. If a valid path is entered here, the macro accesses the given location and processes the content accordingly.

A profile comprises a base URL and other credentials that are required to access a specific application. These details point to the actual location where the required Markdown file(s) are available. The contents are then accessed and displayed through the macro.

Note

If an absolute URL is entered here, the macro reads content from the specified URL. If a profile is also specified, the macro ignores the given profile and processes content through the given URL.


url
URL user
Enter the user name for URL access that requires basic authentication.user
URL user password
Enter the user password for URL access that requires basic authentication.password
URL connection timeout
Enter time in milliseconds such that URL connections do not timeout before getting data. Use this to increase the access time needed for slow connections. Note that if a zero is given the connection may wait infinitely.timeout
Sheets to import
By default, each sheet in the workbook produces a table. Use the sheets parameter to control what sheets are to be shown. The parameter value can be a comma-separated list of sheet names (case sensitive) or sheet numbers (1-based counting).

...

sheets
Columns to show
Comma-separated list of column numbers. Defaults to all non-hidden columns in existing order. Columns are enumerated starting at 1. If columns are specified, even hidden columns are shown. Column ordering is not supported (XL-63).

...

columns
Show hidden sheets, rows, and columns
Enable to show hidden elements.

...

showHidden
Show sheet name before the table

...



showSheetName

...

Use cell properties for formatting
Enable to process each cell for special properties. Currently, supported properties are:
  • html - Alignment, font, and background color.
  • wiki - None at this time for individual cells. For columns, formatColumn can be used. Another alternative is to use columnAttributes from Common Table Capabilities.

...

formatCell
Use column information from Excel sheet
Disable to not use the column formatting information from the Excel sheet. By default, the format for a column is used to apply formatting for all cells in the column. Note that this parameter is ignored if formatCell=true or columnAttributes are specified.

...

formatColumn
Show non-formatted

...

version

...

of

...

generated

...

wiki
Enable to show a non-formatted version of the wiki table following the formatted table. This is used to help resolve formatting issues. It can also be used to convert Excel to Confluence markup by cut and paste.

...

showWiki

...

Escape special wiki characters

Include cell hyperlinks


hyperlinks


Note

When you provide all the parameters listed in the editor window for the Excel file, the input provided using URL to Excel file takes precedence.

...

Include Page
info:WIP:_CommonTableCapabilitiesParametersXLCld
info:WIP:_CommonTableCapabilitiesParametersXLCld

inclu

Screenshot

Image Added

Compatibility with other macros

...