NAME

Win32::Scsv - Convert from and to *.xls, *.csv using Win32::OLE

SYNOPSIS

    use Win32::Scsv qw(set_handle_ole xls_2_csv xls_all_csv);

    set_handle_ole;

    xls_2_csv('Test1.xls'     => 'dummy.csv');
    xls_2_csv('Abc.xls%Tab01' => 'data01.csv', { cpy => 'all' });          # copy values *AND* format...
    xls_2_csv('Abc.xls%Tab02' => 'data02.csv', { cpy => 'val' });          # copy only values...
    xls_2_csv('Abc.xls%Tab03' => 'data03.csv');                            # ...same as { cpy => 'val' }, which is the default...
    xls_2_csv('Abc.xls%Tab04' => 'data04.csv', { rmc => [ 'CR', 'LF' ] }); # remove CRLF from all cells...
    xls_2_csv('Abc.xls%Tab05' => 'data05.csv', { clc => 1 });              # force recalculation...

    xls_all_csv('Abc.xls' => 'result_*.csv', { cpy => 'all' });            # copy all sheets in one operation...

    csv_2_xls('dummy.csv' => 'New.xlsx%Tab9', {
      'tpl' => 'Template.xls',
      'prt' => 1,
      'csz' => [
         ['H:H' => 13.71],
         ['A:D' => 3],
      ],
      'fmt'  => [
         ['A:A' => '#,##0.000'],
         ['B:B' => '\\<@\\>'],
         ['C:C' => 'dd/mm/yyyy hh:mm:ss'],
      ],
    });

AUTHOR

Klaus Eichner <klaus03@gmail.com>

COPYRIGHT AND LICENSE

Copyright (C) 2009-2011 by Klaus Eichner

All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the artistic license 2.0, see http://www.opensource.org/licenses/artistic-license-2.0.php