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]]
No idea. a) This mailing list is about the R Language, not the RStudio editor. b) I find that the power of R lies in the ability to give it a script of commands and have to loop through many tasks. Copying and pasting is a manual intervention that prevents bulk calculations in most cases. c) You may want to generate a csv output file that you can open in Excel. You can also generate docx or html files with the rmarkdown package. On June 6, 2021 1:28:14 PM PDT, Ahmad Raza <clinical0910 at 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 at 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.-- Sent from my phone. Please excuse my brevity.
Erich Subscriptions
2021-Jun-07 08:43 UTC
[R] Directly copying data from RStudio to MS Excel
Read https://www.johndcook.com/blog/r_excel_clipboard/> On 06.06.2021, at 22:28, Ahmad Raza <clinical0910 at 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 at 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.