CODEWITHSUNDEEP
rexcelexcel-2003
Mary Nastase
Mary Nastase

Reputation: 121

Xl.Read.File function doesn't read all the rows

I have an file saved with Excel Worksheet 2003 and I tried to read in R. No package or function worked, only XL.Read.file from excel.link package. The problem is that the function read only the maximum no from the excel (1048575).

library(excel.link)
df = xl.read.file('Date.xls',header=TRUE,xl.sheet='Date')

Anybody knows where is the problem?

Thank you.

Upvotes: 2

Views: 274

Answers (1)

lumpster
lumpster

Reputation: 1

I know this is old but for anyone looking, try adding the two arguments:

  • top.left.cell = the first cell of your table on the header row
  • xl.sheet = the name of the sheet you want to read
#example 
library(excel.link)
df <- xl.read.file('Date.xls', header=TRUE, xl.sheet='Date', top.left.cell = "A1", xl.sheet = 'sheet name')

Upvotes: 0

Related Questions