read_excel() reads a sheet of an .xlsx file into an AnnData() object
with a dense X, as Python's read_excel().
The first column holds the obs names and the first row the var names,
and the name in the corner becomes the obs index name.
It needs the readxl package.
Value
An AnnData() object.
Details
Every other cell must be a number (or empty, which gives NA).
X has the dtype "int64" when the whole sheet holds whole numbers and
"float64" otherwise.
Python gives an object array when the first column is text and ignores
dtype, so R gives doubles whatever the cells hold and also ignores it.
Names are always strings, even with the setting restrict_index_types off
(Python then keeps the type of the labels).
Deviations from Python
Python's object X (text in the first column) has no R form, so X is
numeric, and names are always strings.
See vignette("deviations") for the full list.
Examples
path <- readxl::readxl_example("datasets.xlsx")
# The first column (mpg) becomes the observation names, which repeat here
adata <- suppressWarnings(read_excel(path, sheet = "mtcars"))
adata
#> AnnData object with n_obs × n_vars = 32 × 10
#> layers: None (.X)