use strict;
use Win32::OLE qw(in with);
use Win32::OLE::Const;
use Win32::OLE::Const 'Microsoft Excel';
use CGI::Pretty qw/:standard *table *th *Tr/;
use MySubs;

my $name="SPACEd Graph";
my $TIME = localtime($^T);

$Win32::OLE::Warn = 3;        # die on errors...

my $filename = 'd:\bin\scripts\perlscripts\spaced\log.csv';
my $filter = 'PNG';           # can be GIF, JPG, JPEG or PNG
my $count = 0;

my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32:
+:OLE->new('Excel.Application', 'Quit');  # use the Excel application 
+if it's open, otherwise open new

$Excel->{Visible} = 0;

my $Book = $Excel->Workbooks->Open( $filename );      # open the file
my $Sheet = $Book->Worksheets(1);
my $Range = $Sheet->Range('A:A,C:C');

my $Chart = $Excel->Charts->Add;
$Chart->{ChartType} = xlAreaStacked;
$Chart->SetSourceData({Source => $Range, PlotBy => xlColumns});

$Chart->{HasLegend} = 0;
$Chart->{HasTitle} = 1;
$Chart->ChartTitle->{Text} = "Free Space in Megabytes on \\\\SERVER\\S
+HARE\n$TIME";

my $savename = 'd:\inetpub\wwwroot\spacedgr\graph.'.$filter;
$Chart->Export($savename, $filter, 0);

$Book->Close(0);

print header;
print start_html(-title=>"$name",
                    -author=>'martin_bowers@avcofinance.com.au',
                    -base=>'true',
                    -meta=>{'keywords'=>'menu',
                    'copyright'=>'copyright 2000 Marty'},
                    -style=>{'src'=>'/style.css'},
                    -dtd);

print h1($name,br,font({-size=>3},"by Martin Bowers"),hr);

print img({src=>'graph.png'});


print end_table, br, hr, &COUNTER, end_html;
[download]