[R-sig-ins] Fwd: pasteFromExcel

[Dan Murphy]

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