Displaying 5 results from an estimated 5 matches for "writeworksheettofil".
Did you mean:
writeworksheettofile
2017 Aug 30
2
Converting character to numeric using the package "XLConnect"
...t;- readWorksheet(tab, sheet = "settings", colTypes="numeric")
index <- which((!is.na(setNum)), arr.ind=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
2012 Sep 18
0
Appending many different and separate Excel files using R
Hello,
This is the sort of question that could interess others, so you should
have CCed it to the list.
As for the question, from the package vignette, section 3.3.6:
"writeWorksheetToFile() is a wrapper function, calling loadWorkbook(),
createSheet() and saveWorkbook()
functions subsequently. It therefore allows for writing data into
worksheets of an Excel file in one call."
To see it, run
vignette('XLConnect', 'XLConnect')
Since it seems that you don't...
2017 Aug 30
0
Converting character to numeric using the package "XLConnect"
...a .txt attachment or embedded in an email.
> index <- which((!is.na(setNum)), arr.ind=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?
Have you tried using the formatting features of Excel to change the default "au...
2017 Aug 30
3
Converting character to numeric using the package "XLConnect"
...ut(setNum)
.. either as a .txt attachment or embedded in an email.
> index <- which((!is.na(setNum)), arr.ind=TRUE)
> 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 "aut...
2012 Aug 17
4
Appending many different and separate Excel files using R
Dear all,
Good day!
I have a problem in reading Excel files in R and appending them to each other. Suppose we have several Excel files in a directory with headers and want to use R to append them in a single file with an additional variable in the final file indicating from which files the data come from.
As I have many Excel files and their sizes are very big I should write a loop in R to do