[R] Directly copying data from RStudio to MS Excel

[Erich Subscriptions]

Read
https://www.johndcook.com/blog/r_excel_clipboard/


> On 06.06.2021, at 22:28, Ahmad Raza <clinical0910 using gmail.com> wrote:
> 
> Dear Experts,
> I am trying to copy data tables from RStudio to MS Excel. In Macbook, its
> working effortlessly. I can just press CMD+A, copy and directly paste onto
> excel sheet. All text, table and format are preserved. However, its not
> working on Windows 10 MS Office 365 Excel.
> First, simple paste option doesn't paste anything. If I try to do paste
> special --> text/html, it pasts all data in a single long column. I don't
> remember what I did differently on Mac that it worked there. I am looking
> for your wise words on this issue please.
> Thanks.
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.