Marcin Kalicinski

Marcin Kalicinski

4 packages on CRAN

readxl

cran
99.5th

Percentile

Import excel files into R. Supports '.xls' via the embedded 'libxls' C library <https://github.com/evanmiller/libxls> and '.xlsx' via the embedded 'RapidXML' C++ library <http://rapidxml.sourceforge.net>. Works on Windows, Mac and Linux without external dependencies.

osmdata

cran
94th

Percentile

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

tidyxl

cran
69th

Percentile

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

rplexos

cran
15th

Percentile

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