This is a short note about reading tables from common office document formats into R.

xls and xlsx

I have had good success with the XLConnect package, both with the old xls format and the XML based xlsx format. The key function for me is readWorksheet.

require(XLConnect)
wb <- loadWorkbook …

Upon finishing some projects, I found the time to update this web server (from Debian wheezy to Debian jessie) and to give the web site a new design.

And after the start of the new year, the translation of the site to German is completed as well.

With great pleasure I am introducing my new company in this little weblog posting. The company is simply called “Johannes Ranke, wissenschaftlicher Berater”. This means I am running a one-man scientific consulting company. Continuing from my activities at the University of Bremen, at Harlan Laboratories and most recently at Eurofins …