asked on

How to debug an xml script used for Excel

I'm trying to make an Excel sheet with input from a database using php. When executing the xml (XML sheet 2003) file using Excel I get an error message like

XML-ERROR In Table
REASON:      Erroneous value
(This a translation from Swedish, could be erroneous, inaccurate, wrong, incorrect in Engliish. I don't have the English version an hand)
FILE:      C:\Users\Lennart\Downloads\Matrikel 2011-10-12.xls
GROUP:      Table
HTML-CODE:      Row
ATTRIB:      Index
VALUE:      150

XML-ERROR In Table
REASON:      Erroneous value
FILE:      C:\Users\Lennart\Downloads\Matrikel 2011-10-12.xls
GROUP:      Table
HTML-CODE:      Row
ATTRIB:      Index
VALUE:      155

XML-ERROR In Table
REASON:      Erroneous value
FILE:      C:\Users\Lennart\Downloads\Matrikel 2011-10-12.xls
GROUP:      Table
HTML-CODE:      Row
ATTRIB:      Index
VALUE:      157

XML-ERROR In Table
REASON:      Erroneous value
FILE:      C:\Users\Lennart\Downloads\Matrikel 2011-10-12.xls
GROUP:      Table
HTML-CODE:      Row
ATTRIB:      Index
VALUE:      159

Is there a method to debug the code? Any advice how I could find out what is wrong?

andrewssd3

If this is output from Excel, I think it's from a user macro. If you could post the Excel file and the input xml it would be easier to help.

Lennart Ericson

ASKER

andrewssd3,

I enclose two scripts:
1 - the php script used to get the records from the database and populating the xml file. (There is an error somewhere in this file, thus I can't produce an Excel sheet. )
2 - the xml file created by the php script.

I want to know if there is a method to help finding the error in the php file.
2.xml
1.php

ASKER CERTIFIED SOLUTION

andrewssd3

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Lennart Ericson

ASKER

Stuart,

Right you are, it happily opened in Excel. Thank you so much for your help.

Well done, my friend.

Lennart