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.