search

52vis / 2016-13

Week 13 of 2016
8 stars 4 forks source link

Error reading the excel file #1

Open steveharoz opened 8 years ago

steveharoz commented 8 years ago

Everything up to that point works fine. I only skipped loading hrbrmisc library.

> xl1 <- read_excel(fil1)
Error: error -103 with zipfile in unzGetCurrentFileInfo
hrbrmstr commented 8 years ago

you may want to try to update readxl I'm on:

readxl       * 0.1.0.9000 2015-07-03 Github (hadley/readxl@7c7f66b)

For other reasons than this. It might be due to this that it's having issues.

Also try to read the offending Excel file with Excel to see if it d/l properly.

steveharoz commented 8 years ago

Aha! Excel won't open the downloaded file either. But when I download the file manually, readxl works.

I'm on Windows. Maybe there's an OS issue with download.file()?

hrbrmstr commented 8 years ago

I can see if any of the folks at the rOpenSci Unconf have issues with it. I didn't bring my external HD with my Windows VM on it with me to SF (sigh).

one option to try is httr::GET("the url", httr::write_disk("the filename"), verbose())

(syntax may be wonky…I did that in e-mail on on iPhone :-)

On Wed, Mar 30, 2016 at 1:09 PM, Steve Haroz notifications@github.com wrote:

Aha! Excel won't open the downloaded file either. But when I download the file manually, readxl works.

I'm on Windows. Maybe there's an OS issue with download.file()?

— You are receiving this because you commented. Reply to this email directly or view it on GitHub https://github.com/52vis/2016-13/issues/1#issuecomment-203611574

expersso commented 8 years ago

I encountered this as well. You just need to specify mode = "wb" in download.file().

hrbrmstr commented 8 years ago

ty. The difference in impl for download.file() between OS X & Windows is a

bit disconcerting. I wonder if it's due to method="curl" by default in OS X and not on Windows. Is options("download.file.method") wininet for either/both of you?

On Thu, Mar 31, 2016 at 7:01 AM, EP notifications@github.com wrote:

I encountered this as well. You just need to specify mode = "wb" in download.file().

— You are receiving this because you commented. Reply to this email directly or view it on GitHub https://github.com/52vis/2016-13/issues/1#issuecomment-203953550

expersso commented 8 years ago

It's NULL for me.

steveharoz commented 8 years ago

I'm getting wininet