Hi. I received your email. I am out of the office from Friday, August 25, 2006 through Friday, September 15, 2006. I will respond to emails and voicemails when I return. If you need assistance before then, please contact Janice Albert.
Thank you, Steve >>> perl-win32-users 08/25/06 12:00 >>> Send Perl-Win32-Users mailing list submissions to perl-win32-users@listserv.ActiveState.com To subscribe or unsubscribe via the World Wide Web, visit http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of Perl-Win32-Users digest..." Today's Topics: 1. Re: [OLE] Excel - problem creating multiple charts (Lyndon Rickards) ---------------------------------------------------------------------- Message: 1 Date: Thu, 24 Aug 2006 20:25:16 -0400 From: Lyndon Rickards <[EMAIL PROTECTED]> Subject: Re: [OLE] Excel - problem creating multiple charts To: rob johnson <[EMAIL PROTECTED]> Cc: perl-win32-users@listserv.activestate.com Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed rob johnson wrote: > Hi > > I am having a difficult time getting Excel automation to work > correctly. specifically, i've become hung up on creating multiple > charts. > > I am able to make a basic XY Scatter plot with the following code: > > ================================== > $Sheet->Range("A:A,D:D,K:K,R:R")->Select; > $Chart = $Book->Charts->Add; > $Chart->{ChartType} = xlXYScatter; > $Chart->{Name}="Temperature"; > ================================== > > and it correctly charts D, K, and R column data (temperatures) versus > the A column data (time) > > but if i want to make another (separate) chart plotting E, L, and S > column data (conductivity) versus the A column data (time), and i > follow the above code with a similar block: > > ================================== > $Sheet->Range("A:A,E:E,L:L,S:S")->Select; > $Chart = $Book->Charts->Add; > $Chart->{ChartType} = xlXYScatter; > $Chart->{Name}="Conductivity"; > ================================== > > it fails, with the following error message > > ==================================================== > OLE exception from "Microsoft Excel": > > Unable to get the Select property of the Range class > > Win32::OLE(0.1704) error 0x800a03ec > in METHOD/PROPERTYGET "Select" at hexconvert.pl line 322 > ==================================================== > > (where line 322 is in the second block: > $Sheet->Range("A:A,E:E,L:L,S:S")->Select; ) > > Can someone point out where I'm going wrong? > > Also, If I could just find a reference of Excel OLE properties and > methods I think I could hack my way through it. But I haven't been > able to find anything like that. > > does anyone know if such a list exists? > > thanks, > rob > > I know I've faced this in the past after converting recorded macro verbatim. I can't easily test a solution based on your example because it is not 'complete and working'... ;-) A couple of things that might help: A snippet of mine that sets a range as source for a chart: $range = "A25:" . $endCol . "26"; $Excel->ActiveSheet->ChartObjects('Chart 1')->Activate(); $Excel->ActiveChart->SetSourceData({Source => $pSheet->Range($range), PlotBy => 2}); As I recall, it is possible to skip the ...Activate line and reference the ChartObjects(...) instead of ActiveChart in the line following it. The VBA editor itself has the Object Browser documentation built-in - right-click in editor pane. Often, pasting the error right into Google yields valuable pointers or solutions. Even though I use perl almost exclusively over VBA I have had excellent method advice from contributors over on microsoft.public.excel.misc. HTH - Lynn. ------------------------------ _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs End of Perl-Win32-Users Digest, Vol 1, Issue 1798 ************************************************* CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication. _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs