asMinorGridlines} = 0;
$Graph->Axes(xlSeries)->{HasMajorGridlines} = 1;
$Graph->Axes(xlSeries)->{HasMinorGridlines} = 0;
$Graph->Axes(xlValue)->{HasMajorGridlines} = 1;
$Graph->Axes(xlValue)->{HasMinorGridlines} = 0;
$Graph->Axes(xlValue)->{WallsAndGridlines2D} = 0;
$Graph->
raph->Axes(xlSeries)->{HasMajorGridlines} = 1;
$Graph->Axes(xlSeries)->{HasMinorGridlines} = 0;
$Graph->Axes(xlValue)->{HasMajorGridlines} = 1;
$Graph->Axes(xlValue)->{HasMinorGridlines} = 0;
$Graph->Axes(xlValue)->{WallsAndGridlines2D} = 0;
$Graph->{HasLegend} = 0
Dan Muey wrote:
>> I'm told that this is relatively easy to do using VBScript... Bo
>> ;p
>
>> Besides the fact that I don't know VBS I would like to do it
>> the Perl way :)
> Right On!
>
> OK go to serahc.cpan.org
>
> Spreadsheet::WriteExcel should help you get the data
> And GD or some o
> I'm told that this is relatively easy to do using VBScript...
Bo ;p
> Besides the fact that I don't know VBS I would like to do it
> the Perl way :)
Right On!
OK go to serahc.cpan.org
Spreadsheet::WriteExcel should help you get the data
And GD or some other image module should help you
PROTECTED]
Subject: RE: Excel spreadsheet: creating charts
Rich,
I know for a fact that you can generate any of the formulas and data you
might need with Spreadsheet::WriteExcel -- I'm not so sure about the graphs
though. I think those would still need to be done manually.
-
nardo Court
San Diego, CA 92127
1-858-676-2277 x2152
> -Original Message-
> From: Richard Fernandez [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 12, 2003 7:55 AM
> To: [EMAIL PROTECTED]
> Subject: Excel spreadsheet: creating charts
>
>
> We have a manu
We have a manual process in place to create Excel worksheets that contain
bar charts. I'm trying to automate this process using perl. The problem is
that I don't know how to access the underlying formulas, in Excel, that
generate the charts. Our current process is as follows:
1) Generate a space s
