Formulas

2003-08-24 Thread Olivier6
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

Spreadsheet::WriteExcel formulas

2003-08-20 Thread Olivier6
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

Re: How to read formulas from an Excel file

2002-06-13 Thread Felix Geerinckx
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

How to read formulas from an Excel file

2002-06-12 Thread Rob
::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]