[R] Copy data from Excel
Christofer Bogaso
bogaso.christofer at gmail.com
Wed Dec 19 19:22:56 CET 2012
Hello again,
I my day to day calculation, I need to take lot of data from Excel and
forth and generally I use 'clipboard' option with read.delim() function.
However many time, the data in Excel are like '(111,000)' instead of
'-111000'. Generally I convert data in the 2nd form in Excel itself and
then copy to clipboard.
Is there any option in R, so that I can copy-paste '(111,000)' directly
into R in numeric format? And also pasting data into Clipboard from R in
the format of '(111,000)'?
Thanks for your input
More information about the R-help
mailing list