How can I add a new row to an existing Excel spreadsheet using Perl?

Question

I have created my Excel sheet a.xls using Perl where I have field as:

date         name    eid     
13/jan/2010   asa    3175

When I will compile next time and if date will be more than previous date then it has to update like wise:

date         name   eid
13/jan/2010  asa    3175
14/jan/2010  stone  3180

If the date will be of previous row date as last row date is 14/jan/2010 and current date is also 14/jan/2010 then it should not insert any row it should update the previous record only.

Answer 1

See example in Spreadsheet::ParseExcel::SaveParser documentation. As I understand, AddCell method can replace existing cell or add new.