Read tables from documents to R

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

xls and xlsx

After problems with large worksheets I have turned to using the readxl package.

require(readxl)
sheet_names <- excel_sheets("my_file.xls")
d <- read_excel("my_file.xls", sheet = 1, region = "A3:C7", col_names = TRUE)

docx

Recently …

more ...