readxl: Read Excel Files
Version 1.0.0

Import excel files into R. Supports '.xls' via the embedded 'libxls' C library and '.xlsx' via the embedded 'RapidXML' C++ library . Works on Windows, Mac and Linux without external dependencies.

Browse man pages Browse package API and functions Browse package files

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
URL http://readxl.tidyverse.org https://github.com/tidyverse/readxl
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("readxl")

Man pages

cell-specification: Specify cells for reading
excel_sheets: List all sheets in an excel spreadsheet.
read_excel: Read xls and xlsx files.
readxl_example: Get path to readxl example
readxl-package: readxl: Read Excel Files

Functions

anchored Man page
cell-specification Man page
cell_cols Man page
cell_limits Man page
cell_rows Man page
check_bool Source code
check_col_types Source code
check_file Source code
check_guess_max Source code
check_non_negative_integer Source code
excel_format Source code
excel_sheets Man page Source code
isFALSE Source code
is_absolute_path Source code
is_integerish Source code
parse_ref Source code
read_excel Man page Source code
read_excel_ Source code
read_xls Man page Source code
read_xls_ Source code
read_xlsx Man page Source code
read_xlsx_ Source code
readxl Man page
readxl-package Man page
readxl_example Man page Source code
standardise_limits Source code
standardise_sheet Source code
xls_date_formats Source code
xls_sheets Source code
xlsx_date_formats Source code
xlsx_sheets Source code
xlsx_strings Source code
zip_buffer Source code
zip_has_file Source code
zip_xml Source code

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
readxl documentation built on May 19, 2017, 12:59 p.m.