Page 1 of 1

php and excel

Posted: Mon Apr 07, 2003 12:59 pm
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

Posted: Mon Apr 07, 2003 2:04 pm
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).