Difference between revisions of "Quick Start Guide - FXLData"

From Fusion Registry Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
[[Category:Getting Started FXLData]]
 
[[Category:Getting Started FXLData]]
 
# Download the latest version and unzip the add-in which is a single file: FXLData.xlam
 
# Download the latest version and unzip the add-in which is a single file: FXLData.xlam
# [[Downlad_and_Installation_FXLData_-_Draft|Install]] the add in
+
# [[Downlad_and_Installation_FXLData|Install]] the add in
 
# Open a blank Excel worksheet
 
# Open a blank Excel worksheet
 
# Paste the following formula into a cell
 
# Paste the following formula into a cell
Line 9: Line 9:
 
The [[FXLData Wizard]] provides tools to help with the task of building FXLData formulas.
 
The [[FXLData Wizard]] provides tools to help with the task of building FXLData formulas.
  
[[File:FXLData Wizard Ribbon 058.JPG|FXLData Excel ribbon|200px]]
+
[[File:FXLData Wizard Ribbon 058.JPG|FXLData Excel ribbon|400px]]

Latest revision as of 04:49, 24 July 2024

  1. Download the latest version and unzip the add-in which is a single file: FXLData.xlam
  2. Install the add in
  3. Open a blank Excel worksheet
  4. Paste the following formula into a cell
=FXLDataV("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY","A")

A sample 100 series of annual data will be retrieved from Metadata Technology's public demonstration Fusion Registry service and inserted directly into the sheet.

The FXLData Wizard provides tools to help with the task of building FXLData formulas.

FXLData Excel ribbon