[R] help to ... import the data from Excel

[jim holtman]

Part of my problem has to do with getting through the corporate
firewall to access the other program I have to download to use it.  I
just tried today and this is what I got:

> xls.getshlib()
Loading required package: tools
--- xls.getshlib running... ---
  - download.file from
'http://dl.dropbox.com/u/2602516/swissrpkg/bin/win32/shlib/xlsReadWrite_1.5.4_dll.zip'
(timeout: 60)
Error in copyOrDownload(url) :
  downloading 'http://dl.dropbox.com/u/2602516/swissrpkg/bin/win32/shlib/xlsReadWrite_1.5.4_dll.zip'
to 'C:\DOCUME~1\kon9407\LOCALS~1\Temp\RtmpQR6rWi/xlsReadWrite.zip' failed
In addition: Warning message:
In download.file(url, fpzip.temp, method = "internal", quiet = TRUE,  :
  cannot open: HTTP status was '403 Forbidden'

Enter a frame number, or 0 to exit

1: xls.getshlib()
2: copyOrDownload(url)


I think when I was using it in the past, I had some problem with
writing to multiple output sheets so I could create tabs on the
workbook, but not really sure what was happening at the time.  I have
had better luck with XLConnect in creating tabbed workbooks.

On Tue, Nov 15, 2011 at 6:06 AM, Hans-Peter Suter <gchappi at gmail.com> wrote:
> Jim,
>
> 2011/10/15 jim holtman <jholtman at gmail.com>:
>> You might also want to consider the XLConnect package.  I have had
>> better luck reading/writing Excel files than with xlsReadWrite.
>
> XLConnect looks good but - as the xlsReadWrite author and planing to
> release a xlsx/64 bit successor - I'd be interested to learn what you
> mean with "better luck reading/writing". Thanks a lot and
>
> Cheers,
> Hans-Peter
>



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.