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 <smartgu...@gmail.com> 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]] ______________________________________________ R-help@r-project.org 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.