[R] Query on read.xls function in gdata

[PIKAL Petr]

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