Package index • unexcel

Reading the workbook

The recommended path. Everything here is read from the ‘.xlsx’ file, so nothing is inferred.

unexcel_xlsx(): Read an .xlsx sheet and undo its date auto-conversion
excel_date_system(): Read the date system a workbook declares
excel_date_cells(): Find the cells a workbook formats as dates
excel_date_columns(): Summarise date-formatted cells by column
excel_sheets(): List the sheets in a workbook

The conversion

Exact, given a date system and a field order.

serial_to_day_month(): Convert Excel date serials to day.month values
excel_origin(): The origin date behind each Excel date system

Working from imported values

For when the workbook is gone and guardrails have to stand in for it.

restore_day_month(): Revert Excel date serials in an already-imported vector
fix_serial_columns(): Revert Excel date serials across a data frame