newline with cell of Excel worksheet created with write.xls
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