Re: [R] output my results into Excel

alue, not a data frame. However, I am not > sure. Any advice? > > > Thanks for your help. > > > Mike > > > -- > *From:* Dalthorp, Daniel > *Sent:* Wednesday, March 2, 2016 3:50 PM > *To:* Michael > *Cc:* r-help@r-project.org > *Sub

Re: [R] output my results into Excel

Hi Michael, If you are working in Windows: # You can put the matrix directly into the clipboard write.table(PRdist, file = 'clipboard', sep = '\t', row.names = F, col.names = F) The "sep" argument tells what character to use for separating columns. Default for Excel is tab (i.e. '\t') Default fo

Re: [R] output my results into Excel

Hi Michael, Googling "export R data to Excel" gives LOTS of advice, including packages that can write your data directly to Excel spreadsheets. I don't use Excel, so I haven't tried any of those, but using write.csv() to export your data will create something that my colleagues who use Excel have

[R] output my results into Excel

I can get R to calculate the distance that I want between my data points. However, I am stuck trying to get R to output the data so I can paste it into Excel. Instead, R outputs a matrix mess in the console. Below are the steps I am taking to calculate the distance between my data. Also, I h