Search code examples
rexcelreadxl

readxl does not import all rows of the excel file

When importig my excel file (159,156 rows, 25 columns) it imports as a smaller file.

library(readxl) 
All_wp <- read_excel("~/path/file.xls")

generates a file with 65535 obs (rows) and 25 variables.

Why is this? is there a limit for file rowns on readxl? If so, what other package can I use to import bigger excel documents?

Solution

  • Copying the table and running

    my_data <- read.table(pipe("pbpaste"), sep="\t", header = TRUE)

    works!

    Still, not sure if there is a row limit on readxl for importing excel files?