Re: [R] Problem in writing a R data frame to Excel format using RODBC package

2011-08-29 Thread Duncan Murdoch
On 29/08/2011 8:54 AM, Smart Guy wrote: Hi All, Here is the short description of my problem. >mydata ###my data.frame age height weight 12 97 30 14 95 32 17 12050 I used a following method from RODBC package. ver 1.3.1, to save as excel file.

Re: [R] Problem in writing a R data frame to Excel format using RODBC package

2011-08-29 Thread Smart Guy
Hi All, Here is the short description of my problem. >mydata ###my data.frame age height weight 12 97 30 14 95 32 17 12050 I used a following method from RODBC package. ver 1.3.1, to save as excel file. sqlSave(channel,* mydata*, tablename="Shee

Re: [R] Problem in writing a R data frame to Excel format using RODBC package

2011-08-29 Thread Jeff Newmiller
I recommend reading the posting guide and providing a reproducible example. --- Jeff Newmiller The . . Go Live... DCN: Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.

[R] Problem in writing a R data frame to Excel format using RODBC package

2011-08-29 Thread Smart Guy
Hi Experts, I was trying to write a data frame which has a header row, from R to Excel disk file using RODBC ( RODBC_1.3-1) package. I met with an issue:- If in sqlSave(), I set a parameter "colnames=FALSE" then I get first row as header in excel file. If 'colnames=TRUE' then it giv