Re: [R] Reading a password-protected Excel workbook

2010-02-25 Thread 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 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 = "m

[R] Reading a password-protected Excel workbook

2010-02-25 Thread Dimitri Shvorob
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: htt

Re: [R] Reading a password-protected Excel workbook

2010-02-25 Thread Dieter Menne
Dimitri Shvorob 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. > > Not really: http://sup