himanshu.padmanabhi has asked for the wisdom of the Perl Monks concerning the following question:

Hi Perlmonks, I am using 'Spreadsheet::WriteExcel' module to plot graph reading excel's data.

1) If I used 'type=line',chart shows "cross" like symbols in between.Is there any way to remove this symbols?It doesn't look that good.

2) If not,I used 'type=area',then chart looks good.But I want to also draw 'single horizontal line' in the SAME chart to denote MAX value of Y axis.And 'type=area' plots an area from borders of drawn graph upwards.How I should draw MAX line using 'type=area'?If not,can I use 'type=area'(to plot actual graph) and 'type=line' to plot MAX line in the same chart?

I will be thankful and really appreciate any help in this regard.

  • Comment on Spreadsheet::WriteExcel and type=line/area

Replies are listed 'Best First'.
Re: Spreadsheet::WriteExcel and type=line/area
by jmcnamara (Monsignor) on Aug 16, 2010 at 07:34 UTC

    Neither of these features are currently possible with Spreadsheet::WriteExcel.

    --
    John.

[reply]
Re: Spreadsheet::WriteExcel and type=line/area
by dasgar (Priest) on Aug 16, 2010 at 01:22 UTC

    If you're on a Windows box with Excel installed, I'd recommend that you use Win32::OLE to use Excel directly. You can use the OLE browser that is part of the module as well as recording a macros and looking at source code to help you figure out your tasks. Unfortunately, both will be in VB, so you'll have to convert VB to Perl.

    Basically, I've found that using Win32::OLE, you can use Perl to do just about anything that you can do in Excel manually with a mouse and keyboard, including the things that you're wanting do.

    If you're not on Windows, you might try looking into doing something similar with Open Office.

[reply]
Re: Spreadsheet::WriteExcel and type=line/area
by ww (Archbishop) on Aug 15, 2010 at 23:54 UTC
    I suspect you had best search M$'s archives, help, etc.

    If M$ hasn't enabled what you're looking for, then Perl isn't going to create the capability.

[reply]
      Ohh...that is sad..if perl cannot do it :(
[reply]
        I didn't say "perl can't do it."

        I did say that I believe that you'll have better luck pursuing the answer from MicroSoft (since you have -- I trust -- read S:WE's documentation carefully and followed up with a look at on-line info such as http://homepage.eircom.net/~jmcnamara/perl/WriteExcel.html without finding any clues to implementing your desires).

        I have come to that belief because Spreadsheet::WriteExcel was created to replicate (and AFAICT, is limited to) the internal file-writing capabilities of Excel itself. So investigating M$ for hints about how to use both line styles in one file might well tell you whether W:SE is likely to have that ability.

        Or, of course, the module's author (jmcnamarra) may spot this thread and offer an authoritative answer (and that, of course, may differ substantially from mine).

[reply]
[d/l]

Back to Seekers of Perl Wisdom