On 2020-06-23 17:24 +0100, Rui Barradas wrote:
> À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:
>
> Try setting argument col.names = FALSE, it
> seems that the function is not find column
> headers and is choosing its
one of the problems with Excel is that people can put anything in any
column. You might want to restrict which columns you are reading
since if it finds data in some cells and there is not a header, it
will create one.
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve
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
It looks like it's looking for column names in the first row of your Excel
sheet and not finding them. What does the first row contain?
On Tue, Jun 23, 2020 at 10:57 AM Ahson via R-help
wrote:
> I have imported data from an Excel file and I am getting errors:
>
> > library(readxl)
> > Balance_sh
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
* `` ->
5 matches
Mail list logo
