Missing columns due to blank cells underneath column header

[tidyverse]

Missing columns due to blank cells underneath column header

[hadley]

This seems to be ok now:

 tail(read_excel("~/Desktop/Kbp1MB-March2015.xlsx"))
           NA KBP1434D KBP1437D KBP1438D KBP1440D KBP1456D KBP1457D
5299 20150131     2561    37800        0    40717     1256      900
5300 20150202        0    37800        0    41881     4583      502
5301 20150203        0    37800        0    40790     3230      241
5302 20150204        0    37500        0    40619     3363      244
5303 20150205        0    37500        0    38806     1611      305
5304 20150206        0    37500        0    37940     1433      993

[chrisaxelson]

Hi Hadley,

Sorry I'm really not trying to be a pain - it's the fourth sheet in the xlsx file that has the issue. There are 295 columns but code will import first 2 only.

tail(read_excel("~/Desktop/Kbp1MB-March2015.xlsx"), sheet = 4)

Thanks again for all your work on readr, readxl and haven lately!

[reinierv4]

I have a similar problem. When I try to read in a .xls file downloaded and saved from the internet R reads in the file without the last column. When I manually open and save my excel file and try to read in the file again this problem disappears. This is however not a feasible workaround because of the amount of files I have to process. Would be great if somebody has a solution!

[hadley]

@reinierv4 please file a new issue with a minimal reproducible example (i.e. including a link to the file to download)

[reinierv4]

Hi Hadley, thanks a lot for your quick response. I created a new issue: #99