XML and Perl

XML::SAXDriver::Excel Perl Module

I’ve demonstrated how to generate XML data from a CSV file. Now, we’re going to look at another SAX-based Perl module, XML::SAXDriver::Excel. As you may have already guessed from the name, this Perl module facilitates the conversion between standard Microsoft Excel spreadsheet files and XML. Why not just save the Microsoft Excel spreadsheet file as CSV and use the Perl module that we discussed in the previous section? Well, you can do that. However, one situation when this module comes in handy is when you have a large number of Microsoft Excel spreadsheet files to convert to XML; this can save you the trouble of converting a large number of files to CSV format. Let’s take a look at an example of how to ...