GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  XML::SAXDRIVER::EXCEL (3)

.ds Aq ’

NAME



  XML::SAXDriver::Excel - SAXDriver for converting Excel files to XML



CONTENTS

SYNOPSIS



    use XML::SAXDriver::Excel;
    my $driver = XML::SAXDriver::Excel->new(%attr);
    $driver->parse(%attr);



DESCRIPTION



  XML::SAXDriver::Excel was developed as a complement to
  XML::Excel, though it provides a SAX interface, for
  gained performance and efficiency, to Excel files. 
  Specific object attributes and handlers are set to
  define the behavior of the parse() method.  It does
  not matter where you define your attributes.  If they
  are defined in the new() method, they will apply to
  all parse() calls.  You can override in any call to
  parse() and it will remain local to that function call
  and not effect the rest of the object.



XML::SAXDriver::Excel properties



  Source - (Reference to a String, ByteStream, SystemId)
 
    String - **currently not supported** Contains literal Excel data.
             Ex (Source => {String => $foo}) 
     
    ByteStream - **currently not supported** Contains a filehandle reference. 
                 Ex. (Source => {ByteStream => \*STDIN})
     
    SystemId - Contains the path to the file containing
               the Excel  data. Ex (Source => {SystemId => ../excel/foo.xls})
     
 
  Handler - Contains the object to be used as a XML print handler
 
  DTDHandler - Contains the object to be used as a XML DTD handler. 
               ****There is no DTD support available at this time. 
               Ill make it available in the next version.****
 
  SubChar - Specifies the character(s) to use to substitute illegal chars in xml tag names, that
            will be generated from the first row, but setting the Dynamic_Col_Headings.             
              
  Col_Headings - Reference to the array of column names to be used for XML tag names.
 
  Dynamic_Col_Headings - Should be set if you want the XML tag names generated dynamically
                         from the first row in Excel file.  **Make sure that the number of columns
                         in your first row is equal to the largest row in the document.  You
                         dont generally have to worry about if you are submitting valid Excel
                         data, where each row will have the same number of columns, even if
                         they are empty.
                          
  Headings_Handler - Should be used along with Dynamic_Col_Headings to provide a heading
                     normalization handler, to conform the headings to the XML 1.0
                     specifications.  If not provided, a default will be used that only
                     works with ASCII chars, therefore any other character sets need to
                     provide a custom handler!  The handler sub will be passed the heading
                     string as the first argument.



AUTHOR

Ilya Sterin (isterin@cpan.org)

SEE ALSO

XML::Excel Spreadsheet::ParseExcel
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 EXCEL (3) 2016-03-17

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.