New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

¿Error reading data? #146

Closed
skanskan opened this Issue Nov 4, 2015 · 2 comments

Comments

Projects
None yet
2 participants
@skanskan

skanskan commented Nov 4, 2015

Hello.

I've uploaded this simple excel file.

http://www67.zippyshare.com/v/0PNe04je/file.html

It contains 6 columns and 60 rows.

When I use this command:
data <- read_excel("CoIn.xlsx", sheet=1, col_names=TRUE , na="", skip=0)

data contains not only the proper columns but also many others filled with NA

If I read the same excel file with other packages I don't have any issue.

@jennybc

This comment has been minimized.

Member

jennybc commented Jan 31, 2017

Can you please attach the example file to this issue thread? Thanks!

How to provide a readxl reprex

We're in a much better position to address your issue if you can provide a reprex (reproducible example). Provide as much of this as you can:

  • An actual xls or xlsx file. Pick one:
    • Your personal xls or xlsx: try to strip it down to the minimal size and complexity to demonstrate your point. And, obviously, remove any sensitive data.
    • A publicly available xls or xlsx: provide URL and the code you used to download.
  • A small bit of R code that uses readxl on the provided xls or xlsx file and demonstrates your point.
    • Consider using the reprex package to prepare this. In addition to nice formatting, this ensures your reprex is self-contained.
  • Any details about your environment that seem clearly relevant, such as operating system.
    reprex(..., si = TRUE)
    will append a standard summary, folded neatly away, at the bottom of your reprex.

How to provide your own xls/xlsx file? In order of preference:

  1. Attach the file directly to your issue. Instructions are always at the bottom of the issue or comment box.
  2. Share via DropBox or Google Drive and provide the link in your issue.
  3. Explain you absolutely cannot provide a relevant file via github.com and offer to provide privately.
  4. Don't share a file and realize you're hoping for, e.g., a bug fix with no concrete example to go on.

@jennybc jennybc added the reprex label Jan 31, 2017

@jennybc

This comment has been minimized.

Member

jennybc commented Feb 5, 2017

Until proven otherwise, I assume this is a duplicate of #162.

@jennybc jennybc closed this Feb 5, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment