Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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:"m\/d\/yyyy\;\@"" <PTRule <RuleTypeButton</RuleType <RuleActivity Date</Rule <ParseRuleAsV10 / </PTRule </PTFormat <PTFormat Style="mso-number-format:"m\/d\/yyyy\;\@"" <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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create an automatic generated number for a spreadsheet | Excel Discussion (Misc queries) | |||
Error Generated from Array formula | Excel Programming | |||
PivotTable - PivotTable Field name is not valid - error! | Excel Programming | |||
Refresh a PivotTable using VBA (SQL generated Pivot) | Excel Programming |