Prev: RTD server in C#
Next: System error &H8000FFFF (-2147418113)
From: pnschofield on 3 Nov 2006 15:58
I'm developing an ASP.NET application that converts a DataSet populated
from a stored procedure into an Excel XML spreadsheet. I've tweaked as
many problems as I can with the generated spreadsheet, but I'm still
getting this one when I open it in Excel:

XML ERROR in PivotTable
REASON: Missing Tag
FILE: C:\projects\AdShuffle\AdShuffle.CommandCenter\xml\ReportOutput.xml
GROUP: PivotTable
TAG: PivotField

Here are the contents of ReportOutput.xml:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>Paul Schofield</Author>
<LastAuthor>Paul Schofield</LastAuthor>
<Created>2006-10-24T17:36:30Z</Created>
<LastSaved>2006-10-31T20:30:56Z</LastSaved>
<Company>true.com</Company>
<Version>11.8107</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>15585</WindowHeight>
<WindowWidth>19995</WindowWidth>
<WindowTopX>480</WindowTopX>
<WindowTopY>105</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom" />
<Borders />
<Font />
<Interior />
<NumberFormat />
<Protection />
</Style>
<Style ss:ID="s21">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
</Style>
<Style ss:ID="s22">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
</Style>
<Style ss:ID="s23">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="Background" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
</Style>
<Style ss:ID="s24">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="Background" />
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
</Style>
<Style ss:ID="s25">
<Borders>
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
</Style>
<Style ss:ID="s27">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat />
</Style>
<Style ss:ID="s28">
<Borders>
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat />
</Style>
<Style ss:ID="s31">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
</Style>
<Style ss:ID="s32">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat />
</Style>
<Style ss:ID="s33">
<NumberFormat />
</Style>
<Style ss:ID="s36">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="Background" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
</Style>
<Style ss:ID="s37">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat />
</Style>
<Style ss:ID="s38">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat />
</Style>
<Style ss:ID="s42">
<NumberFormat ss:Format="mm:ss.0" />
</Style>
<Style ss:ID="s57">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat ss:Format="m/d/yyyy;@" />
</Style>
<Style ss:ID="s59">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat ss:Format="m/d/yyyy;@" />
</Style>
<Style ss:ID="s60">
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="Background" />
</Borders>
<Number
 | 
Pages: 1
Prev: RTD server in C#
Next: System error &H8000FFFF (-2147418113)