I am building an XML file that I wish to open with Excel. This file will have all kinds of formatting built into it so that the user simply opens the file and they are ready to go. I am building a test version of this file in Windows on my Desktop, but it will ultimately be built on a UNIX box and E-mailed to one or more users. I have gotten it to open and display correctly in Excel, but I am getting some errors along the way.
Double-clicking on the XML file opens it in Excel, but I also get a pop-up window with the following error:
I am using SlickEdit as my editor (it handles everything we do at my office). When I open the XML file to edit the raw XML file, SlickEdit is giving me a bunch of minor errors. The first is:Code:There was a problem sending the command to the program.
It then gives me the following in a debugging/output window:Code:Error processing schema for file 'C:\Users\israejr\Desktop\junk.xml'. File 'C:\Users\israejr\Desktop\urn:schemas-microsoft-com:office:Spreadsheet' not found
I am new to XML, so I am not sure where I have done wrong. I assume it is in the initial declaration part of the xml file, but I have no clue what it should be.Code:File C:\Users\israejr\Desktop\junk.xml 8 47: Error Unknown element 'ss:Workbook' 8 47: Error Attribute 'xmlns' is not declared for element 'ss:Workbook' 8 47: Error Attribute '{http://www.w3.org/2000/xmlns/}ss' is not declared for element 'ss:Workbook' 8 47: Error Attribute '{http://www.w3.org/2000/xmlns/}o' is not declared for element 'ss:Workbook' 8 47: Error Attribute '{http://www.w3.org/2000/xmlns/}x' is not declared for element 'ss:Workbook' 8 47: Error Attribute '{http://www.w3.org/2000/xmlns/}html' is not declared for element 'ss:Workbook' 10 72: Error Unknown element 'o:DocumentProperties' 10 72: Error Attribute 'xmlns' is not declared for element 'o:DocumentProperties' 11 12: Error Unknown element 'o:Title' 12 13: Error Unknown element 'o:Author' 13 17: Error Unknown element 'o:LastAuthor' 14 14: Error Unknown element 'o:Company' 17 67: Error Unknown element 'ss:ExcelWorkbook' 17 67: Error Attribute 'xmlns' is not declared for element 'ss:ExcelWorkbook' 18 20: Error Unknown element 'ss:WindowHeight' 19 19: Error Unknown element 'ss:WindowWidth' 20 18: Error Unknown element 'ss:WindowTopX' 21 18: Error Unknown element 'ss:WindowTopY' 22 24: Error Unknown element 'ss:ProtectStructure' 23 22: Error Unknown element 'ss:ProtectWindows' 26 13: Error Unknown element 'ss:Styles' 27 40: Error Illegal sequence '--' in comment
Please tell me what I am doing wrong so that the XML is "clean". Most importantly, I do not want my users getting any error messages when they open a file.Code:<?xml version="1.0" encoding="UTF-8"?> <?mso-application progid="Excel.Sheet"?> <ss:Workbook xmlns="urn:schemas-microsoft-com:office:Spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:html="http://www.w3.org/TR/REC-html40"> <o:DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <o:Title>Sales-Transfer Percentage</o:Title> <o:Author>Me</o:Author> <o:LastAuthor>Me</o:LastAuthor> <o:Company>CompanyName</o:Company> </o:DocumentProperties> <ss:ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <ss:WindowHeight>9000</ss:WindowHeight> <ss:WindowWidth>13000</ss:WindowWidth> <ss:WindowTopX>480</ss:WindowTopX> <ss:WindowTopY>105</ss:WindowTopY> <ss:ProtectStructure>False</ss:ProtectStructure> <ss:ProtectWindows>False</ss:ProtectWindows> </ss:ExcelWorkbook>
Thanks


Reply With Quote

Bookmarks