Hi
You need to help yourself. My guess is that you did not tell to read_excel
function where is your excel file.
When the file is in working directory it works seamlessly.
> library(readxl)
> read_excel("ebc.xlsx")
# A tibble: 8 x 16
material Rok osoby `8oh` `8ohg` `5ohm` otyr `3tyr` mda hhe hne
<chr> <dbl> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
1 tio2 2012. vyroba 25. 35. 25. 38. 42. 40. 40. 40.
2 tio2 2013. vyroba 38. 46. 35. 45. 48. 45. 55. 45.
3 tio2 2012. kontrola 10. 12. 12. 28. 14. 20. 15. 15.
4 tio2 2013. kontrola 17. 15. 17. 18. 20. 20. 15. 20.
5 fe2o3 2013. vyroba 28. 32. 25. 28. 29. 32. 30. 32.
6 fe2o3 2013. kontrola 17. 15. 17. 18. 20. 20. 17. 19.
7 kompozit 2016. vyroba 28. 37. 28. 32. 32. 25. 25. 25.
8 kompozit 2016. kontrola 20. 20. 20. 22. 22. 18. 20. 20.
# ... with 5 more variables: `8iso` <dbl>, ltb4 <dbl>, ltc4 <dbl>, ltd4 <dbl>,
# lte4 <dbl>
>
You should either to disclose to read function where is your excel file or
change working directory or copy excel file to your working directory, whatever
is easiest and most convenient to you.
Cheers
Petr
From: Aakash Kumar <ssaak...@gmail.com>
Sent: Thursday, September 6, 2018 2:48 PM
To: PIKAL Petr <petr.pi...@precheza.cz>; r-help@r-project.org
Subject: RE: [R] Query on read.xls function in gdata
Thanks for the suggestion, Petr.
I did try using read_xls and read_excel functions, but I got an error :
"Error in read_fun : Failed to open .xls file"
The file can be manually opened though.
It would be very helpful if you could help me out with this.
Thanks.
Regards,
Aakash
On 06-Sep-2018 17:00, "PIKAL Petr"
<petr.pi...@precheza.cz<mailto:petr.pi...@precheza.cz>> wrote:
Hi
If you do not need to stick with gdata you could try package readxl, it does
not need any further packages.
https://cran.r-project.org/web/packages/readxl/readxl.pdf
It results in tibble data but change to data.frame is easy.
Cheers
Petr
> -----Original Message-----
> From: R-help
> <r-help-boun...@r-project.org<mailto:r-help-boun...@r-project.org>> On Behalf
> Of Aakash Kumar
> Sent: Thursday, September 6, 2018 12:43 PM
> To: r-help@r-project.org<mailto:r-help@r-project.org>
> Subject: [R] Query on read.xls function in gdata
>
> Hi Team,
>
> I am trying to read in .xls files in R using read.xls function present in
> gdata
> package. I have installed the required perl dependencies as well.
> Yet, I am facing the following error.
>
> "*Error in xls2sep : Intermediate file is missing*"
>
> Could someone please help me out understanding the cause and if possible, a
> fix for the same?
>
> Thanks in advance!
>
> Regards,
> Aakash
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org<mailto:R-help@r-project.org> mailing list -- To
> UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Osobní údaje: Informace o zpracování a ochraně osobních údajů obchodních
partnerů PRECHEZA a.s. jsou zveřejněny na:
https://www.precheza.cz/zasady-ochrany-osobnich-udaju/ | Information about
processing and protection of business partner’s personal data are available on
website: https://www.precheza.cz/en/personal-data-protection-principles/
Důvěrnost: Tento e-mail a jakékoliv k němu připojené dokumenty jsou důvěrné a
podléhají tomuto právně závaznému prohláąení o vyloučení odpovědnosti:
https://www.precheza.cz/01-dovetek/ | This email and any documents attached to
it may be confidential and are subject to the legally binding disclaimer:
https://www.precheza.cz/en/01-disclaimer/
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
