Combine 2 XLS sheets via PHP

movieprodw
movieprodw used Ask the Experts™
on
Hello,

I have 2 XLS spreadsheets that get dropped off into my ftp.

I was asked by my client to combine them.

Is there a way via php to open one, remove the first row and add it to the other one?

Thanks,
Matt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2016
Commented:
If the spreadsheets are stored in the form of a CSV file, you might be able to do this easily.  If they are XLS or XLSX files, it may take a lot more work.  I'm vaguely aware of some PHP XML parsers, but I don't have one at my fingertips.  With the CSV option, there is the PHP function fgetcsv().  CSV files are almost universally associated with Excel.

Author

Commented:
It turned out we can use a CSV file, I know how to do that.

Thanks Ray!
Most Valuable Expert 2011
Top Expert 2016

Commented:
Thanks for the points and good luck with it! ~Ray

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial