[R] Reading a password-protected Excel workbook

[Gabor Grothendieck]

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
> 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.
>