The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,641 other followers

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: