[R-sig-ins] pasteFromExcel

[David Winsemius]

I was the poster who offered those options and have replied to Dan on some followup questions on Rhelp, but the last question seemed to revolve around how Excel handle currency formatting and that is definitely off-topic on Rhelp. I wondered, however, whether it would be seen as on-topic for this mailing list?

(Despite my medical degree, I'm a longtime user of Excel and a medium-term user of R.)

-- 
David Winsemius, MD, MPH
Medical Director, Life Underwriting
AXA
Financial Services Section, US

On Oct 20, 2014, at 10:35 AM, Dan Murphy wrote:

> This is a follow-up to the tread originally started by Edward Roche on Sep 29.
> 
> Sorry for cross-posting. Meant to post here but sent to R-Help
> inadvertently. But I can't complain because I already received a
> suggestion for my locale question (Sys.getlocale("LC_MONETARY") and
> options("OutDec")).
> 
> 
> ---------- Forwarded message ----------
> From: Dan Murphy <chiefmurphy at gmail.com>
> Date: Sun, Oct 19, 2014 at 11:18 PM
> Subject: pasteFromExcel
> To: "R-help at r-project.org" <r-help at r-project.org>
> 
> 
> To Users of Excel:
> 
> Following advice from Brian and Markus, I created an RMarkdown
> "vignette" that shows an example of how the pasteFromExcel function in
> the excelRio package on github could be used by an actuary to transfer
> a triangle from Excel to R. See today's post at
> http://trinostics.blogspot.com/
> 
> Unfortunately, if you are located outside the US, the demonstrated
> functionality will not work for you because the currency regex
> implemented assumes the dollar sign ($) and comma/decimal punctuation
> of the form 999,999.00.
> 
> If anyone is interested in contributing currency regex expressions
> that work in your locale, I would be happy to try to incorporate them
> in the package. If anyone knows how best to determine the user's
> locale (might "timezone" suffice?), I'd appreciate that help too.
> 
> Thanks a lot.
> 
> Dan
> 
> _______________________________________________
> R-SIG-insurance mailing list
> R-SIG-insurance at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-insurance

David Winsemius
Alameda, CA, USA