Error In Exportting Excel by XML.

[Former Member]

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]

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]

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]

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.