[R] downloading Excel files

[Erin Hodgess]

Actually, I ran across something a moment ago.

read.xls takes http files.  It's in the gdata package.  Make sure that
you have perl on the path too.

Thanks,
Erin


On Thu, Mar 1, 2012 at 6:54 PM, Erin Hodgess <erinm.hodgess at gmail.com> wrote:
> Thanks J!
>
> I was thinking about the url, download.file functions too
>
> Just wanted to make sure that there wasn't something special for Excel.
>
> Thanks,
> Erin
>
>
> On Thu, Mar 1, 2012 at 6:53 PM, J Toll <jctoll at gmail.com> wrote:
>> On Thu, Mar 1, 2012 at 6:43 PM, Erin Hodgess <erinm.hodgess at gmail.com> wrote:
>>> Dear R People:
>>>
>>> I have been using xlsReadWrite to read Excel files and am very pleased
>>> with it.  Thank you xlsReadWrite People!
>>>
>>> My question is:  is there a function, similar to get.hist.quote, to
>>> download Excel files from the web, please?
>>
>> If you just need to download then you could try download.file() from utils.
>>
>> Otherwise read.xls from gdata might work for you. It supports
>> "http://", "https://", and "ftp://" URLS.
>>
>> HTH
>>
>> James
>>
>>
>>
>>
>>> Thanks,
>>> Erin
>
>
>
> --
> Erin Hodgess
> Associate Professor
> Department of Computer and Mathematical Sciences
> University of Houston - Downtown
> mailto: erinm.hodgess at gmail.com



-- 
Erin Hodgess
Associate Professor
Department of Computer and Mathematical Sciences
University of Houston - Downtown
mailto: erinm.hodgess at gmail.com