Difference between revisions of "FXLData Refreshable Worksheet"
(Created page with "Category:SdmxDataFormat =Overview= thumb|Refreshable Excel Worksheet The FXLData Refreshable Worksheet is an Excel file which, when open...") |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| 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]] | ||
| − | 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 | + | 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 request. |
This data format requires the [[FXLData]] plugin for Microsoft Excel to be installed. | This data format requires the [[FXLData]] plugin for Microsoft Excel to be installed. | ||
| Line 10: | Line 11: | ||
format=excel-refresh | format=excel-refresh | ||
| − | Example: https://demo.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/BIS/WS_SPP/1.0/?c%5BREF_AREA%5D=5R | + | Example: https://demo.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/BIS/WS_SPP/1.0/?c%5BREF_AREA%5D=5R&format=excel-refresh&labels=both |
| + | |||
| + | 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. | ||
| + | |||
| + | As of FXLData R1.3, refreshable workbooks no longer render automatically upon opening. This change is part of a performance optimization that deliberately inhibits FXLData functions from executing on initial load. To view data, users must now manually initiate a refresh sequence by first clicking Refresh, followed by Refresh Workbook. This ensures that large or complex queries do not slow down workbook opening, while still allowing users to retrieve up-to-date data on demand. | ||
Latest revision as of 06:55, 29 July 2025
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 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.
As of FXLData R1.3, refreshable workbooks no longer render automatically upon opening. This change is part of a performance optimization that deliberately inhibits FXLData functions from executing on initial load. To view data, users must now manually initiate a refresh sequence by first clicking Refresh, followed by Refresh Workbook. This ensures that large or complex queries do not slow down workbook opening, while still allowing users to retrieve up-to-date data on demand.
