Displaying 3 results from an estimated 3 matches for "style_action".
2017 Aug 30
2
Converting character to numeric using the package "XLConnect"
...d=TRUE)
if(length(index)!=0){
set[index] <- unlist(lapply(set[index], function(x) as.numeric(as.character(x))))
}
## to check
set[10,1] ## Problem: must be numeric !!!!
writeWorksheetToFile("C:/Users/Downloads/Test.xlsx", data=set, sheet="settings", styleAction = XLC$"STYLE_ACTION.NONE")
How can I convert the numbers which are stored as characters to numeric?
Thanks so much for your time.
Have a nice day
Nell
2017 Aug 30
0
Converting character to numeric using the package "XLConnect"
...> set[index] <- unlist(lapply(set[index], function(x) as.numeric(as.character(x))))
> }
> ## to check
> set[10,1] ## Problem: must be numeric !!!!
>
> writeWorksheetToFile("C:/Users/Downloads/Test.xlsx", data=set, sheet="settings", styleAction = XLC$"STYLE_ACTION.NONE")
>
> How can I convert the numbers which are stored as characters to numeric?
Have you tried using the formatting features of Excel to change the default "auto" sttings of black columns? You could select an entire column and set its format to numeric. I know this someti...
2017 Aug 30
3
Converting character to numeric using the package "XLConnect"
...gt; if(length(index)!=0){
> set[index] <- unlist(lapply(set[index], function(x) as.numeric(as.character(x))))
> }
> ## to check
[[elided Hotmail spam]]
>
> writeWorksheetToFile("C:/Users/Downloads/Test.xlsx", data=set, sheet="settings", styleAction = XLC$"STYLE_ACTION.NONE")
>
> How can I convert the numbers which are stored as characters to numeric?
Have you tried using the formatting features of Excel to change the default "auto" sttings of black columns? You could select an entire column and set its format to numeric. I know this sometim...