Excel XML Spreadsheet: watch your Worksheet.Table.ExpandedColumnCount (or just leave it out)
Posted by jpluimers on 2011/08/11
Recently, I blogged about the Excel XML Spreadsheet: Date.Type is mandatory.
Here is another error you can get:
XML ERROR in Worksheet Setting REASON: Bad Value FILE: V:\CAS400\docs\statistics.cascall-logs\cascall.JU03HV.Bobbe, P.J.L. (Paul).20110620.xml GROUP: Worksheet TAG: Table ATTRIB: ExpandedColumnCount VALUE: 9
This basically means your Worksheet.Table.ExpandedColumnCount is too small to hold your spreadsheet.
In other words: you either have more Worksheet.Table.Column definitions than ExpandedColumnCount, or you have a WorkSheet.Table.Row that has more WorkSheet.Table.Row.Cell entries than the ExpandedColumnCount.
In my case, I made an error generating too many Column definitions (by accidentaly duplicating some of them), and invalidated the ExpandedColumnCount.
Lesson learned: Since Excel will automatically calculate an absent ExpandedColumnCount, you can safely leave it out.
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a comment