Skip to Content
0
Former Member
May 18, 2009 at 05:47 AM

Error while XML deserialization using ST

48 Views

Hi Experts,

I am generating a fancy XML Spreadsheet using Simple Transformation and then trying to read it back using the same ST (deserialization).

While doing so, I am receiving following runtime error:

Error analysis
    An exception occurred that is explained in detail below.
    The exception, which is assigned to class 'CX_ST_MATCH_ELEMENT', was not caught and therefore
 caused a runtime error.
    The reason for the exception is: XML matching error 
    Expected was element-start: "Workbook" [urn:schemas-microsoft-com:office:spreadsheet] 
    Read was document-end: " " [ ].

Althought, the XML contains the same line at line #3 below:

<?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:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Created>2009-05-18T05:28:50Z</Created>
  <LastSaved>2009-05-18T05:28:50Z</LastSaved>
  <Version>11.9999</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

I tried aligning the text / transformation in various ways with no success.

Any clues to tackle this?