I do not promise much. But try to use XLConnect package. It requires rJava
package which requires java on your system.

Good luck
Orvalho

On Fri, Feb 8, 2013 at 8:55 PM, Edwin Isensee <edwin.isen...@gmail.com>wrote:

> I'm using the read.xls function from gdata package to read one Excel file,
> like the example below:
>
> library(gdata)
> my_file <- '/Users/Desktop/Project.xlsx'
> valores <- read.xls(my_file)
>
> The problem is: one of the columns at the Excel file holds date information
> like 1-Jan-13, 5-Jan-13, 25-Jan-13. At Excel these information are treated
> as dates. When I read the file into a dataframe the corresponding data
> frame column holds numeric information like 41275, 41279, 41299. How can I
> convert these numeric information into the original date information?
>
> Thanks,
> Edwin
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to