NAME

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

SYNOPSIS

use Win32::Scsv qw(xls_2_csv csv_2_xls empty_xls get_xver);

xls_2_csv('Test Excel File.xlsx%Tabelle3' => 'dummy.csv');
xls_2_csv('Test Excel File.xlsx%Tabelle Test');

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

empty_xls('abc.xls');
empty_xls('def.xlsx');

my ($ver, $product) = get_xver;

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