SaveParser overwriting existing formulas

[asj75]

I have an existing excel file and need to write to it on a daily basis.
The excel file comes with functions and when I use
ParseExcel::SaveParser, the formulas are no longer showing up.
Is there anyway to maintain the formulas?

 

[PaulTEG]

Is it overwriting cells automatically, even ones you're not adding to?

Have you tried writing the formula to a cell in the row
="=sum(".$activerow.", 2:".$activerow.", 6)";

I'm just clutching here? ;-)

--Paul

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[asj75]

The function in the excel file is to extract day from a date. The parseexcel::saveparser would open the existing excel file and write to the appropriate different cell based on the date.
I have read somewhere that parseexcel::saveparser overwrites pre-existing functions but haven't found a way to force the function/calculation to stay.

 

[PaulTEG]

Just write the formula to the cell as described above, assuming you have the correct row index to include in the formula

Cell("A3)="=...";

No?

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[asj75]

This is how the function was done when I was creating the excel file using WriteExcel.

my $str = xl_rowcol_to_cell(5, $col);
$worksheet->write(4,$col,'=TEXT('.$str.',"dddd")');
$worksheet->write(5,$col,$mth.'/'.$isheet.'/'.$full_year);

So I would write the formula as you have given in the WriteExcel script itself?

BTW, thanks for helping me out with this - been driving me nuts - could be because I am so new to Perl.

 

[PaulTEG]

That might do it, and you're welcome, I'm just killing time till the pubs start rocking;-)

$worksheet->write(4, $col, '=sum('.$col-1,$row.":".$col-4,$row.")");

should render a formula in the cell

+----------+
[SUM(XX:YY)]
+----------+

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[asj75]

Doesn't seem to work. It seems that SaveParser just defaults the calculation cell to 0.