Problems with importing csv files

Hello guys

I have a problem when I try to import an excel file. When it has 10 or more lines, the file look like this:

I cannot click or work in the import options, only before I browse the file.

Can anyone help me please?

Hello,

importing .xlsx Excel files can easily be done with the function in your screenshot readxl::read_xlsx(). Just follow the documentation on this.

If you wish further information, you might be better of showing the Excel file instead of the import window from R. Maybe something is wrong with the cell separators, but with a usual .xlsx file you should have no problems importing the file into R.

Kind regards

2 Likes

But I want to work in the import options, and this bug happens with all excel files that I import :confused:
The excel file is this:

Thank you

Inês

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.