Klaus Eichner > Win32-Scsv-0.06 > Win32::Scsv

Download:
Win32-Scsv-0.06.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 0.06   Source   Latest Release: Win32-Scsv-0.14

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], ['A:D' => 3]],
      'fmt'  => [['A:A' => '#,##0.000'], ['B:B' => '\\<@\\>'], ['C:C' => 'dd/mm/yyyy hh:mm:ss']],
      'prot' => 1,
    });

    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

syntax highlighting: