Read tables from documents to R

Date Geändert

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, range = "A3:C7", col_names = TRUE)

docx

Recently …

mehr ...