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

Under Windows? Use Win32::OLE, lots of material here on PerlMonks.

Under other OS: no reliable way to do it. Need to specify further.

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

Replies are listed 'Best First'.
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]