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 Replies to “Remove ExpandedColunCount and ExpandedRowCount when using Microsoft Exel (*.xml) file as template”
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Thank you. This was helpful to me.
Thanks! Helped me too.
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 ?!!
To get to that file type the path to the error file in
Internet Explorer and it will show up
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?
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.
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
Thanks so much, that was very helpful and helped fix a bug.
Thanks, helped me a lot!