This article seems to do what you want:
http://aspn.activestate.com//ASPN/Reference/Products/ActivePerl/faq/Windows/
ActivePerl-Winfaq12.html#save_chart


Regards

Steve
-----Original Message-----
From: Richard Lippmann [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, February 02, 2002 11:51 AM
To: [EMAIL PROTECTED]
Subject: OLE/Excelgraphics to BMP in Perl?


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
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe:
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-admin


                Email Disclaimer

The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee.  Access to this email by anyone else 
is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution 
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful.  When addressed to our clients any opinions or advice
contained in this email are subject to the terms and conditions expressed in 
the governing KPMG client engagement letter.

_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/listinfo/perl-win32-admin

Reply via email to