ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XML ERROR in PivotTable on generated XML spreadsheet (https://www.excelbanter.com/excel-programming/376693-xml-error-pivottable-generated-xml-spreadsheet.html)

[email protected]
XML ERROR in PivotTable on generated XML spreadsheet
 
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"
<AuthorPaul Schofield</Author
<LastAuthorPaul Schofield</LastAuthor
<Created2006-10-24T17:36:30Z</Created
<LastSaved2006-10-31T20:30:56Z</LastSaved
<Companytrue.com</Company
<Version11.8107</Version
</DocumentProperties
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"
<WindowHeight15585</WindowHeight
<WindowWidth19995</WindowWidth
<WindowTopX480</WindowTopX
<WindowTopY105</WindowTopY
<ProtectStructureFalse</ProtectStructure
<ProtectWindowsFalse</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:office:excel"
<Selected /
<Panes
<Pane
<Number3</Number
<ActiveRow3</ActiveRow
<ActiveCol4</ActiveCol
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
<PivotTable xmlns="urn:schemas-microsoft-com:office:excel"
<NamePivotTable3</Name
<ImmediateItemsOnDrop /
<ShowPageMultipleItemLabel /
<LocationR1C1:R25C5</Location
<VersionLastUpdate2</VersionLastUpdate
<DefaultVersion1</DefaultVersion
<PTSource
<CacheIndex1</CacheIndex
<VersionLastRefresh2</VersionLastRefresh
<RefreshNamePaul Schofield</RefreshName
<RefreshDate2006-11-01T11:49:05</RefreshDate
<RefreshDateCopy2006-11-01T11:49:05</RefreshDateCopy
<ConsolidationReference
<FileName[Template xml spreadsheet.xml]Sheet2</FileName
<ReferenceR1C1:R43C14</Reference
</ConsolidationReference
</PTSource
<PTFormat Style="mso-number-format:&quot;m\/d\/yyyy\;\@&quot;"
<PTRule
<RuleTypeButton</RuleType
<RuleActivity Date</Rule
<ParseRuleAsV10 /
</PTRule
</PTFormat
<PTFormat Style="mso-number-format:&quot;m\/d\/yyyy\;\@&quot;"
<PTRule
<RuleTypeLabelOnly</RuleType
<Rule'Activity Date'[All]</Rule
<ParseRuleAsV10 /
</PTRule
</PTFormat
<PTFormat Style="text-align:center"
<PTRule
<RuleTypeButton</RuleType
<RuleActivity Date</Rule
<ParseRuleAsV10 /
</PTRule
</PTFormat
<PivotField
<NamePublisherName</Name
<OrientationColumn</Orientation
<Position1</Position
<PivotItem
<Name
</Name
</PivotItem
</PivotField
<PivotField
<NameWebsiteURL</Name
</PivotField
<PivotField
<NamePlacementName</Name
</PivotField
<PivotField
<NameCreativeName</Name
</PivotField
<PivotField
<NameTotalVisits</Name
</PivotField
<PivotField
<NameClicks</Name
</PivotField
<PivotField
<NameSpend</Name
</PivotField
<PivotField
<NameActivityDate</Name
<OrientationRow</Orientation
<Position2</Position
<DataTypeDate</DataType
<NumberFormatm/d/yyyy;@</NumberFormat
<PivotItem
<Name
</Name
</PivotItem
</PivotField
<PivotField
<NameYear</Name
</PivotField
<PivotField
<NameQuarter</Name
</PivotField
<PivotField
<NameMonth</Name
</PivotField
<PivotField
<NameDay</Name
</PivotField
<PivotField
<NameHour</Name
<OrientationRow</Orientation
<Position3</Position
<DataTypeInteger</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:office:excel"
<Panes
<Pane
<Number3</Number
<ActiveCol14</ActiveCol
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
<PivotCache xmlns="urn:schemas-microsoft-com:office:excel"
<CacheIndex1</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


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com