[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

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



More information about the R-devel mailing list