In my Denodo Platform Express 7.0 I did not come across this type of situation. I have created a Excel file with same data as the question, I created a Base view on Denodo using an Excel Datasource. I enabled the “Stream Tuples”, “Has Headers”, also I used B1 as start cell and D4 as end cell.
When I executed the base view, I was able to get the results with “City” column as well. Reading the [Excel Sources](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/excel_sources) of Virtual DataPort Administration Guide helped me understand the usage of Excel data sources.
Hope this helps!