|
|
|
1. You must have the Excel ODBC driver in your ODBC32 Control
Panel Entry. Don't ask me how and when it gets installed: I
just used the one I found in a pretty stock installation :)
2. Configuration of the ODBC driver: add a DSN choosing the
Excel driver and give it a name (i.e. "excelsux" :)).
Point it to an existing worksheet.
3. In the worksheet select a range of cells then Insert->Name->Define
(YMMV, my Excel is in Italian) and give a name to the
selection (i.e. "myselection").
4. PHP code finally: :)
/* Didn't try to protect it via user/pwd */
if (($id = odbc_pconnect("excelsux"))) {
if (($r = odbc_exec($id, "SELECT * FROM myselection"))) {
odbc_result_all($r); // Or whatever you want
}
}
Problems as of now:
1. the field name is tricky somehow. The first field name is the first
value in the first column of your selection (and if there are spaces
you are into troubles). Also note that your first row shouldn't contain
any data since it's supposed to contain the field names. The problem
I encountered traversing the field names was that I always got just
the first one... any solution or hint is much appreciated :)
2. no INSERTs or UPDATEs, according to M$ documentation :/ But you
are free to pipe your results to any PHP supported DB :)
(Gianugo) |
|
| A set of functions sitting on top of the abstraction layer that makes it a little easier to do SQL stuff. Documentation is within
Categories : Databases, ODBC, Complete Programs, PHP | | | Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0.
Categories : Databases, PHP, mSQL, Databases | | | How to connect to MS SQL 6.x+ database server via ODBC functions of
PHP3 compiled with iODBC and Openlink drivers under Linux.
Categories : Databases, MS SQL Server, PHP, ODBC | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | Dynamic WHERE CLAUSE depending on number of FORM FIELDS
Categories : ODBC, General SQL, PHP, Complete Programs, Databases | | | Modification of Shane Caraveo's guestbook. Uses ODBC...some code modifications
Categories : ODBC, Databases, Complete Programs, PHP | | | Query2Report : Generating Html, Pdf and Csv Reports from SQL Query
Categories : PHP, PHP, HTML, PDF, Excel | | | This is Yet Another Sql Abstraction Library. Include it in your script and you can use the most important SQL functions without worrying about the SQL backend.
Categories : Databases, PHP, ODBC, MySQL, PostgreSQL | | | db2tab.php - Simple scripts to access IBM DB2 Universal DataBase tables through PHP ODBC funtions.
Categories : Databases, PHP, ODBC | | | ADODB Database Wrapper Abstraction Library for PHP: MySQL, MSSQL,
Oracle, Interbase,ODBC, Microsoft Access and FoxPro.
Categories : PHP Classes, Databases, PHP, General SQL, ODBC | | | Recordset Class like ADO Recordset (plus DataBase Splitting feature) using ODBC functions
Categories : PHP Classes, ODBC, Databases, PHP | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | PhpIBadmin - Web interface to Interbase RBDMS , this is a port of
phpMyadmin
Categories : Databases, InterBase, PHP | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | |
| | | | vo binh wrote : 792
revert :
How I can output ASP to MS Exel ? Please
| | | | Piers Karsenbarg wrote :999
In answer to binh vo, to output into an excel table, all you need to do is have:
Response.ContentType = "application/vnd.ms-excel"
at the top of your script, then you just output normal HTML-style tables (i.e. new table: <table>, new row: <tr>, new cell: <td>) and thats all there is to it.
| |
|
|
|
