Combine 2 XLS sheets via PHP


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?

Who is Participating?
Ray PaseurConnect With a Mentor 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.
movieprodwAuthor Commented:
It turned out we can use a CSV file, I know how to do that.

Thanks Ray!
Ray PaseurCommented:
Thanks for the points and good luck with it! ~Ray
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.