Difference between revisions of "FXLData Wizard"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Created page with " '''An Excel ribbon bar tool for building and editing FXLData functions''' =Overview= The FXLData Wizard is part of the FXLData add-in for Excel which provides a coll...")
 
(Overview)
Line 9: Line 9:
 
[[File:FXLData Wizard Ribbon.png|500px]]
 
[[File:FXLData Wizard Ribbon.png|500px]]
  
[[FXLData#Quick_Start|Installing]] the FXLData-add on Excel adds a FXLData menu option and the ƒ''x'' button to the ribbon which launches the Wizard. Select a blank cell in the worksheet and launch the Wizard to create a new FXLData function. Use the Wizard to modify an existing FXLData function by selecting the cell before launching the Wizard.
+
[[FXLData#Quick_Start|Installing]] the FXLData-add on Excel adds a FXLData menu option and the ƒ''x'' button to the ribbon which launches the Wizard.  
 +
* Select a blank cell in the worksheet and launch the Wizard to create a new FXLData function.  
 +
* Use the Wizard to modify an existing FXLData function by selecting the cell before launching the Wizard.
 +
 
 +
=Wizard=

Revision as of 00:34, 5 October 2021

An Excel ribbon bar tool for building and editing FXLData functions

Overview

The FXLData Wizard is part of the FXLData add-in for Excel which provides a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet.

The Wizard helps in the task of building and modifying =FXLData() and =FXLDataV() functions which take a number of parameters including the Fusion Registry to connect to, the Dataflow and a data query expression - typically an SDMX series key.

FXLData Wizard Ribbon.png

Installing the FXLData-add on Excel adds a FXLData menu option and the ƒx button to the ribbon which launches the Wizard.

  • Select a blank cell in the worksheet and launch the Wizard to create a new FXLData function.
  • Use the Wizard to modify an existing FXLData function by selecting the cell before launching the Wizard.

Wizard