Re^4: Help using Win32::OLE to add Excel charts having multiple series

in reply to Re^3: Help using Win32::OLE to add Excel charts having multiple series
in thread Help using Win32::OLE to add Excel charts having multiple series

 How to translate following VBA code to perl code 

 Charts.Add
 ActiveChart.ChartType = xlXYScatterSmoothNoMarkers
 ActiveChart.SeriesCollection.NewSeries
 ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!R2C1:R801C1"
 ActiveChart.SeriesCollection(1).Values = "='Sheet1'!R2C2:R801C2"
[download]

Comment on Re^4: Help using Win32::OLE to add Excel charts having multiple series Download Code

Replies are listed 'Best First'.
Re^5: Help using Win32::OLE to add Excel charts having multiple series by Anonymous Monk on Feb 27, 2010 at 00:06 UTC
You take the vbscript code, change dots to arrows, add parens around strings, replace single quotes(') with pound sign (#) ... and you're finished. Win32::OLE The behavior of Win32::OLE->new Using Win32::OLE and Excel - Tips and Tricks http://www.perl.com/pub/a/2005/04/21/win32ole.html, Re: perl library for controlling Windows GUI (like AutoIt) Re: Write to WIndows Event Log Re: How to get location of Desktop folder on Win32 Read and write Windows "shortcut" links Where is the Win32::OLE Docs	[reply]

Replies are listed 'Best First'.

Re^5: Help using Win32::OLE to add Excel charts having multiple series
by Anonymous Monk on Feb 27, 2010 at 00:06 UTC

Win32::OLE
The behavior of Win32::OLE->new
Using Win32::OLE and Excel - Tips and Tricks
http://www.perl.com/pub/a/2005/04/21/win32ole.html,
Re: perl library for controlling Windows GUI (like AutoIt)
Re: Write to WIndows Event Log
Re: How to get location of Desktop folder on Win32
Read and write Windows "shortcut" links
Where is the Win32::OLE Docs

[reply]

In Section Seekers of Perl Wisdom