http://www.perlmonks.org?node_id=1028308

PBegin has asked for the wisdom of the Perl Monks concerning the following question:

I am new to Perl! I am reading a cell having a formula in an excel file and getting a zero cell value when I use get_cell method. This cell value had been computed previously by another perl program. When I click the cell in the written excel file, it shows the formula in the formula bar and not the value of the cell. How can I change the formula bar to have value in excel file using perl, so that I can use this value to do further computation.