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

XML files which I need the XSD and XSL for EXCEL maps

I have some XML files which I need the XSD and XSL for EXCEL maps. I usually use Access to create them from the XML.

Any ideas on a quicker method?
0
capturetheflag
Asked:
capturetheflag
  • 3
  • 3
1 Solution
 
capturetheflagAuthor Commented:
Additional Footnote:

I do not have an XSD!

capturetheflag
0
 
Geert BormansInformation ArchitectCommented:
you can use
www.oxygenxml.com
for generating a schema from a collection of XML files

XSLT usually is custom development
(I assume you need to flatten the XML structure a bit for getting an excel table format)

If you are working on the XSLT anyway, and you don't need a databinding, but just the XML import in Excel, you could use the XSLT to transform into a HTML table and import that... I very often take that approach
0
 
capturetheflagAuthor Commented:
No money to buy oxygenxml.

Thanks for the suggestion
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Geert BormansInformation ArchitectCommented:
inside Oxygen it is Trang (open source) that takes care of the functionality
http://www.thaiopensource.com/relaxng/trang.html
Oxygen only serves as the graphical configuration for schema generation

well, you could download an evaluation for a month. That is free
This way you could check wether the approach helps you in a friendly environment.
If you like the Oxygen approach, forget about Oxygen but remeber the configuration settings
and use Trang for free, directly from the command line
0
 
capturetheflagAuthor Commented:
thanks for the help
0
 
Geert BormansInformation ArchitectCommented:
welcome
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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