Erich Subscriptions
2022-Apr-28 08:54 UTC
[R] R 4.2.0: write.table() "clipboard-1024" copies only columns name
Die you try clipr::write_clip as an alternative?> On 28.04.2022, at 10:38, Sergei Ko <sggp.sergei at gmail.com> wrote: > > I used write.table(mat, "clipboard-1024", sep="\t", row.names=FALSE) to > copy from R to Excel in previous versions. After updating to 4.2.0 it > copies column names only to clipboard. Win 10 64 bit. Any ideas on how to > fix it? Try this: > > mat = matrix(0, 2, 3) > write.table(mat, "clipboard-1024", sep="\t", row.names=FALSE) > > [[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.
Sergei Ko
2022-Apr-28 13:32 UTC
[R] R 4.2.0: write.table() "clipboard-1024" copies only columns name
Hi Erich, Thanks for the suggestion. The "write_clip" solution works as intended. I wanted to raise a question regarding the "write.table" function behaviour in R 4.2.0 because I used this solution extensively in my hybrid Excel/R tools to return results. I expected stable behaviour from a function from "utils". While on the topic - can someone please confirm this bug? Regards, Sergiy On Thu, Apr 28, 2022 at 9:54 AM Erich Subscriptions < erich.subs at neuwirth.priv.at> wrote:> Die you try clipr::write_clip as an alternative? > > > > On 28.04.2022, at 10:38, Sergei Ko <sggp.sergei at gmail.com> wrote: > > > > I used write.table(mat, "clipboard-1024", sep="\t", row.names=FALSE) to > > copy from R to Excel in previous versions. After updating to 4.2.0 it > > copies column names only to clipboard. Win 10 64 bit. Any ideas on how to > > fix it? Try this: > > > > mat = matrix(0, 2, 3) > > write.table(mat, "clipboard-1024", sep="\t", row.names=FALSE) > > > > [[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. > >[[alternative HTML version deleted]]