Excel to MySQL through PHP?

[Rainman]

I want to allow authenticated users to be able to use my PHP web page to
upload their Excel spreadsheet data into specific columns of my MySQL
table. I found "Spreadsheet_Ex cel_Writer", but I want to go the other
way, so I don't think this would be useful. I am rather lost how to go
about this endeavor. Can someone drop me a few hints?

Mark

[ZeldorBlat]

Re: Excel to MySQL through PHP?


Rainman wrote:[color=blue]
> I want to allow authenticated users to be able to use my PHP web page to
> upload their Excel spreadsheet data into specific columns of my MySQL
> table. I found "Spreadsheet_Ex cel_Writer", but I want to go the other
> way, so I don't think this would be useful. I am rather lost how to go
> about this endeavor. Can someone drop me a few hints?
>
> Mark[/color]

Excel can save spreadsheets as CSV files. Once in that format it's
fairly easy to do whatever you want with it. Much easier than trying
to convert Excel files directly...

[Roman Ziak]

Re: Excel to MySQL through PHP?

Rainman wrote:[color=blue]
> I want to allow authenticated users to be able to use my PHP web page to
> upload their Excel spreadsheet data into specific columns of my MySQL
> table. I found "Spreadsheet_Ex cel_Writer", but I want to go the other
> way, so I don't think this would be useful. I am rather lost how to go
> about this endeavor. Can someone drop me a few hints?
>
> Mark[/color]

If you are running on Windows server, you can use ODBC. Excel ODBC
driver is preinstalled with Windows.

The example of conection string:

'Driver={Micros oft Excel Driver (*.xls)}; FIRSTROWHASNAME S=0;
READONLY=FALSE; DBQ=C:\test.xls '

Roman

[Andy Jeffries]

Re: Excel to MySQL through PHP?

On Sat, 01 Apr 2006 21:27:23 +0000, Rainman wrote:[color=blue]
> I want to allow authenticated users to be able to use my PHP web page to
> upload their Excel spreadsheet data into specific columns of my MySQL
> table. I found "Spreadsheet_Ex cel_Writer", but I want to go the other
> way, so I don't think this would be useful. I am rather lost how to go
> about this endeavor. Can someone drop me a few hints?[/color]

Google.com?!

http://sourceforge.net/projects/phpexcelreader/

http://webxadmin.free.fr/article/convert-your-excel-sheets-to-mysql-data-with-xls2m-317.php

Cheers,


Andy


--
Andy Jeffries MBCS CITP ZCE | gPHPEdit Lead Developer
http://www.gphpedit.org | PHP editor for Gnome 2
http://www.andyjeffries.co.uk | Personal site and photos