Thanks, Henrique! I'll try that.
...Tao
----- Original Message ----
> From: Henrique Dallazuanna <www...@gmail.com>
> To: "Shi, Tao" <shida...@yahoo.com>
> Cc: Prof Brian Ripley <rip...@stats.ox.ac.uk>; r-help@r-project.org
> Sent: Thu, March 31, 2011 12:00:45 PM
> Subject: Re: [R] read password-protected files
>
> Using RDCOMCliente:
>
> library(RDCOMClient)
> eApp <- COMCreate("Excel.Application")
> wk <- eApp$Workbooks()$Open(Filename="your_file",Password="your_password")
> tf <- tempfile()
> wk$Sheets(1)$SaveAs(tf, 3)
>
> DF <- read.table(sprintf("%s.txt", tf), header = TRUE, sep = "\t")
>
> On Thu, Mar 31, 2011 at 3:33 PM, 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>
> >
> > 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?
> >>
> > [[elided Yahoo spam]]
> >>
> >>
> >> ...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.
> >
>
>
>
> --
> Henrique Dallazuanna
> Curitiba-Paraná-Brasil
> 25° 25' 40" S 49° 16' 22" O
>
______________________________________________
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.
