Hi George,
What I do is to explore the XML file. I added a program that will expand the xml code to be one instruction per line. It also indent the code for easy reading. It is a windows VB6 program, so good luck to run it on Win8 or Win7. Set you User Account Control level to allow you to run it. Rename the .txt output back to an .xml and then try to open the XML. It sould give you a line number of the error. This help me to find the bugs. Mostly it is unicode characters in the data. Sometimes I create a sample spreadsheet and save it as an XML document. Then parse it trought the ExpandXML program and the explore the code. SUBROUTINE UNICODE(MYSTRING) **---------------------------------------------------------------------------- * AUTHOR: Christo Van Rooyen * DATE: 06/08/2008 * **---------------------------------------------------------------------------- *** CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "&" , "&" , MYSTRING) *** CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "<" , "<" , MYSTRING) *** CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( ">" , ">" , MYSTRING) *** CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( CHAR(34) , """ , MYSTRING) *** CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "'" , "'" , MYSTRING) **---------------------------------------------------------------------------- CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "&" , "\&" , MYSTRING) CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "<" , "\<" , MYSTRING) CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( ">" , "\>" , MYSTRING) CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( '"' , '\"' , MYSTRING) CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "'" , "\'" , MYSTRING) RETURN **---------------------------------------------------------------------------- Groete, Regards, Christo van Rooyen GT - Systems Analyst / Designer II Nedbank Ltd Mobile: +27 82 925 6301 Office: +2712 436 7264 Location: MenLyn Maine Pretoria - 3'rd Floor - Desk 265 -----Original Message----- From: George Gallen [mailto:[email protected]] Sent: 24 March 2014 08:00 PM To: U2 Users Subject: [U2] SpreadsheetML and Excel2013 Is anyone else having issues with Excel2013 giving errors to previously working XML files from Excel2003 It keeps telling me there is an error in the table, and says there is log file, which is blank - not helpful. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator [email protected]<mailto:[email protected]> ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com<http://www.wyanokegroup.com/<http://www.wyanokegroup.com%3chttp:/www.wyanokegroup.com/>> ******************** Nedbank Limited Reg No 1951/000009/06. The following link displays the names of the Nedbank Board of Directors and Company Secretary. [ http://www.nedbank.co.za/terms/DirectorsNedbank.htm ] This email is confidential and is intended for the addressee only. The following link will take you to Nedbank's legal notice. [ http://www.nedbank.co.za/terms/EmailDisclaimer.htm ] ********************
_______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
