Copy data from Excel
If you are going to be reading a lot of data from EXCEL, use the XLConnect package since it will give you back the values as numeric instead of the "formatted" values with commas. Also it means you can automate the activity since you don't have to use the "clipboard". On Wed, Dec 19, 2012 at 1:22 PM, Christofer Bogaso
<bogaso.christofer at gmail.com> wrote:
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
______________________________________________ R-help at r-project.org mailing list 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.
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.