I want to create some nice graphics in Excel 97 and save these grahpics as GIF, BMP or
so. Creating the graphics with OLE is easy when I use an existing document, I only
have to change the values in the excel-sheet, the graphic which depends on the cells
changes immediately.
use Win32::OLE;
my $Excel = Win32::OLE->GetActiveObject('Excel.Application');
my $Sheet = $Excel->Application->ActiveSheet();
my $Range = $Sheet->Range("B6:E6");
$Range->{Value} = [ 23, 28, 30, 34 ];
The problem is that I cannot save the graphics in the Excelsheet. Maybe a way is to
copy the graphics into the buffer (ctrl-c) and paste it to some graphics-application
which could save the graphics.
This sounds very strange but I think I can use a lot of windows programms to do the
dirty work and get good graphical good results (diagrams of temperature, generating
nice-looking pdf-files from excel, election-charts from excel).
From Bavaria, Germany
Horshack
--
http://lena.franken.de
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/listinfo/perl-win32-admin
