1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
## ----include = FALSE----------------------------------------------------------
knitr::opts_chunk$set(
collapse = TRUE,
comment = "#>"
)
options(tibble.print_min = 4, tibble.print_max = 4)
## ----setup--------------------------------------------------------------------
library(readxl)
## ----eval = FALSE-------------------------------------------------------------
# read_excel("yo.xlsx", skip = 5)
# read_excel("yo.xlsx", n_max = 100)
# read_excel("yo.xlsx", skip = 5, n_max = 100)
# read_excel("yo.xlsx", range = "C1:E7")
# read_excel("yo.xlsx", range = cell_rows(6:23))
# read_excel("yo.xlsx", range = cell_cols("B:D"))
# read_excel("yo.xlsx", range = anchored("C4", dim = c(3, 2)))
## ----out.width = '70%', echo = FALSE------------------------------------------
knitr::include_graphics("img/geometry.png")
## -----------------------------------------------------------------------------
read_excel(readxl_example("geometry.xlsx"))
## -----------------------------------------------------------------------------
read_excel(readxl_example("geometry.xlsx"), skip = 1)
## -----------------------------------------------------------------------------
read_excel(readxl_example("geometry.xlsx"), skip = 3)
## -----------------------------------------------------------------------------
read_excel(readxl_example("geometry.xlsx"), n_max = 2)
## -----------------------------------------------------------------------------
read_excel(readxl_example("geometry.xlsx"), n_max = 1000)
## -----------------------------------------------------------------------------
read_excel(readxl_example("deaths.xlsx"), range = "arts!A5:F15")
## ----out.width = '70%', echo = FALSE------------------------------------------
knitr::include_graphics("img/geometry.png")
## -----------------------------------------------------------------------------
read_excel(readxl_example("geometry.xlsx"), range = "A2:C4")
## ----eval = FALSE-------------------------------------------------------------
# ## rows only
# read_excel(..., range = cell_rows(1:10))
# ## is equivalent to
# read_excel(..., range = cell_rows(c(1, 10)))
#
# ## columns only
# read_excel(..., range = cell_cols(1:26))
# ## is equivalent to all of these
# read_excel(..., range = cell_cols(c(1, 26)))
# read_excel(..., range = cell_cols("A:Z"))
# read_excel(..., range = cell_cols(LETTERS))
# read_excel(..., range = cell_cols(c("A", "Z"))
## -----------------------------------------------------------------------------
read_excel(readxl_example("geometry.xlsx"), range = cell_rows(4:8))
## -----------------------------------------------------------------------------
read_excel(
readxl_example("geometry.xlsx"),
col_names = paste("var", 1:4, sep = "_"),
range = anchored("C5", c(3, 4))
)
## -----------------------------------------------------------------------------
read_excel(
readxl_example("geometry.xlsx"),
col_names = FALSE,
range = cell_limits(c(5, 3), c(NA, NA))
)
|
