Altova Mailing List Archives


Re: Problems importing, editing and exporting xml to excel and back

From: hegisin <hegisin@-----.--->
To: NULL
Date: 8/22/2007 9:04:00 AM

The xml.data file that I want to edit is not my own but from a
software that I'm running. So they have to use a schema but I don't
know which one it is. I'm really new to xml. Isnt' the start of the
xml file that I have mentioned in my first post a reference to the
schema?

On Aug 22, 4:08 pm, "Joe Fawcett" <joefawc...@newsgroup.nospam> wrote:
> Do you have a schema that you can import into Excel?
> (Added office.xml to the follow up)
>
> --
>
> Joe Fawcett (MVP - XML)
>
> http://joe.fawcett.name
>
> "hegisin" <hegi...@gmail.com> wrote in message
>
> news:1187768674.896314.184350@j......
>
>
>
> > Hi,
>
> > I need to edit an existing xml file in excel and then save it again as
> > an xml data file.
>
> > When I import the xml file into excel I get the following error
> > message:
>
> > 1.) The specified xml source does not refer to a schema. Excel will
> > create a schema based on the xml source data
> > 2.) Excel encountered problems when importing the following file:
> >     Error: some data was imported as text
>
> > However, after that the spreadsheet looks exactly as I want it to look
> > and I can edit the data.
>
> > However, when I try to save the file as an xml file I get another
> > error message: "XML maps in this workbook are not exportable"
>
> > If I go to "verify map for export", I get the following:
>
> > - list of lists
> > - denormalized data
> > - a mapped element's relationship with other elements cannot be
> > preserved
>
> > Further information: the original xml file starts like that"
>
> > <?xml version="1.0" encoding="utf-8"?>
> > <Engine xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema">
>
> > I appreciate any help on this.
>
> > Cheers,
> > bamthwok- Hide quoted text -
>
> - Show quoted text -


Disclaimer

These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.