NAME
Win32::Scsv - Convert Excel file to CSV using Win32::OLE
SYNOPSIS
use Win32::Scsv qw(xls_2_csv csv_2_xls empty_xls);
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' => 3]],
'fmt' => [['A:A' => '#,##0.000'], ['B:B' => '\\<@\\>'], ['C:C' => 'dd/mm/yyyy hh:mm:ss']],
});
empty_xls('abc.xls');
empty_xls('def.xlsx');
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