Re: [R] Can not read Excel file correctly

2013-10-30 Thread MacQueen, Don
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

Re: [R] Can not read Excel file correctly

2013-10-30 Thread Carl Witthoft
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

[R] Can not read Excel file correctly

2013-10-29 Thread Ron Michael
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