Want to merge and delete duplicate rows of ms excel files

I have suppose 10 separate .xls files. i want to merge开发者_如何学C them and also delete the duplicate rows.. can some 1 suggest me any codes for that???? is it possible to do it using php codes???

for xlsx files (Office 2007+) you can do that using the excel library for PHP. See "http://www.codeplex.com/PHPExcel". It will allow you to open read and write xlsx files

The simplest Way is to export the Data as CSV and then Process it.