From Excel to PHP

Anon

How can I import tables and datas from Excel files to PHP? Is there any tutorials or docs available?

gettingold

I had a similar need this week. The way i did it was to export the excel file as a comma delimited text file, which i then loaded into ms access, which i then exported via odbc into mysql.

Theres probably an easier way to do it, but it worked for me.

amcgrath

If your PHP scripts reside on a Windows machine, have you thought about COM objects and doing something that way?

Anon

i have this code and it makes connection to file nhl.xls, but i don`t know how to write an SQL statement to select first collumn in Sheet1?????????

if (!$database = odbc_connect('nhl.xls','','')){
echo "not connected";
} else {echo "is connected";}

$stat= odbc_exec( $database, "?????????" );
if( ! $stat )
{
echo "ERROR";
}

odbc_close($database);
?>

Anon

in control panel i selected 'ODBC data sources' and make some changes in 'System DSN', but i am not sure what i have done....

ame12

BadBlue is a small footprint web server for Win32 that will convert Excel (or Access & Word) to HTML automatically. You could combine this capability with fopen's of a URL (the PC running BadBlue that has the Excel files on it) - and just translate the HTML from the fopen into whatever you want.

Much easier than COM, etc. and requires no file format changes. Files can be read even while someone has them open.

http://badblue.com/helpxls.htm describes the capability and you can try it out with their free download.