[R] read password-protected files

[Shi, Tao]

Thanks, Josh.  I use xlsReadWrite routinely.  It would be nice if it has a 
password option.

...Tao




----- Original Message ----
> From: Joshua Wiley <jwiley.psych at gmail.com>
> To: "Shi, Tao" <shidaxia at yahoo.com>
> Cc: r-help at r-project.org
> Sent: Thu, March 31, 2011 11:50:27 AM
> Subject: Re: [R] read password-protected files
> 
> Hi Tao,
> 
> There are a number of R packages to work with reading/writing  Excel
> files (e.g., xlsReadWrite).  If Excel is on the system in  question, as
> long as you have opened the file in Excel, you should be able to  use
> RODBC with  RDCOMClient or rcom, but I am not sure those will work  if
> it is password protected unless it is currently unlocked in  Excel.
> 
> HTH,
> 
> Josh
> 
> On Thu, Mar 31, 2011 at 11:33 AM, Shi, Tao  <shidaxia at yahoo.com> wrote:
> > Hi  Josh and Prof. Ripley,
> >
> > Thanks for the quick  replies!
> >
> > Sorry about the HTML email.  It's the default for my  yahoo account and 
>forgot to
> > switch.
> >
> > The question was  asked by a colleague of mine.  After double-checking, yes, 
>they
> > are  actually Excel files.  Any idea on how to approach this?
> >
> >  Thanks!
> >
> > ...Tao
> >
> >
> >
> >  ________________________________
> > From: Prof Brian Ripley <ripley at stats.ox.ac.uk>
> > To:  "Shi, Tao" <shidaxia at yahoo.com>
> > Cc: r-help at r-project.org
> > Sent: Thu,  March 31, 2011 11:15:35 AM
> > Subject: Re: [R] read password-protected  files
> >
> > On Thu, 31 Mar 2011, Shi, Tao wrote:
> >
> >>  Hi list,
> >>
> >> I have a bunch of .csv files that are  password-protected.  I wonder if 
>there
> > is
> >
> > There is  nothing in the CSV standard about password protection.  I
> > very much  doubt that these actually CSV files.  So please follow the
> > posting guide  [*]
> >
> >> a way to read them in in R without manually removing the  password 
>protection
> >>for
> >> each  file?
> >>
> >> Thank you very  much!
> >>
> >>
> >> ...Tao
> >>     [[alternative  HTML version deleted]]
> >>
> >>  ______________________________________________
> >> 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.
> >
> > [*] as above: and as  you sent HTML you are either full of contempt for
> > the helpeRs or failed  to do your homework.
> >
> >
> > --
> > Brian D. Ripley,                   ripley at stats.ox.ac.uk
> > Professor  of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> > University of  Oxford,             Tel:  +44 1865 272861 (self)
> > 1 South Parks Road,                      +44 1865 272866 (PA)
> > Oxford OX1 3TG, UK                 Fax:  +44 1865 272595
>