Segmentation fault

[jkeirstead]

I'm trying to load this UK government workbook but get the following error:

df <- read_excel(file, sheet="101")

 *** caught segfault ***
address 0x0, cause 'memory not mapped'

Traceback:
 1: .Call("readxl_xlsx_sheets", PACKAGE = "readxl", path)
 2: xlsx_sheets(path)
 3: match(x, table, nomatch = 0L)
 4: sheet %in% sheet_names
 5: standardise_sheet(sheet, xlsx_sheets(path))
 6: read_xlsx(path, sheet, col_names, col_types, na, skip)
 7: read_excel(file, sheet = "101")

> sessionInfo()
R version 3.1.3 (2015-03-09)
Platform: x86_64-apple-darwin13.4.0 (64-bit)
Running under: OS X 10.10.2 (Yosemite)

locale:
[1] C

attached base packages:
[1] datasets  utils     stats     graphics  grDevices methods   base     

other attached packages:
[1] readxl_0.0.0.9000 jkr_0.1.0         arm_1.7-07        lme4_1.1-7       
[5] Rcpp_0.11.5       Matrix_1.1-5      MASS_7.3-39      

loaded via a namespace (and not attached):
 [1] abind_1.4-3      coda_0.17-1      colorspace_1.2-6 compiler_3.1.3  
 [5] digest_0.6.8     ggplot2_1.0.0    grid_3.1.3       gtable_0.1.2    
 [9] lattice_0.20-30  minqa_1.2.4      munsell_0.4.2    nlme_3.1-120    
[13] nloptr_1.0.4     plyr_1.8.1       proto_0.3-10     randtoolbox_1.16
[17] reshape2_1.4.1   rngWELL_0.10-3   scales_0.2.4     splines_3.1.3   
[21] stringr_0.6.2    tools_3.1.3   

[hadley]

Problem is this file has "rich text runs", e.g.

<si>
  <r><t>2003</t></r>
  <r><rPr><vertAlign val="superscript"/><sz val="10"/><rFont val="Arial"/><family val="2"/></rPr><t xml:space="preserve"> 5</t></r>
</si>

[hadley]

It's a pretty terrible result still, but at least it doesn't crash, and it does preserve all the data

[jkeirstead]

That's definitely better. And it's great that the package strips out stupid ".." placeholders for no data or comma-separated thousands. Thanks!