SDMX Connector for EXCEL
The Excel Connector for SDMX.
The connector has been built and tested for Excel 2010. In order to use it with different versions of Excel some changes and adaptations are probably required.
The only part of the connector that needs to be built is the Java library. Instructions can be found in the java section
NOTE: building the java library is not strictly necessary. A jar file, ready to be used, can be retrieved from the R project inst/java subdirectory
-
Clone the repository or download a the full project in zip format and unpack it. Get the vba module files from the project EXCEL directory.
-
Import the SDMX module in the worksheet where you want the macro to be available. This can be achieved by importing the getTimeSeries.bas file in the Excel Visual Basic Editor (available in the Excel Developer tab).
-
The getTimeSeries macro should now be available in the worksheet. To complete the configuration you could need to configure the following environment variables:
-
SDMX_LIB the pointer to the SDMX.jar file (not necessary if the jar is already on the system classpath)
-
SDMX_CONF the pointer to the configuration file (not necessary if you want to rely on default configuration)
-
SDMX_JAVA the pointer to the java executable you want to use (not necessary if you have a system configured one)
NOTE: the macro can be made available to users in many different ways. The vba code can even be used to create an excel add-in that, once installed and activated, makes the macro available in every excel worksheet. Anyway these arguments will not be covered by this wiki.
Once the macro is called, it will look for the needed parameters in the active worksheet:
-
cell A1: the name of the provider
-
cell B1: the time series id
-
cell C1: the start time (optional)
-
cell D1: the end time (optional)
