Skip to content

Eurostat Data for Calc 1.0.0

Choose a tag to compare

View all tags
@davidjayjackson davidjayjackson released this 08 Jul 22:24
v1.0.0
2f5e4b9

LibreOffice Calc add-in that adds a EUROSTATDATA() spreadsheet function for pulling data
straight from the Eurostat REST API (JSON-stat 2.0) into a
sheet.

=EUROSTATDATA("nama_10_gdp"; "geo=DE;time=2023;unit=CP_MEUR")

returns a table that spills into the sheet: a header row (one column per dimension, plus
value), followed by one row per observation. Errors show as a readable #ERROR: ... cell
instead of Err:5xx.

Install

Download EurostatAddin-1.0.0.oxt below, then either double-click it to open the Extension
Manager, or:

/path/to/libreoffice/program/unopkg add EurostatAddin-1.0.0.oxt

Try it

Eurostat-Demo.ods (also attached) has several EUROSTATDATA(...) formulas already entered
and computed against live data — open it after installing the add-in to see it working.

Notes

  • Pure Java 8, zero external dependencies (hand-rolled JSON parser, HttpURLConnection) — built
    entirely with the LibreOffice SDK's own toolchain, no Maven required. See build.sh to build
    from source.
  • Registers via CalcAddIns.xcu, the same mechanism LibreOffice's own extension ecosystem uses.
Assets 4
Loading