Hello,
I wish to store my company data in xml format. I use Office 2007 and tried to generate xml from Microsoft Excel.
But when I try to generate xml the following error message appear.
All other functionality of Excel is just fine except about XML.
If you know the solution please let me know.
Application Error
There was an error in creating XML file
Object reference not set to an instance of an object.
Wishes,
Miller
There was an error in creating XML file
Dear Miller Stone,
I read your question very carefully. This is a general error message, make sure that xml document only contains an only single root element. This issue has come from the primary attribute is null and it should not be null.check it
You can use both Xmxxx.Save (string) and Xmlxxx.InnerXml to view the XML.
I'll give a useful xslt code to transform an Excel Worksheet into a nice XML file.Â
Please visit this site to get it.
More information here:
There was an error in creating XML file
This problem usually occurs when there is some reference to a location where the value is null.
You can diagnose this by any of the following way,
Solution 1: You should check the line to which the reference is null. Null Reference Exceptions are normally easy to diagnose. After finding the line where the reference is null, assign some value to that particular location.
Solution 2: Check the base settings files in the location where Microsoft Excel have been installed and delete these files;
-
BaseSettings.xml
-
Plugincache.xml
-
Usersettings.xml
Then restart the program and your issue will be diagnosed.
