title: Best tools to create valid XML files from an Excel file
body: <p>I need to create a script that extracts some data from a complex Excel 2003 file (with multiple sheets and different tables inside a single sheet) and produces different XML files that need to be validated against a given XSD file.</p>
  
  <p>My preferred language is Python;
  to create and validate XML files i would go with <a href="http://codespeak.net/lxml/" rel="nofollow noreferrer">lxml</a>.<br>
  What do you suggest for parsing XLS files?<br>
  Is <a href="http://www.lexicon.net/sjmachin/xlrd.htm" rel="nofollow noreferrer">xlrd</a> the right tool to use for complex Excel files?<br>
  Or do i need to convert all the sheets in CSV manually, and read files line by line, splitting and getting data?</p>
  
  <p>I accept C#, VB6, VBA suggestions too.</p>