Cracking a problem with merging ufocontents.

I've been working on Drone Strike all day today, and I'm having an issue with ufocontents. The modinfo log reports that the columns do not match, namely:

Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.scout.caesan.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.scout.sebillian.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.corvette.caesan.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.corvette.sebillian.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.corvette.andron.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.landingship.caesan.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.landingship.sebillian.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.landingship.andron.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.cruiser.caesan.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.cruiser.sebillian.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.cruiser.andron.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.carrier.caesan.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.carrier.sebillian.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.carrier.andron.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.battleship.caesan.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.battleship.sebillian.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Columns do not match.Thu Sep 18 17:06:55 2014: MOD ERROR: Merging Excel XML for mods/dronestrike/ from mod ufocontents/airplane.alien.battleship.andron.xml failed.Thu Sep 18 17:06:55 2014: MOD ERROR: Number of columns does not match.

I went back and looked at the column headers, and the modded files (here's a sample)

   <Column ss:AutoFitWidth="0" ss:Width="184.5" ss:Span="2"/>  <Row ss:AutoFitHeight="0" ss:Height="14.25" ss:StyleID="s62">   <Cell ss:StyleID="s63"><Data ss:Type="String">AlienRole</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">Research Min</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">Research Max</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">ScoutMission Min</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">ScoutMission Max</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">GroundAttack Min</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">GroundAttack Max</Data></Cell>  </Row>  <Row>   <Cell><Data ss:Type="String">Lightdrone_Lightdrone_Aggressive</Data></Cell>   <Cell><Data ss:Type="Number">1</Data></Cell>   <Cell><Data ss:Type="Number">1</Data></Cell>   <Cell><Data ss:Type="Number">1</Data></Cell>   <Cell><Data ss:Type="Number">1</Data></Cell>   <Cell><Data ss:Type="Number">1</Data></Cell>   <Cell><Data ss:Type="Number">1</Data></Cell>  </Row>

Seem to be the same as the actual files

   <Column ss:AutoFitWidth="0" ss:Width="184.5" ss:Span="2"/>  <Row ss:AutoFitHeight="0" ss:Height="14.25" ss:StyleID="s62">   <Cell ss:StyleID="s63"><Data ss:Type="String">AlienRole</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">Research Min</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">Research Max</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">ScoutMission Min</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">ScoutMission Max</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">GroundAttack Min</Data></Cell>   <Cell ss:StyleID="s63"><Data ss:Type="String">GroundAttack Max</Data></Cell>  </Row>  <Row ss:AutoFitHeight="0" ss:Height="13.5">   <Cell><Data ss:Type="String">Sebillian_Guard_Aggressive</Data></Cell>   <Cell><Data ss:Type="Number">4</Data></Cell>   <Cell><Data ss:Type="Number">4</Data></Cell>   <Cell><Data ss:Type="Number">4</Data></Cell>   <Cell><Data ss:Type="Number">4</Data></Cell>   <Cell><Data ss:Type="Number">4</Data></Cell>   <Cell><Data ss:Type="Number">4</Data></Cell>  </Row>

This is a problem across all the ufocontents files I've modded, so there's something I'm doing/not doing that's common to all of them. I just can't work out what. If anyone has experience with ufocontents, I'd appreciate any advice you might be willing to give.

EDIT: I've uploaded the Drone Strike files, so if you need to access them, they're here

That's wierd. After a hour or so of trying various things, I deleted the end <cell> line from the sebillians.scout ufo, and now it merges properly. But doing that, I've deleted the max number of drones for a ground attack. Is there a problem with parsing ufocontents?

There should be more columns in the latest X:CE ufocontents. Make sure you're looking at the X:CE file (quite possibly under mods/xce).

I'm such a prize idiot. Note to self - check xce first. Thanks for the help!