Similar problem as in #619, "read_excel cannot able to read xls(MS excel 5.0/95 Workbook)"

[wanttobenatural]

Hello all,

I am really learner in this R, Python area and faced similar problem described in #619

I tried to make a reprex but it showed me as below so did not understand 'path' does not exist while I can see the result in my trial so I copied both cases.

So this problematic file can be read only if I saved it as .xlsx. I can do with this way as a workaround but I want to use original file so that my code can be automatic and work within my code without effort outside like saving as .xlsx.

--reprex trial--
library(readxl)
read_excel("tibble0x0.xls")
#> Error: path does not exist: 'tibble0x0.xls'
read_excel("tibble0x0_xlsx.xlsx")
#> Error: path does not exist: 'tibble0x0_xlsx.xlsx'

--my trial--

library(readxl)
read_excel("tibble0x0.xls")

A tibble: 0 x 0

read_excel("tibble0x0_xlsx.xlsx")

A tibble: 2,159 x 32

tibble0x0_xlsx.xlsx

Tdoc Title Source Contact Contact ID Type Type supplemen~ For Abstract Secretary Rema~ `Agenda item so~

1 R2-1~ Agen~ Chair~ Richar~ 14160 agen~ NA Appr~ NA NA NA
2 R2-1~ RAN2~ ETSI Juha K~ 21609 repo~ NA Appr~ NA NA NA
3 R2-1~ LS o~ CT1 Jaehyu~ 44912 LS in NA Acti~ NA NA NA
4 R2-1~ LS o~ CT1 Lena C~ 38080 LS in NA Info~ NA NA NA
5 R2-1~ Repl~ CT1 Mikael~ 40034 LS in NA Info~ NA NA NA
6 R2-1~ Repl~ CT1 Chen-h~ 57105 LS in NA Info~ NA NA NA
7 R2-1~ Repl~ CT1 Jennif~ 43418 LS in NA Acti~ NA NA NA
8 R2-1~ LS o~ CT1 Chen-h~ 57105 LS in NA Acti~ Offline~ NA NA
9 R2-1~ Resp~ RAN1 Albert~ 63913 LS in NA Acti~ NA NA NA
10 R2-1~ LS o~ RAN1 Alexey~ 46112 LS in NA Acti~ NA NA NA

... with 2,149 more rows, and 21 more variables: Agenda item , Agenda item description , `TDoc sort

order within agenda item<dbl>,TDoc Status<chr>,Reservation date<dttm>, Uploaded <dttm>,Is revision

of<chr>,Revised to<chr>, Rel <chr>, Specification <chr>, Version <chr>,Related WIs<chr>, CR <chr>,CR

revision<chr>,CR category<chr>,TSG CR Pack<lgl>,Reply to<chr>, LS_To <chr>, LS_Cc <chr>,Original

LS<chr>,Reply in`

tibble0x0_xlsx.xlsx

Test.zip

[jennybc]

As expected, now I've pulled in the most recent libxls, this now works 🎉
Note that this currently applies only to the dev version of readxl.

library(readxl)

data <- read_xls("investigations/Test/tibble0x0.xls")
data
#> # A tibble: 2,159 x 32
#>    Tdoc  Title Source Contact `Contact ID` Type  `Type supplemen… For   Abstract
#>    <chr> <chr> <chr>  <chr>          <dbl> <chr> <lgl>            <chr> <chr>   
#>  1 R2-1… Agen… Chair… Richar…        14160 agen… NA               Appr… <NA>    
#>  2 R2-1… RAN2… ETSI   Juha K…        21609 repo… NA               Appr… <NA>    
#>  3 R2-1… LS o… CT1    Jaehyu…        44912 LS in NA               Acti… <NA>    
#>  4 R2-1… LS o… CT1    Lena C…        38080 LS in NA               Info… <NA>    
#>  5 R2-1… Repl… CT1    Mikael…        40034 LS in NA               Info… <NA>    
#>  6 R2-1… Repl… CT1    Chen-h…        57105 LS in NA               Info… <NA>    
#>  7 R2-1… Repl… CT1    Jennif…        43418 LS in NA               Acti… <NA>    
#>  8 R2-1… LS o… CT1    Chen-h…        57105 LS in NA               Acti… Offline…
#>  9 R2-1… Resp… RAN1   Albert…        63913 LS in NA               Acti… <NA>    
#> 10 R2-1… LS o… RAN1   Alexey…        46112 LS in NA               Acti… <NA>    
#> # … with 2,149 more rows, and 23 more variables: Secretary Remarks <lgl>,
#> #   Agenda item sort order <lgl>, Agenda item <chr>,
#> #   Agenda item description <chr>, TDoc sort order within agenda item <dbl>,
#> #   TDoc Status <chr>, Reservation date <dttm>, Uploaded <dttm>,
#> #   Is revision of <chr>, Revised to <chr>, Rel <chr>, Specification <chr>,
#> #   Version <chr>, Related WIs <chr>, CR <chr>, CR revision <chr>,
#> #   CR category <chr>, TSG CR Pack <lgl>, Reply to <chr>, LS_To <chr>,
#> #   LS_Cc <chr>, Original LS <chr>, Reply in <lgl>

^{Created on 2021-07-29 by the reprex package (v2.0.0.9000)}