The default is false so that the data that has wiki markup can be handled correctly.ĭisable this option to display any hyperlinks in the data as normal text. This option works when a wiki output is requested ( Output format is wiki) as some special characters in data can cause incorrect table formatting. It can also be used to convert Excel to Confluence markup with cut and paste method.Įnable this option to allow these special characters (like ' |', ' ', ' ') to be escaped so that the table format remains unaffected. This is used to help resolve formatting issues. Show non-formatted version of generated wikiĮnable this option to show a non-formatted version of the wiki table following the formatted table. This parameter is ignored if Use cell properties for formatting is enabled or if Column attributes are specified. Valid values are 2 character ISO 3166 codes. Įnter a country specification to use the respective number and date formats for data conversion. Used in combination with the Language for number and date formats parameter.

Valid values are 2 character ISO 639-1 alpha-2 codes. This specification is used before the default languages are automatically used. Since 4.1.0.Įnter a language specification to use the respective number and date formats for data conversion. Refer to this article for more information. If left empty, default Confluence file encoding is used.

The parameter value can be a comma separated list of sheet names (case sensitive) or sheet numbers (1-based counting).Įnter a file encoding for an external file if different from the default encoding.

Note that if a zero is given the connection may wait infinitely.Įnter a comma separated list of sheet names to be shown in the order specified here. By default, each sheet in the workbook produces a table. Use this to increase the access time needed for slow connections. See your administrator for details.Įnter the user name for URL access through basic authentication.Įnter the user password for URL access through basic authentication.Įnter time in milliseconds such that URL connections do not timeout before getting data. Use of this parameter may be restricted for security reasons.

Repository of excel vba examples