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.shvo...@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@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. >
______________________________________________ R-help@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.
