Skip to content

SDMX Connector for EXCEL

Jump to bottom
Attilio Mattiocco edited this page Jul 8, 2015 · 15 revisions

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.

How to build it

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

How to install it

  1. 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.

  2. 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).

  3. 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)

Clone this wiki locally