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.

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.

Example files

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

Get path to readxl example


Options consulted by readxl.

Determine whether to show progress spinner