note 47403 added to function.odbc-columns
| From: | laundro at gmail dot com | Date: | Mon, 15 Nov 2004 16:29:06 +0000 |
| Subject: | note 47403 added to function.odbc-columns | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-80547@lists.php.net to get a copy of this message | ||
Getting all column names from Excel with ODBC:
$cols = odbc_columns($connection, $filename, NULL, $sheet);
where:
$connection is the result of your odbc_connect;
$filename is the filename of the Excel file;
$sheet is the name of the Excel worksheet.
This is useful when you want to query an Excel file without having to name ranges beforehand. With
the results obtained from the above command, you can populate an array and use its contents (ie the
column names) for further querying.
----
Manual Page -- http://www.php.net/manual/en/function.odbc-columns.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+47403
Delete -- http://master.php.net/manage/user-notes.php?action=delete+47403&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+47403&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+47403&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+47403&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+47403&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+47403&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+47403&report=yes
Search -- http://master.php.net/manage/user-notes.php