php and excel

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
phpScott
DevNet Resident
Posts: 1206
Joined: Wed Oct 09, 2002 6:51 pm
Location: Keele, U.K.

php and excel

Post by phpScott »

A client wants to be able to maintian a spread sheet on his local computer and transfer it up to the web.
He only wants to show certian columns of the spreadsheet and probably be able to do a search.
I know with .net that you can do it but since the rest of the site is in php and I prefer opens source I am trying to figure out if this is possible using php.

thanks
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

Create a csv file with just the info you want then LOAD DATA (see mysql manual).

You could write your own php script to do the LOAD DATA or just use phpMyadmin (free mysql manager sorry no link - google it down).
Post Reply