Hello,
Our company is mostly Unix oriented. We use Linux, Apache web servers, and PHP for any programming needs.
Our vendors send us data daily in microsft excel spreadsheets. I have to manually open up the file in Excel, save as text, then ftp it to our Unix box where our PHP programs will parse out the needed data. If our vendors could just send text files then I could automate the whole process, but unfortunately they say they can only send excel files to us. The manual steps in dealing with these excel files is wasting hours of our time.
Is there any Unix or PHP utility that could automatically convert these excel files to text ? Then I could automate everything.