ject: RE: Excel spreadsheet: creating charts
If you have Excel, an easy way is to take the spreadsheet, open it in Excel,
start recording a macro, build the chart, the stop the macro recording.
Then go Tools-Macro, select the macro and edit. This will show the code in
VB. Translate it to Perl.
Here is a s
If you have Excel, an easy way is to take the spreadsheet, open it in Excel,
start recording a macro, build the chart, the stop the macro recording.
Then go Tools-Macro, select the macro and edit. This will show the code in
VB. Translate it to Perl.
Here is a sample of what I am using to generat
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.
-
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.
--
David Olbersen
iGuard Engineer
11415 West Bernardo C
