XML ERROR in PivotTable on generated XML spreadsheet

P

pnschofield

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:eek:ffice:spreadsheet"
xmlns:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
xmlns:x="urn:schemas-microsoft-com:eek:ffice: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:eek:ffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:eek:ffice:eek:ffice">
<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:eek:ffice: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>
<NumberFormat ss:Format="m/d/yyyy;@" />
</Style>
<Style ss:ID="s61">
<Borders>
<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="s62">
<Borders>
<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>
<NumberFormat />
</Style>
<Style ss:ID="s63">
<Borders>
<Border ss:position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000" />
</Borders>
<NumberFormat />
</Style>
<Style ss:ID="s64">
<Borders>
<Border ss:position="Bottom" 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>
<NumberFormat />
</Style>
<Style ss:ID="s65">
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom" />
<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>
</Styles>
<Worksheet ss:Name="Pivot Table">
<Table ss:ExpandedColumnCount="32" ss:ExpandedRowCount="25"
x:FullColumns="1" x:FullRows="1">
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<Selected />
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>3</ActiveRow>
<ActiveCol>4</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
<PivotTable xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<Name>PivotTable3</Name>
<ImmediateItemsOnDrop />
<ShowPageMultipleItemLabel />
<Location>R1C1:R25C5</Location>
<VersionLastUpdate>2</VersionLastUpdate>
<DefaultVersion>1</DefaultVersion>
<PTSource>
<CacheIndex>1</CacheIndex>
<VersionLastRefresh>2</VersionLastRefresh>
<RefreshName>Paul Schofield</RefreshName>
<RefreshDate>2006-11-01T11:49:05</RefreshDate>
<RefreshDateCopy>2006-11-01T11:49:05</RefreshDateCopy>
<ConsolidationReference>
<FileName>[Template xml spreadsheet.xml]Sheet2</FileName>
<Reference>R1C1:R43C14</Reference>
</ConsolidationReference>
</PTSource>
<PTFormat Style="mso-number-format:&quot;m\/d\/yyyy\;\@&quot;">
<PTRule>
<RuleType>Button</RuleType>
<Rule>Activity Date</Rule>
<ParseRuleAsV10 />
</PTRule>
</PTFormat>
<PTFormat Style="mso-number-format:&quot;m\/d\/yyyy\;\@&quot;">
<PTRule>
<RuleType>LabelOnly</RuleType>
<Rule>'Activity Date'[All]</Rule>
<ParseRuleAsV10 />
</PTRule>
</PTFormat>
<PTFormat Style="text-align:center">
<PTRule>
<RuleType>Button</RuleType>
<Rule>Activity Date</Rule>
<ParseRuleAsV10 />
</PTRule>
</PTFormat>
<PivotField>
<Name>PublisherName</Name>
<Orientation>Column</Orientation>
<Position>1</Position>
<PivotItem>
<Name>
</Name>
</PivotItem>
</PivotField>
<PivotField>
<Name>WebsiteURL</Name>
</PivotField>
<PivotField>
<Name>PlacementName</Name>
</PivotField>
<PivotField>
<Name>CreativeName</Name>
</PivotField>
<PivotField>
<Name>TotalVisits</Name>
</PivotField>
<PivotField>
<Name>Clicks</Name>
</PivotField>
<PivotField>
<Name>Spend</Name>
</PivotField>
<PivotField>
<Name>ActivityDate</Name>
<Orientation>Row</Orientation>
<Position>2</Position>
<DataType>Date</DataType>
<NumberFormat>m/d/yyyy;@</NumberFormat>
<PivotItem>
<Name>
</Name>
</PivotItem>
</PivotField>
<PivotField>
<Name>Year</Name>
</PivotField>
<PivotField>
<Name>Quarter</Name>
</PivotField>
<PivotField>
<Name>Month</Name>
</PivotField>
<PivotField>
<Name>Day</Name>
</PivotField>
<PivotField>
<Name>Hour</Name>
<Orientation>Row</Orientation>
<Position>3</Position>
<DataType>Integer</DataType>
<PivotItem>
<Name>
</Name>
</PivotItem>
</PivotField>
</PivotTable>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<Table ss:ExpandedColumnCount="14" ss:ExpandedRowCount="43"
x:FullColumns="1" x:FullRows="1">
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<Panes>
<Pane>
<Number>3</Number>
<ActiveCol>14</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<PivotCache xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
<CacheIndex>1</CacheIndex>
<Schema s:id="RowsetSchema"
xmlns="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882">
<ElementType s:name="row" s:content="eltOnly">
<extends s:type="rs:rowbase" />
<attribute s:type="Col1" />
<attribute s:type="Col2" />
<attribute s:type="Col3" />
<attribute s:type="Col4" />
<attribute s:type="Col5" />
<attribute s:type="Col6" />
<attribute s:type="Col7" />
<attribute s:type="Col8" />
<attribute s:type="Col9" />
<attribute s:type="Col10" />
<attribute s:type="Col11" />
<attribute s:type="Col12" />
<attribute s:type="Col13" />
</ElementType>
<AttributeType s:name="Col1" rs:name="PublisherName" xmlns="" />
<AttributeType s:name="Col2" rs:name="WebsiteURL" xmlns="" />
<AttributeType s:name="Col3" rs:name="PlacementName" xmlns="" />
<AttributeType s:name="Col4" rs:name="CreativeName" xmlns="" />
<AttributeType s:name="Col5" rs:name="TotalVisits" xmlns="" />
<AttributeType s:name="Col6" rs:name="Clicks" xmlns="" />
<AttributeType s:name="Col7" rs:name="Spend" xmlns="" />
<AttributeType s:name="Col8" rs:name="ActivityDate" xmlns="">
<datatype dt:type="Date" />
</AttributeType>
<AttributeType s:name="Col9" rs:name="Year" xmlns="" />
<AttributeType s:name="Col10" rs:name="Quarter" xmlns="" />
<AttributeType s:name="Col11" rs:name="Month" xmlns="" />
<AttributeType s:name="Col12" rs:name="Day" xmlns="" />
<AttributeType s:name="Col13" rs:name="Hour" xmlns="">
<datatype dt:type="Integer" />
</AttributeType>
</Schema>
<data xmlns="urn:schemas-microsoft-com:rowset">
<row Col1="True.com" Col2="2006-08-16T00:00:00-05:00" Col3="14"
Col5="0" Col6="0.37" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-16T00:00:00-05:00" Col3="15"
Col5="0" Col6="0.05" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-16T00:00:00-05:00" Col3="15"
Col5="0" Col6="0.12" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-16T00:00:00-05:00" Col3="17"
Col5="0" Col6="0.11" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-16T00:00:00-05:00" Col3="18"
Col5="0" Col6="0.30" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="12"
Col5="0" Col6="0.02" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="13"
Col5="0" Col6="0.10" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="14"
Col5="0" Col6="166.75" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="13"
Col5="1" Col6="1.52" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="13"
Col5="0" Col6="1.35" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="13"
Col5="0" Col6="0.67" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="14"
Col5="0" Col6="0.37" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="13"
Col5="0" Col6="0.56" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="14"
Col5="0" Col6="0.35" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="14"
Col5="0" Col6="15.20" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-21T00:00:00-05:00" Col3="12"
Col5="0" Col6="0.24" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-22T00:00:00-05:00" Col3="10"
Col5="0" Col6="0.04" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-17T00:00:00-05:00" Col3="14"
Col5="0" Col6="15.68" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-21T00:00:00-05:00" Col3="12"
Col5="0" Col6="0.24" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-22T00:00:00-05:00" Col3="10"
Col5="0" Col6="0.02" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-22T00:00:00-05:00" Col3="13"
Col5="0" Col6="0.02" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="13"
Col5="0" Col6="0.40" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="14"
Col5="0" Col6="0.07" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="15"
Col5="0" Col6="0.01" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-02T00:00:00-05:00" Col3="16"
Col5="0" Col6="1.74" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-16T00:00:00-05:00" Col3="12"
Col5="0" Col6="0.00" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-21T00:00:00-05:00" Col3="14"
Col5="0" Col6="5.73" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="7"
Col5="0" Col6="0.01" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="8"
Col5="1" Col6="0.51" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="9"
Col5="0" Col6="0.10" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="13"
Col5="0" Col6="0.41" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="14"
Col5="1" Col6="0.06" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-01T00:00:00-05:00" Col3="15"
Col5="0" Col6="0.01" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-02T00:00:00-05:00" Col3="11"
Col5="0" Col6="1.88" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-06-02T00:00:00-05:00" Col3="16"
Col5="0" Col6="1.81" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-08-21T00:00:00-05:00" Col3="14"
Col5="0" Col6="2.91" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-05-11T00:00:00-05:00" Col3="14"
Col5="0" Col6="0.03" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-05-12T00:00:00-05:00" Col3="8"
Col5="0" Col6="0.00" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-05-12T00:00:00-05:00" Col3="12"
Col5="1" Col6="0.00" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-05-12T00:00:00-05:00" Col3="15"
Col5="0" Col6="0.00" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-05-15T00:00:00-05:00" Col3="11"
Col5="0" Col6="0.01" xmlns="#RowsetSchema" />
<row Col1="True.com" Col2="2006-05-15T00:00:00-05:00" Col3="12"
Col5="0" Col6="0.00" xmlns="#RowsetSchema" />
</data>
</PivotCache>
</Workbook>

I figure there may be one or two people familiar with the pivot table
schema that might be able to spot the problem. I appreciate any help
anyone can offer.

Paul
pnschofield+at+yahoo+dot+com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top