Skip to content

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

Options

Options consulted by readxl.

readxl_progress()
Determine whether to show progress spinner