perl problem in processing excel file

Shell Programming and Scripting
1

Dear all,

I got a perl script to write some data into an excel file using Spreadsheet::ParseExcel::SaveParser. After that I find all formulas in the excel file are gone.

Does any body encounter this problem or have any work around?

2

You can reset the formula in this way :slight_smile:

# print out the contents of a cell  
  printf "At ($row, $col) the value is %s and the formula is %s\n",
   $Sheet->Cells($row,$col)->{'Value'},
   $Sheet->Cells($row,$col)->{'Formula'};

source

3

since the excel has a lot of formulas, can perl keep all formulas intact? if so, which perl package can do so?