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
Post a Comment