Hello All, I am running following simple script on perl64 to generate chart on excel but I am getting following errors without generating any chart. It opens excel sheet, write data into sheet but no chart.
Win32::OLE(0.1709) error 0x80020003: "Member not found" in PROPERTYPUT "ChartType" at C:\path\test.pl line 20. Here is my system spec PERL version : Perl 64 v5.16.3 WIN32 OLE : 0.1709 Excel Version : Excel 2007 SP3 Can anyone please give me some input on how I can remove this error and generate chart ? Thank you, ======================Script ======================= use strict; use Win32::OLE; use Win32::OLE::Const 'Microsoft Excel'; my $Excel = Win32::OLE->new("Excel.Application"); $Excel->{Visible} = 1; $Win32::OLE::Warn = 3; my $Book = $Excel->Workbooks->Add; my $Sheet = $Book->Worksheets(1); my $Range = $Sheet->Range("A2:C7"); $Range->{Value} = [['Delivered', 'En route', 'To be shipped'], [504, 102, 86], [670, 150, 174], [891, 261, 201], [1274, 471, 321], [1563, 536, 241]]; my $Chart = $Excel->Charts->Add; $Chart->{ChartType} = xlAreaStacked; $Chart->SetSourceData({Source => $Range, PlotBy => xlColumns}); $Chart->{HasTitle} = 1;
_______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs