Hi All,
Here is the short description of my problem.
>mydata ###my data.frame
age height weight
12 97 30
14 95 32
17 120 50
I used a following method from RODBC package. ver 1.3.1, to save as excel
file.
sqlSave(channel,* mydata*, tablename="Sheet1", *colnames = TRUE*)
I got two header rows in Excel file:-
age height weight
age height weight
12 97 30
14 95 32
17 120 50
I need one row if parameter *colnames = TRUE* and no header rows if *
colnames=FALSE*. And actually it should work like this.
If any one came across same issue, kindly help me.
-Thanks
SmartG
On 29 August 2011 16:14, Smart Guy <[email protected]> wrote:
> 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 gives me first
> 2 rows as header in excel file.
> Actually, according to my understanding, for FALSE it should
> not write header row to Excel file and for TRUE it should write a single
> header row to Excel.
> Data is ok. Problem is with header row.
>
> sqlSave() is in RODBC package.
>
> Kindly, suggest something. I need an option so that whenever I want I can
> save header to excel file or else drop the header and can only save data to
> Excel.
>
> Thanks and Regards
> SmartG
>
--
SmartG
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
