Hello,
I use the module Spreadsheet::WriteExcel and have following effect by
generating formulas
...
# Formulas
my $formel = $worksheet -> store_formula('=IF(A2=A1,"X","-");');
for my $row (1..$anz_rows)
{
$worksheet -> repeat_formula($row, 8, $form
Hello,
I use the module Spreadsheet::WriteExcel and have following effect by
generating formulas
...
# Formulas
my $formel = $worksheet -> store_formula('=IF(A2=A1,"X","-");');
for my $row (1..$anz_rows)
{
$worksheet -> repeat_formula($row, 8, $form
on Thu, 13 Jun 2002 00:20:25 GMT, [EMAIL PROTECTED] (Rob) wrote:
> I need to write to an existing excel file, which is not supported
> by any existing module.
Did you check out Win32::OLE?
--
felix
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECT
::WriteExcel.
However, in the interest of preserving formulas from the original file, I
need to read and write formulas. Is this possible? Thanks for your help.
-Rob Hunt
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]