When you use a Microsoft Excel "*.xml" file as template for generating Microsoft Excel reports, remove the ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1"

from the <Table> tag under the <Worksheet> tag. If you don’t remove these counters a error will occur, because the row and or column count is higher then 1:

Problem During Load
Problems came up in the following areas during load:
Worksheet Setting
This file cannot be opened because of errors. Erros are listed in C:\Users……\Content.MSO\7BF935F6.log

 

<Worksheet ss:Name="Sheet3">
  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1">
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
</Worksheet>

 

An other error that can occur is:

XML ERROR in Table
REASON:    Bad Value
FILE:    C:\Temp\MyTest.xml
GROUP:    Table
TAG:    Row
ATTRIB:    Index
VALUE:    128

 

This was caused by the line:

<ss:Row ss:Index="128" ss:AutoFitHeight="0" ss:Height="12.9375">

Cause and solution

The index was not correct, by removing the ss:Index="128" ss:AutoFitHeight="0" ss:Height="12.9375" from the Row tag, the file could be opened correctly again.

9 Comments

  1. oh God!!! thank you soooo much!!! this is the Definition of the term “life saving”!!! just for the history.. what are those “Expanded…” and “Full….” what do they do ? and what the h*** is this folder Content.MSO that noone can find ?!!

    deneb
  2. The Statement

    causes the error, but reduced to

    it works fine.

    The problem is, I want to create an Excel sheet, only showing the used lines and columns, all other lines and columns shold be marked as hidden.

    If I hide some columns and rows manually and save as .XML again, the original line was changed by Ecel to this

    and the file can be opened in Excel again. The problem is, that the value for ExpandedRowCount is correct with 27, but the ExpandedColumnCount should be 8 and not 50, for only 8 columns and 27 rows are used to display the data.

    How can I set the Expanded[Row|Column]Count to the correct Values?

    fwp
  3. The Statement

    Table ss:ExpandedColumnCount=”10″ ss:ExpandedRowCount=”27″ x:FullColumns=”1″ x:FullRows=”1″ ss:StyleID=”Default” ss:DefaultColumnWidth=”5″ ss:DefaultRowHeight=”15″

    causes the error, but reduced to

    Table x:FullColumns=”1″ x:FullRows=”1″ ss:StyleID=”Default” ss:DefaultColumnWidth=”5″ ss:DefaultRowHeight=”15″

    it works fine.

    The problem is, I want to create an Excel sheet, only showing the used lines and columns, all other lines and columns shold be marked as hidden.

    If I hide some columns and rows manually and save as .XML again, the original line was changed by Ecel to this

    Table ss:ExpandedColumnCount=”50″ ss:ExpandedRowCount=”27″ x:FullColumns=”1″ x:FullRows=”1″ ss:StyleID=”Default” ss:DefaultColumnWidth=”5″ ss:DefaultRowHeight=”15″

    and the file can be opened in Excel again. The problem is, that the value for ExpandedRowCount is correct with 27, but the ExpandedColumnCount should be 8 and not 50, for only 8 columns and 27 rows are used to display the data.

    How can I set the Expanded[Row|Column]Count to the correct Values?

    Sorry for submitting twice, but the source lines were cut off during posting this reply.

    fwp
  4. Hi please help me. I am getting error when i add xmlns=”urn:schemas-microsoft-com:office:excel” in more that 1 worksheet opttions.

    I dont know how to fix this . please help

    cell a1

    cell b2

    cell a2

    cell b3

    50

    9
    35
    600
    600

    100

    1
    1
    2
    2
    0

    3

    1

    2

    0

    False
    False

    cell a1

    cell b2

    cell a2

    cell b3

    50

    9
    35
    600
    600

    100

    1
    1
    2
    2
    0

    3

    1

    2

    0

    False
    False

    cell b2

    cell a2

    cell b3

    50

    9
    35
    600
    600

    100

    1
    1
    2
    2
    0

    3

    1

    2

    0

    False
    False

    Vaibhav

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.