I can't help you with cell A1, but I can make a guess at your date format
issue. To start, I would suggest you read thoroughly the XLConnect
documentation for how it handles dates (and probably also ?Date in R).
In both Excel and R, dates are stored internally as a number, and then
displayed with
Dunno how to break this to you, but R reads exactly what is in that file,
with the data in exactly the proper row/column locations.
--
View this message in context:
http://r.789695.n4.nabble.com/Can-not-read-Excel-file-correctly-tp4679306p4679350.html
Sent from the R help mailing list archive
Hi,
I need to read an Excel file which can be available in following link:
http://www45.zippyshare.com/v/43626889/file.html
Now I wanted to read the 1st sheet of this Excel file. Below are my code so far
(I saved that file in 'F:' drive):
> library(XLConnect)
Loading required package: rJava
XLC
3 matches
Mail list logo