readxl: Read Excel Files

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

Install the latest version of this package by entering the following in R:
install.packages("readxl")
AuthorHadley Wickham [aut], Jennifer Bryan [aut, cre], RStudio [cph] (Copyright holder of all R code and all C/C++ code without explicit copyright attribution), Marcin Kalicinski [ctb, cph] (Author of included RapidXML code), Komarov Valery [ctb, cph] (Author of included libxls code), Christophe Leitienne [ctb, cph] (Author of included libxls code), Bob Colbert [ctb, cph] (Author of included libxls code), David Hoerl [ctb, cph] (Author of included libxls code)
Date of publication2017-04-18 07:21:33 UTC
MaintainerJennifer Bryan <jenny@rstudio.com>
LicenseGPL-3
Version1.0.0
http://readxl.tidyverse.org
https://github.com/tidyverse/readxl

View on CRAN

Files

inst
inst/extdata
inst/extdata/deaths.xls
inst/extdata/type-me.xls
inst/extdata/datasets.xls
inst/extdata/deaths.xlsx
inst/extdata/datasets.xlsx
inst/extdata/clippy.xlsx
inst/extdata/clippy.xls
inst/extdata/geometry.xlsx
inst/extdata/type-me.xlsx
inst/extdata/geometry.xls
inst/doc
inst/doc/sheet-geometry.Rmd
inst/doc/cell-and-column-types.html
inst/doc/sheet-geometry.R
inst/doc/sheet-geometry.html
inst/doc/cell-and-column-types.R
inst/doc/cell-and-column-types.Rmd
tests
tests/testthat.R
tests/testthat
tests/testthat/test-encoding.R tests/testthat/test-shared-string-table.R tests/testthat/test-read-excel.R tests/testthat/test-dates.R tests/testthat/test-empty.R tests/testthat/test-missing-values.R tests/testthat/test-sheets.R tests/testthat/test-xml-namespaces.R tests/testthat/test-skipping.R tests/testthat/test-col-types.R
tests/testthat/sheets
tests/testthat/sheets/dates-1900.xls
tests/testthat/sheets/utf8-sheet-names.xls
tests/testthat/sheets/inlineStr.xlsx
tests/testthat/sheets/whitespace-xlsx.xlsx
tests/testthat/sheets/datetime-rounding.xlsx
tests/testthat/sheets/no-yes-col-names.xlsx
tests/testthat/sheets/whitespace-xls.xls
tests/testthat/sheets/dates-leap-year-1900-xlsx.xlsx
tests/testthat/sheets/skipping.xls
tests/testthat/sheets/empty-named-column.xls
tests/testthat/sheets/new_line_errors.xlsx
tests/testthat/sheets/Ekaterinburg_IP_9.xlsx
tests/testthat/sheets/no-yes-col-names.xls
tests/testthat/sheets/mtcars.xls
tests/testthat/sheets/datetime-rounding.xls
tests/testthat/sheets/inlineStr2.xlsx
tests/testthat/sheets/empty-named-column.xlsx
tests/testthat/sheets/types.xls
tests/testthat/sheets/dates-1904.xls
tests/testthat/sheets/dates-1900-LibreOffice.xlsx
tests/testthat/sheets/missing-values.xlsx
tests/testthat/sheets/missing-first-column.xlsx
tests/testthat/sheets/more-than-256-unique-strings-xls.xls
tests/testthat/sheets/skipping.xlsx
tests/testthat/sheets/list_type.xlsx
tests/testthat/sheets/iris-excel.xls
tests/testthat/sheets/vietnamese-utf8.xls
tests/testthat/sheets/geometry.xlsx
tests/testthat/sheets/style-only-cells.xls
tests/testthat/sheets/empty-sheets.xls
tests/testthat/sheets/unnamed-duplicated-columns.xls
tests/testthat/sheets/missing-first-column.xls
tests/testthat/sheets/utf8-sheet-names.xlsx
tests/testthat/sheets/iris-google-doc.xlsx
tests/testthat/sheets/blanks.xls
tests/testthat/sheets/sheet-xml-lookup.xlsx
tests/testthat/sheets/style-only-cells.xlsx
tests/testthat/sheets/richtext-coloured.xlsx
tests/testthat/sheets/iris-excel.xlsx
tests/testthat/sheets/empty-sheets.xlsx
tests/testthat/sheets/blanks.xlsx
tests/testthat/sheets/embedded-chartsheet.xlsx
tests/testthat/sheets/list_type.xls
tests/testthat/sheets/geometry.xls
tests/testthat/sheets/vietnamese-utf8.xlsx
tests/testthat/sheets/types.xlsx
tests/testthat/sheets/unnamed-duplicated-columns.xlsx
tests/testthat/sheets/nonstandard-xml-ns-prefix.xlsx
tests/testthat/sheets/dates-leap-year-1900-xls.xls
tests/testthat/sheets/missing-values.xls
tests/testthat/sheets/biff5-label-records.xls
tests/testthat/test-trim-ws.R tests/testthat/test-compatibility.R tests/testthat/test-n-max.R tests/testthat/test-return.R tests/testthat/helper.R tests/testthat/test-geometry.R tests/testthat/test-richtext.R tests/testthat/test-col-names.R tests/testthat/test-problems.R
tests/BIFF5-LABEL-record-string-read-mac-10-11.supp
src
src/zip.cpp
src/Makevars
src/ole.c
src/rapidxml_print.h
src/XlsxWorkSheet.cpp
src/cran.h
src/XlsxCell.h
src/XlsWorkBook.h
src/XlsWorkBook.cpp
src/XlsWorkSheet.cpp
src/ColSpec.h
src/XlsxWorkBook.h
src/libxls
src/libxls/brdb.h
src/libxls/xlsstruct.h
src/libxls/endian.h
src/libxls/xls.h
src/libxls/brdb.c.h
src/libxls/ole.h
src/libxls/xlstypes.h
src/libxls/xlstool.h
src/StringSet.h
src/windows
src/windows/config.h
src/CellLimits.h
src/rapidxml.h
src/XlsxWorkSheet.h
src/utils.h
src/XlsCell.h
src/unix
src/unix/config.h
src/zip.h
src/xlstool.c
src/endian.c
src/Makevars.win
src/init.c
src/RcppExports.cpp
src/XlsWorkSheet.h
src/xls.c
src/XlsxWorkBook.cpp
src/XlsxString.h
NAMESPACE
NEWS.md
R
R/xlsx-zip.R R/utils.R R/readxl.R R/example.R R/read_excel.R R/RcppExports.R R/excel-sheets.R R/cell-specification.R
vignettes
vignettes/sheet-geometry.Rmd
vignettes/type-me-logical.png
vignettes/type-me-numeric.png
vignettes/type-me-date.png
vignettes/type-me-text.png
vignettes/geometry.png
vignettes/cell-and-column-types.Rmd
README.md
MD5
build
build/vignette.rds
DESCRIPTION
LICENSE.note
man
man/read_excel.Rd man/cell-specification.Rd man/readxl_example.Rd man/excel_sheets.Rd man/readxl-package.Rd
tools
tools/logo.png

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.