topic Re: Error In Exportting Excel by XML. in Application Development and Automation Discussions

Error In Exportting Excel by XML.

Former Member — Wed, 03 Jun 2009 09:15:20 GMT

Hi All,

I want to export program to Excel. I use XML. In the Program not all error but when I print to be error. Log fie always raise:

"XML PARSE ERROR: Missing end-tag

Error occurs at or below this element stack:

<ss:Workbook>

<ss:Worksheet>

<ss:Table>

<ss:Row>

<ss:Cell>

<ss:Data>" but I search every line not Missing end~tag.

I print some program of my colleague what they print successfully but I can't. Log file raise the error same above.

I don't know why. Help me.

Thank you so much.

Former Member — Wed, 03 Jun 2009 09:27:51 GMT

Hi ,

i guess there is some problem in the way u making the xml structure .. the end tags have "/"

<ss:Workbook>

<ss:Worksheet> </ss:worksheet>

</ss:Workbook>

Regards

Renu

Former Member — Wed, 03 Jun 2009 09:54:55 GMT

When I add "ss:" to </workbook> and </styles>, program raise :

"XML PARSE ERROR: Undefined namespace

Error occurs at or below this element stack:

<ss:Workbook>

<ss:STYLES>". Program can't print to Excel.

Help me.

Former Member — Tue, 20 Oct 2009 15:34:38 GMT

I am assuming you are doing a Excel in tabulation style. If it is. Here is what I found you need to do

Look for following segment;

(Beginning of <TABLE> section)

<Table ss:ExpandedColumnCount="9" ss:ExpandedRowCount="5862" x:FullColumns="1" x:FullRows="1" ss:DefaultRowHeight="15">

where 9 is the maximum number of columns in your table and 5862 is the number of rows.

These two numbers must be right.