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 <ssaakash at gmail.com>
Sent: Thursday, September 6, 2018 2:48 PM
To: PIKAL Petr <petr.pikal at precheza.cz>; r-help at 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.pikal at
precheza.cz<mailto:petr.pikal at 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-bounces at r-project.org<mailto:r-help-bounces
at r-project.org>> On Behalf Of Aakash Kumar
> Sent: Thursday, September 6, 2018 12:43 PM
> To: r-help at r-project.org<mailto:r-help at 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 at r-project.org<mailto:R-help at 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]]