Read spreadsheets

Functions for reading tabular data out of xls and xlsx files.

read_excel() read_xls() read_xlsx()

Read xls and xlsx files

Get spreadsheet metadata

Functions to learn properties of xls and xlsx files.

excel_sheets()

List all sheets in an excel spreadsheet

excel_format() format_from_ext() format_from_signature()

Determine file format

Describe a target rectangle

Flexible specification of cell rectangles.

cell-specification

Specify cells for reading

Example files

List or get the path to xls and xlsx example files in the package.

readxl_example()

Get path to readxl example