Directly copying data from RStudio to MS Excel

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.

Cross-posted to R-help list

I do not have Excel as I am on Linux but I suspect you would be better off just writing the data frame to Excel.

See something like Using readxl and writexl to Read and Write Excel Files with R

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.