[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