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@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
______________________________________________
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.
