[R] Help with locating error on import of data

[Rui Barradas]

Hello,

Try setting argument col.names = FALSE, it seems that the function is 
not find column headers and is choosing its own.


Balance_sheet <- read_excel("Y:/All Documents/Training/Data/Routines for 
consolidating all the data/Individual tables/AIM 
companies/Balance_sheet.xlsx", na = "", col_names = FALSE)


Hope this helps,

Rui Barradas

Às 15:56 de 23/06/2020, Ahson via R-help escreveu:
> I have imported data from an Excel file and I am getting errors:
>
>> library(readxl)
>> Balance_sheet <- read_excel("Y:/All Documents/Training/Data/Routines for consolidating all the data/Individual tables/AIM companies/Balance_sheet.xlsx", na = "")
> New names:
> * `` -> ...6
> * `` -> ...7
> * `` -> ...9
> * `` -> ...10
> * `` -> ...11
> * ... and 22 more problems
>
>
> How can I find where the error is originating? What does New names mean?
>
> Thanks in advance for your help.
>
>
> Sent from Mail for Windows 10
>
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> 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.

-- 
Este e-mail foi verificado em termos de vírus pelo software antivírus Avast.
https://www.avast.com/antivirus