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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
