[kw-pm] Another Excel related question...

[Daniel R. Allen]

Robert,

My guess at this point is that nobody on the kw.pm list has experience to
share on Perl interaction with Excel under Win32::OLE, since there haven't
been any responses to your posts.

The standard first recommendation (since your questions suggest you've
been going it alone until now) is to read the manpages and do a few web
searches.  For excample, I just googled for 'Win32::OLE excel'.  One link
that stands out as potentially useful is from PerlMonks, an excellent
resource for all Perl programmers, if you haven't visited that site
before.

"Using Win32::OLE and Excel - Tips and Tricks"
http://www.perlmonks.org/?node=153486

In a quick look, it seems they mention turning off warning dialogs, which
I believe was one of your questions.

If that doesn't satisfy fully, you might try locating an email list
specific to Win32::OLE, or perhaps a list for ActiveState or Cygwin Perl
(whichever kind of Perl you're using).

I'm not sure if part of the problem you're having is with wrapping your
head around Perl Object Oriented code?  That can be one of the early
stumbling-blocks for people familiar with other languages.  If so, I
recommend the book "Learning Perl Objects, References & Modules."  We have
a copy in our Lending Library, which you're welcome to borrow for a month.
Let me know, and I can bring it tomorrow evening.

Also, we're happy to answer questions about OO Perl- unfortunately, the
best I can do for your questions is to recommend other sources...

Hope that was marginally helpful,
-Daniel
--
http://coder.com/ - Prescient Code Solutions - (519) 575-3733 da at coder.com
http://kw.pm.org/ - Kitchener-Waterloo Perl Mongers -         da at kw.pm.org

On Wed, 14 Dec 2005, Robert Pike wrote:

> ... .Labels.Add(591132.75, 14185.5, 5481996,
> 247704.75).Select
> Selection.ShapeRange.ScaleHeight 0.74, msoFalse,
> msoScaleFromTopLeft
> ActiveChart.Shapes("Label 1").Select
> Selection.Characters.Text = "Label 1"
> Selection.Characters.Text = "Main Label"
>
> Up until working on this application most of the perl
> coding I have done has been pretty basic. If my chart
> reference is called $swChart how can the previous
> lines be converted to Perl code? Basically this
> section of code should add a label to the chart I have
> created but I'm having difficulty converting the first
> 3 lines (mainly) to Perl. I know the -> replaces the
> periods in most cases but a few of these lines I've
> tried converting and they just don't seem to work. Any
> help would be appreciated. Thanks.
>
> Rob