Empty column problem

A column that has a header but no data is missing from the data table. The column is not there in ItemArray, for example. There is no blank days where that column would be. Even using column name returns the wrong data after the empty column. I've seen this in the newest version of Excel (xlsx). 