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.
