[R] Reading a password-protected Excel workbook
ggrothendieck at gmail.com
Thu Feb 25 19:01:18 CET 2010
Use RDCOMClient or rcom to open it and then use RODBC to read it.
On Thu, Feb 25, 2010 at 7:26 AM, Dimitri Shvorob
<dimitri.shvorob at gmail.com> wrote:
> I try reading a password-protected spreadsheet with RODBC, passing a file or
> an ODBC source to odbcConnect, e.g.
> con = odbcConnect(dsn = "mywkbk", uid = "", pwd = "mypwd")
> but get "Could not decrypt file" pop-up error message.
> Can anyone help?
> Thank you.
> View this message in context: http://n4.nabble.com/Reading-a-password-protected-Excel-workbook-tp1568925p1568925.html
> Sent from the R help mailing list archive at Nabble.com.
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help