Josse
June 2, 2021, 1:15pm
1
Dear all,
When trying to read in an xlsx excel file, I stumble upon a problem. Only the first 50 columns have a header and are imported, the others not. I tried too remove the columns around the 50th column to hope this would solve it, but no luck with this. Any idea how to fix this?
my code
library(readxl)
Book1_1 <- read_xlsx("~/Boma - Josse/CM/0. Rusthuizen/one zero/Book1.1.xlsm",
sheet = "Sheet1")
View(Book1_1)
The problem is very similar to another topic, I have the same problem as there probably.
I am currently learning to program in R.
Right now I tried to import a quite big data set from Excel File which I did multiple times before already. In this specific data set the first 30 columns are imported but the rest is not. When I view it in the data preview the rest of the columns is also shown but only the data not the headings of the columns. I think that is why the data is not shown when I import it normally.
However, I think it is a problem in the excel file, but I have no idea what could be wrong since the headings are shown in excel but not in R.
[Capture]
All the columns will be imported. The viewer window just shows the first 50.
1 Like
Josse
June 2, 2021, 1:30pm
3
Thank you very much! I feel a bit stupid, but at least I can move on
system
June 9, 2021, 1:30pm
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
