This function is designed to take the path to an .iqy file used with Excel. The function can be provided a named list of predifined parameters.
1 |
path |
Character of the path to a Live Excel .iqy file. |
param_list |
A named list with the run time parameters for opening the data source. If not provided, these fields will be prompted for in the console. |
build_only |
If TRUE, the function can be used as a helper app to build the param_list without executing the query. |
convert |
If TRUE, character columns with all digit values, and dates with all fields formatted YYYY-MM-DD will be converted to the appropriate type. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.