Thanks, Josh. I use xlsReadWrite routinely. It would be nice if it has a password option.
...Tao ----- Original Message ---- > From: Joshua Wiley <jwiley.ps...@gmail.com> > To: "Shi, Tao" <shida...@yahoo.com> > Cc: r-help@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 <shida...@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 <rip...@stats.ox.ac.uk> > > To: "Shi, Tao" <shida...@yahoo.com> > > Cc: r-help@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@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, rip...@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 > ______________________________________________ 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.
