Read tables from documents to R

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.

wb <- loadWorkbook …
more ...