There was an error in creating XML file

Asked By Miller Stone 0 points N/A Posted on - 10/09/2011

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

• Status: Open
• Question Views: 1336
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by marsh watson

Go To Solution

Answered By Mundo Villaro 0 points N/A #90321

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:

About Mundo Villaro

Questions
1

Answers
38

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 08/30/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By marsh watson 0 points N/A #90322

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.

About marsh watson

Questions
2

Answers
108

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 12/07/2012
• Question Category: MS Excel