OWC11 pivot table export to excel fail: missing tag row (seems to

W

waveletwei

I am using pivot table of OWC11 in a WPF application(hosted by WindowsFormHost control). But when I click the button to export the table to Excel, I got error like this:

XML ERROR in PivotTable

REASON: Missing Tag

ACTION: Aborting current XML group

FILE: C:\Users\MY_NAME\AppData\Local\Temp\PivotTable71147_cachedata.xml

GROUP: PivotCache

TAG: row

And when I opened PivotTable71147_cachedata.xml file, it looks like this:

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
<s:AttributeType name='RecID' rs:number='1' rs:write='true'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='0' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<rs:insert>
<z:row RecID='1'/>
<z:row RecID='2'/>
</rs:insert>
</rs:data>
</xml>

I compared this xml data to some example online(I have to say there are really rare), as well as the schema for rs:data, it seems that the rs:insert element shouldn't be here at all. The examples showed that there should be z:row elements directly under rs:data. But why am I getting this rs:insert element?

As I mentioned I am using OWC11. I don't know whether OWC10 will give the correct data, but I have some problem using OWC10 in .NET, the online tutorial from MS. http://support.microsoft.com/kb/823982, is not working at all

Thanks for any help!
 

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