Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Using Perl to go from XML to EXCEL

by mlaursen (Initiate)
on Mar 17, 2011 at 17:40 UTC ( [id://893816]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    use Spreadsheet::WriteExcel::Big;
    use XML::SAX::ExpatXS;
    ...
    $parser = XML::SAX::ExpatXS->new( Handler => $handler );
    $parser->parse_uri($file);
    
  2. or download this
    perl /vweb/cl2000/docs/targift/xml/targift_card_sales_rpt_MARKL.pl
    Created workbook /proddata/coll/targift/ftp/TARGIFT_CARDSALES_RPT_0317
    +11_1235.xls
    unclosed token at line 2191, column 3, byte 32765 at /vweb/cl2000/docs
    +/targift/xml/targift_card_sales_rpt_MARKL.pl line 55
    
  3. or download this
    <ROW>
      <COL1 >T1500</COL1>
    ...
      <COL3 >50</COL3>
    </ROW>
    <ROW>
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://893816]
Approved by philipbailey
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (2)
As of 2024-04-20 06:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found