[Rd] newline with cell of Excel worksheet created with write.xls

Mark W Kimpel mwkimpel at gmail.com
Fri Feb 9 08:17:48 CET 2007

As part of my project to put different types of results into worksheets, 
I would like to be able to put an auto-generated methods section. If I 
compose in RWinEdt, read into R, and use write.table with a .txt file 
extension, what I get out has line-breaks that correspond to those I put 
in in the first place.

If I do the same thing but write.xls with .xls extention, I get an Excel 
  worksheet with the entire paragraph on one line (row). It seems to me 
that Excel uses a special character for new-lines (new-rows). Is there a 
way that write.xls could convert \n to this special character?

I'm  writing lots of posts on this, but trying to break up the subjects 
to create better threads.


Mark W. Kimpel MD
Department of Psychiatry
Indiana University School of Medicine

More information about the R-devel mailing list