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

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

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.

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

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

In Section Seekers of Perl Wisdom