Another quick way (if your on windows) to explore the XML - is save the file to your desktop (or wherever), Give it an .xml extension.
Then open IE - and (f)ile - Open and then open the file If it opens it's valid as XML goes - I don't know if you reference a schema inside, if IE will then load The schema and validate the XML against it - didn't try that. George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Van Rooyen, C. (Christo) Sent: Tuesday, March 25, 2014 2:32 AM To: U2 Users List Subject: [U2] [WARNING : MESSAGE ENCRYPTED]RE: SpreadsheetML and Excel2013 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:ggal...@wyanokegroup.com] 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 ggal...@wyanokegroup.com<mailto:ggal...@wyanokegroup.com> 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
