I recommend reading the posting guide and providing a reproducible example.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Smart Guy <smartguy3k@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

	[[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.


	[[alternative HTML version deleted]]

