Mapping XML to workbook

[heliotropic]

Hello, I'm trying to map XML elements to a workbook.

Each column in the workbook has hundreds of rows, so the .XML map file is
formatted in a such a way that excel detects an XML list is being made. When
I drag the XML elements onto the workbook - to complete the mapping process -
only half the columns acquire a blue border. (The blue border signifies the
columns' contents are mapped to respective XML elements.) The problem
columns only have their top two cells blue-bordered (with a blue star in the
last cell). This seems to be an issue of Excel finding an empty cell in a
column and stopping the mapping process; I want the entire column mapped.
Does anyone know how to remedy this?

Thanks.

 

[heliotropic]

I should also add that my goal is to take a large Excel workbook and export
its data as XML. So once all the columns are successfully mapped I will be
exporting it as an XML file.