I have suppose 10 separate .xls files. i want to merge 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???
+1
A:
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
iWantSimpleLife
2010-08-27 07:06:35
PHPExcel will also read/write xls files (Excel 95+)
Mark Baker
2010-08-27 08:24:54
@champ - you'd have to tell us exactly what you meant by "merge and delete" for us to be able to answer this second question
Mark Baker
2010-08-27 08:26:07
See the [PHP Function Reference](http://www.php.net/manual/en/funcref.php)
Dratir
2010-08-27 08:30:15
I have 30 .xls files in same format.. it contains name, email id, address etc. now i want to have all the data of this 30 files together and also want if there exists any duplicate rows(it is possible to have duplicates) to be removed...
champ
2010-08-27 09:36:58