-- Originally posted by (AT sourceforge.net): rtautenh -- -- This ticket was imported from http://sourceforge.net/p/rkward/feature-requests/55 on 2017-05-31 14:48:56 +0100 -- Since many people end up copying data from Excel sheets into R, it would be great to have the possibility to paste the data not only into the data set editor, but also as 'R-encoded'-text \(e.g. vector: c\(x1,x2, ...\), or matrix: rbind\(c\(x1,x2,...\), c\(y1,y2,...\)\)\) into an R script. Thanks\! Ralf.-- Labels: General --
-- Originally posted by (AT sourceforge.net): rtautenh -- new package xlsx http://cran.r-project.org/web/packages/xlsx/index.html eliminated the need for it
-- Originally posted by (AT sourceforge.net): rtautenh -- - **status**: open --> closed
I still think it's a nice idea worth implementing some day, even if you no longer have a need for it. So I'll re-open to keep it on the list.
- **summary**: Copy and paste data from Excel/OOcalc into R editor --> Copy and paste data from spreadsheet into R editor - **status**: closed --> open
-- Originally posted by (AT sourceforge.net): nobody -- Works with OpenOffice 3.2.0 \! Thanks\! Rows are pasted as columns, though. Works fine when the toggle option is used.
As you've found out, I've recently implemented this in SVN. Note that we put a "cbind" around the vectors, so when you run the inserted code, the results should be like the copied data. In a first attempt, I used "rbind" instead, which makes the rows of pasted code correspond to the rows of data. My reason for changing it was, that if you have mix numeric and non-numeric cells in the copied data, those will typically be organized by column. So this way you have better chances of getting a "pure" vectors \(try it to see what I mean\). Do you think it's too confusing this way?
- **assigned_to**: nobody --> tfry - **summary**: Copy and paste data from spreadsheet into R editor --> IMPLEMENTED IN SVN: paste data into script editor
Thanks for your suggestion. This feature was released in RKWard 0.5.3, today. Closing.
- **status**: open --> closed