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.
