Skip to content
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

read_excel() is reading zeros instead of the real numbers. #701

Open
AlvaroMCMC opened this issue Jul 26, 2022 · 0 comments
Open

read_excel() is reading zeros instead of the real numbers. #701

AlvaroMCMC opened this issue Jul 26, 2022 · 0 comments

Comments

@AlvaroMCMC
Copy link

AlvaroMCMC commented Jul 26, 2022

I'm trying to read this excel file into a tibble.

I did it with:
file <- "file.xls"
file.xls

image

used code (it remains the same with read_xls)
read_excel(file, sheet = "Humedad", col_types = "text")


The problem is, that the first three columns are filled with zeros, even the col names which are incorrect because there are real numbers as you see in the image above.

incorrect output:
image

# insert reprex here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant