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