manipulating Excel file in PERL
I have an excel spreadsheet which have columns
column1:Emp_ID
Column2:Emp_name
Column3:Project
Column4:Cost Center
Column5:rate/hour
Column6:Hours Worked
Column7:Start date
Column8: Null

I have to generate rate which is column5 x Column6 and write into column8 if hours worked > 40 hours
Is there any package/functions available. I tried to use Spreadsheet::ParseExcel but I am not quite sure of the functions involved.
manipulating Excel file in PERL
===

I have an excel spreadsheet which have columns
column1:Emp_ID
Column2:Emp_name
Column3:Project
Column4:Cost Center
Column5:rate/hour
Column6:Hours Worked
Column7:Start date
Column8: Null

I have to generate rate which is column5 x Column6 and write into column8 if hours worked > 40 hours
Is there any package/functions available. I tried to use Spreadsheet::ParseExcel but I am not quite sure of the functions involved.