Importing a local Excel sheet into php

[_Global]

Hi all, Just wondered if you know a way to import not all but a majority of the data from a excel sheet into php. The excel sheet is sent to me by mail daily and I then need to go through it and manually change it, I'm getting tired of doing this and hoped I could automate through php to create a another excel sheet with the amendments. I'm sure I'll be able to amend the text ect if I could import the excel sheet. any help would be appreciated. Cheers

[ahundiak]

Lookup the OLE routines.

Also, Excel 2003 now has a 'Save AS XML Workbook' command and can also read the same format directly. So you might try the xml route.

[steve123]

I have a similar question. I need to import excel file to php. My server does not allow remote connection and therefore I could not use softwares like phprunner to convert excel to php and publish them.

Now i converted a test excel file to mysql but then have to manipulate it in phpmyadmin and I get lost here as I do see the dumpfile as a table once the mysql file is imported in phpmyadmin but do not know how to publish this to php.. too complicated for me.

Is there an easier way in this case.

I also read about converting excel in Java (JSP) and this excel converter software does publish it in JSP but the data can not be saved on line after editing it.

My goal is to publish excel data to php and edit and save it on line.

There is a simple software ASPrunner but it is for servers supporting ASP which my server does not. This ASP software is so easy and takes about 5 clicks and the file is converted and published on line. HELP