Difference between revisions of "Fusion-Excel-Series"
Jump to navigation
Jump to search
(Created page with "Category:SdmxDataFormat =Overview= The Fusion-Excel-Series format is not an official SDMX format. It has a similar layout to the Fusion-CSV-Series format, in that a...") |
|||
| Line 1: | Line 1: | ||
[[Category:SdmxDataFormat]] | [[Category:SdmxDataFormat]] | ||
| + | [[File:Header fixed Tabs.png|thumb|Fusion Excel Series with header section and tabs]] | ||
| + | [[File:Header tabs.png|thumb|Fusion Excel Series with tabs]] | ||
=Overview= | =Overview= | ||
The Fusion-Excel-Series format is not an official SDMX format. It has a similar layout to the [[Fusion-CSV-Series]] format, in that a Series is output per Column. The series can iterate values over time, or any other designated dimension to be at the observation level. | The Fusion-Excel-Series format is not an official SDMX format. It has a similar layout to the [[Fusion-CSV-Series]] format, in that a Series is output per Column. The series can iterate values over time, or any other designated dimension to be at the observation level. | ||
| Line 20: | Line 22: | ||
<strong>Note:</strong> The same formatting can be applied using [[Data_Formats|HTTP Accept Headers]] as opposed to query parameters. | <strong>Note:</strong> The same formatting can be applied using [[Data_Formats|HTTP Accept Headers]] as opposed to query parameters. | ||
| − | |||
| − | |||
| − | |||
Revision as of 03:31, 28 July 2020
Overview
The Fusion-Excel-Series format is not an official SDMX format. It has a similar layout to the Fusion-CSV-Series format, in that a Series is output per Column. The series can iterate values over time, or any other designated dimension to be at the observation level.
The advantages over CSV is that Excel provides a few additional features which are now possible in CSV, these are:
* The ability to slice the data over a Dimension to output a worksheet per Dimension value, e.g slice by FREQ would output Annual Data in one worksheet, Monthly data in another, and so on. * The ability to promote fixed values to a header. Similar to the Fusion_Excel_Data format, reported values which are the same for the whole worksheet can be reported once in a header section * Excel's freeze pane feature is used to make the inner table scrollable while keeping the column and row headers in place * The use of colour to style the output, making the data easier to read
Fusion-Excel-Series is an export format only, supported by Fusion Registry, Fusion Edge Server and Fusion Data Browser.
Formatting Using Query Parameters
The following URL parameters can be used in a RESTful query for to get data in Excel format.
- format=excel-series
Example
Note: The same formatting can be applied using HTTP Accept Headers as opposed to query parameters.
