[R] Copy data from Excel

[jim holtman]

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.