Displaying 5 results from an estimated 5 matches for "apkg2vlgfyydgq_mcj8f4caxv_nh".
2017 Aug 30
3
Converting character to numeric using the package "XLConnect"
The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh
[https://r1.res.office365.com/owa/prem/images/dc-xlsx_40.png]<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh>
File.xlsx<https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh>
Partag? via OneDrive
Thanks very much for your help.
Nell
________________________________
De : David Winse...
2017 Aug 31
2
Converting character to numeric using the package "XLConnect"
...1 a
11 2 b
12 3 c
13 4 d
strtoi(nrdf$Value,16)
[1] 10 11 12 13 14 2 8 9 7 10 11 12 13
Jim
On Thu, Aug 31, 2017 at 6:30 AM, Nelly Reduan <nell.redu at hotmail.fr> wrote:
> The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh
[[alternative HTML version deleted]]
2017 Aug 30
0
Converting character to numeric using the package "XLConnect"
> On Aug 30, 2017, at 12:24 PM, Nelly Reduan <nell.redu at hotmail.fr> wrote:
>
> Hello,
>
> From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my
2017 Aug 30
2
Converting character to numeric using the package "XLConnect"
Hello,
>From an Excel file imported into R where each cell contains characters, I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my code (the Excel file is attached):
rm(list=ls(all=TRUE))
library(XLConnect)
tab <-
2017 Aug 30
0
Converting character to numeric using the package "XLConnect"
...1 a
11 2 b
12 3 c
13 4 d
strtoi(nrdf$Value,16)
[1] 10 11 12 13 14 2 8 9 7 10 11 12 13
Jim
On Thu, Aug 31, 2017 at 6:30 AM, Nelly Reduan <nell.redu at hotmail.fr> wrote:
> The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh