Re: [R] read password-protected files

From: Joshua Wiley <jwiley.psych_at_gmail.com>
Date: Thu, 31 Mar 2011 11:50:27 -0700

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



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. Received on Thu 31 Mar 2011 - 18:53:06 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 31 Mar 2011 - 19:10:26 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive