5 packages on CRAN
Download and import of 'OpenStreetMap' ('OSM') data as 'sf' or 'sp' objects. 'OSM' data are extracted from the 'Overpass' web server and processed with very fast 'C++' routines for return to 'R'.
Read Statistical Data and Metadata Exchange (SDMX) XML data. This the main transmission format used in official statistics. Data can be imported from local SDMX-ML files or a SDMX web-service and will be read in 'as is' into a dataframe object. The 'RapidXML' C++ library <http://rapidxml.sourceforge.net> is used to parse the XML data.
Import excel files into R. Supports '.xls' via the embedded 'libxls' C library <https://github.com/libxls/libxls> and '.xlsx' via the embedded 'RapidXML' C++ library <http://rapidxml.sourceforge.net>. Works on Windows, Mac and Linux without external dependencies.
Efficiently read and analyze 'PLEXOS' solutions by converting them into 'SQLite' databases that can be easily queried. It supports collation of solutions that may have been divided into different time partitions, as well as the comparison across different scenarios. 'PLEXOS' is a power systems production cost model, created and distributed by Energy Exemplar (see <http://energyexemplar.com/software/plexos-desktop-edition> for more information).
Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Tokenizes Excel formulas. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library <http://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.