Function reference • readxl

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 cell_limits cell_rows cell_cols anchored: 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