Export pivot table to Excel gives error: missing tag row (with an unwanted tag INSERT) -


i building wpf application uses owc pivot table display data. when click built-in button export pivot table excel, writes log file such error message:

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 

when open pivottable71147_cachedata.xml file, looks 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 not expert on pivot table format, here in example there indeed 2 rows inserted, have row data (recid column element). , compared online .xml example, schema rs:data schema, seems element not supposed there, i.e., should directly have multiple elements children elements. why have rs:insert ?

updated:

in example using owc11. should try owc10 instead (or because version mismatch)? because in 1 of our ms access application using owc10 , export excel function works fine. have problem using owc10 in .net.


Comments

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

SVG stroke-linecap doesn't work for circles in Firefox? -

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -