Hi Antony,
Except if you have good reasons to use R2.15, it is generally a good
idea to upgrade to the latest version.
In any case, the solutions that were proposed on the list will
definitely work fine.
There are however advantages of using readxl, in my opinion. readxl does
not use
Hi Ivan,
This way i would've tried but i am using R 2.15 - ReadXL package will
support R =3 versions.
Thanks,
Antony.
--
View this message in context:
http://r.789695.n4.nabble.com/Read-xlsx-and-convert-date-column-value-into-Dataframe-tp4710192p4710232.html
Sent from the R help mailing list
Hi Jim,
My requirement is simple. I have to read date-values from the excel file
into dataframe, that's all.
and i tried using the way you mentioned and it works. Thank you very much !
--
View this message in context:
Hi,
Here i am having a .xlsx file and it contains various columns including
date-column[mm/dd/yy]-but it is not in the date format. I have to read this
excel[.xlsx] file and need to get in dataframe. So i used xlsx-liabrary
and it was fine to read data. But the problem is, values in the date
Hi Antony,
I am not sure it could work easily with package xlsx. Try using the
function read_excel() from package readxl. This function allows for
Dates to be read.
HTH,
Ivan
--
Ivan Calandra, ATER
University of Reims Champagne-Ardenne
GEGENAA - EA 3795
CREA - 2 esplanade Roland Garros
Those numbers are a serial number of days. A value of 1 maps to Jan 1,
1900. ref:
https://support.office.com/en-za/article/DATE-function-e36c0c8c-4104-49da-ab83-82328b832349
A formula such as: as.Date('1900-01-01')+excel_date-1 should convert the
serial value to a date value.
On Wed, Jul 22,
forgot the reply to all:
These are serial dates within EXCEL. Here is a way of converting them:
as.Date(c(42460, 42426), origin = '1899-12-30')
[1] 2016-03-31 2016-02-26
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you
7 matches
Mail list logo