• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

Excel and XML exporting

I have the attached xml file that I uploaded that I attempted to import and source into excel.  It loads but does not allow me to save or export as an xml file.

can someone assist or modify the file to work?
A47162-DeductiblePaymentsInfoCon.xml
0
RDLFC
Asked:
RDLFC
  • 2
  • 2
1 Solution
 
Steven HarrisPresidentCommented:
Which version of Excel?

How are you trying to save the file?

After import, I can Save As: XML Spreadsheet 2003 with no issues.
0
 
RDLFCAuthor Commented:
I tried it with 2013 and 2007.  Do you know what limits the schema to working only with 2003?
0
 
Steven HarrisPresidentCommented:
When I open the file, I am warned that there is no schema data, so Excel is creating the schema on it's own.  While I am not an expert with XML, I do know that when his issue arises, you can save in XML Spreadsheet 2003 format but no XML Data format.
0
 
RDLFCAuthor Commented:
was not exactly what i was looking for.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now