Difference between revisions of "FXLData Refreshable Worksheet"
Jump to navigation
Jump to search
(→Overview) |
|||
| Line 1: | Line 1: | ||
[[Category:SdmxDataFormat]] | [[Category:SdmxDataFormat]] | ||
| + | [[Category:How to and other features in FXLData]] | ||
=Overview= | =Overview= | ||
[[File:Refreshable worksheet.png|thumb|Refreshable Excel Worksheet]] | [[File:Refreshable worksheet.png|thumb|Refreshable Excel Worksheet]] | ||
Latest revision as of 02:22, 22 July 2024
Overview
The FXLData Refreshable Worksheet is an Excel file which, when opened, loads the data from the web service. The data is not saved in the worksheet, instead it saves the data query and executes it on demand. This enables the data to be dynamically refreshed on open, and on request.
This data format requires the FXLData plugin for Microsoft Excel to be installed.
To export a dataset in this format, simply create an SDMX Data Query and add the Query Parameer:
format=excel-refresh
The underlying format passed from server to client is Fusion-CSV-TS, and as such any parameters available to Fusion-CSV-TS are available in this format.
