Converting an excel file into an xts format

Convert your Excel file to a data.frame with e.g. openxlsx::read.xlsx
and then use xts::as.xts.data.frame to convert it to an xts object.