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:
Code:
There was a problem sending the command to the program.
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:
Error processing schema for file 'C:\Users\israejr\Desktop\junk.xml'.
File 'C:\Users\israejr\Desktop\urn:schemas-microsoft-com:office:Spreadsheet' not found
It then gives me the following in a debugging/output window:
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
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.
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.