Skip to content

Config file

xlbc.conf is located in same directory as XLbroadcaster .xll file.

Il can be modified with xlbc_set_config() from Excel or directly with any file editor.

{
    "USERKEY": "",
    "USERNAME": "",
    "CACHE_REFRESH": 2.0,
    "MAX_PARALLEL_REQUESTS": 16,
    "REQUEST_URL": "",
    "COL_NAME": 1,
    "USERLOG": true,
    "LOG": false,
    "PROXY_USER": "",
    "PROXY_PWD": "",
    "PROXY_URL": "",
    "PROXY_PORT": "",
    "REQUEST_DURATION_MAX": 60,
    "HTTPS_SECURITYPROTOCAL": "tls, tls11, tls12"
}

CACHE_REFRESH

Delay before requesting again same API (in seconds)

COL_NAME

Change default for col_name argument in request functions

LOG

Turn on/off logging to xlbc.log (same directoty as addin)

REQUEST_DURATION_MAX

Request timeout (in seconds).
Increase it if requested API takes time to answer.

REQUEST_URL

Default prefix for URLs.
For instance if REQUEST_URL is https://api.anothersite.com/v1 then =xlbc_get("/data/") will request https://api.anothersite.com/v1/data/

USERKEY

User license key

USERLOG

If true logfile will be xlbc-.log (same directory as addin)

USERNAME

User email