Skip to main content

READ_EXCEL (inference)

Deprecated version

This document refers to a deprecated version of the RQL programming language.

Please go here for documentation related to the latest supported version.

Reads an Excel table from a location.

Syntax
READ_EXCEL(location,
sheet := null,
has_header := null,
at := null,
cache := <default interval>,
retries := <default int>,
retry_interval := <default interval>,
http_method := "get",
http_body := null,
http_body_string := null,
http_headers := [],
http_args := [],
http_auth_cred_name := null,
http_token := null,
http_token_url := null,
http_client_id := null,
http_client_secret := null,
http_renew_token_use_basic_auth := false,
http_username := null,
http_password := null)

The optional argument sheet specifies the Excel sheet to use; if set to null, the first sheet will be read. The optional argument has_header specifies whether the data has a header or not, e.g. true or false; if the field is not specified, the inference will try to detect the presence of a header. The optional argument at specifies the beginning and end of the table in Excel coordinates, e.g. "A1:D5"; if the field is not specified, the inference will try to detect the beginning and end of the table.

The optional arguments starting with http, like http_method, define specific http request options; refer to :ref:HTTP Optional Arguments <http_optional_args>.