to delete duplicating rows from excel sheet on the basis of latest date and time

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

i need a perl script to delete duplicate rows from the excel sheet, considering a column having date and time, and the latest row having date and time should remain in the spreadsheet while remaining should be removed from the file.

Comment on to delete duplicating rows from excel sheet on the basis of latest date and time

Replies are listed 'Best First'.
Re: to delete duplicating rows from excel sheet on the basis of latest date and time by hdb (Monsignor) on Apr 19, 2013 at 11:38 UTC
Under Windows? Use Win32::OLE, lots of material here on PerlMonks. Under other OS: no reliable way to do it. Need to specify further.	[reply]
Re^2: to delete duplicating rows from excel sheet on the basis of latest date and time by GotToBTru (Prior) on Apr 19, 2013 at 21:48 UTC
Under another OS, options are probably restricted to saving the file in CSV form. Good news? Perl is very good at manipulating CSV files and there are packages out there to help. Bad news? Loss of formatting, possible degradation of data when converting back to Excel format. You might do better to look for an Excel macro that does this.	[reply]
Re^3: to delete duplicating rows from excel sheet on the basis of latest date and time by Anonymous Monk on Apr 20, 2013 at 03:41 UTC
wine runs on other os, wine can run excel/powerpoint... wine can run perl and win32::ole , so you can use win32::ole on other os .... provided you have excel/powerpoint license....	[reply]