Slide 1

Slide 1 text

  @JennyBryan @jennybc Jennifer Bryan 
 RStudio readxl www.rstudio.com

Slide 2

Slide 2 text

http://readxl.tidyverse.org readxl www.rstudio.com

Slide 3

Slide 3 text

http://tidyverse.org

Slide 4

Slide 4 text

http://r4ds.had.co.nz

Slide 5

Slide 5 text

readxl www.rstudio.com

Slide 6

Slide 6 text

2015 April First readxl CRAN release! v0.1.0, written by Hadley Wickham 2016 March v0.1.1 patch release 2017 April v1.0.0, Jenny Bryan is new maintainer lots of bug fixes, some new features

Slide 7

Slide 7 text

## install readxl + other packages install.packages(“tidyverse”) ## install readxl alone install.packages(“readxl”) ## regardless, load readxl like so: library(readxl)

Slide 8

Slide 8 text

readxl, openxlsx, XLConnect, xlsx, gdata, RODBC, excel.link, and more!

Slide 9

Slide 9 text

.xls vs .xlsx self-contained vs. needs Java/Perl data (frame) vs cells & formatting

Slide 10

Slide 10 text

.xls vs .xlsx self-contained vs. needs Java/Perl data (frame) vs cells & formatting readxl www.rstudio.com

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

1. readxl is all about the data rectangle

Slide 13

Slide 13 text

No content

Slide 14

Slide 14 text

2. RStudio IDE has a nice Excel helper

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

3. readxl’s column typing is groovy

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

4. workflows for multiple sheets and files

Slide 19

Slide 19 text

let’s work together in the IDE …

Slide 20

Slide 20 text

1. readxl is all about the data rectangle 2. RStudio IDE has a nice Excel helper 3. readxl’s column typing is groovy 4. workflows for multiple sheets and files

Slide 21

Slide 21 text

http://readxl.tidyverse.org readxl www.rstudio.com