CodingForums.com - View Single Post - how to connect MS-excel with PHP????

Roelf · 06-30-2005, 08:13 PM

the easiest is to define a DataSourceName to the excel sheet. The sheet has to contain a named range, which the driver will treat as the table.
from the php-page, you can then make a dsn-connection to the datasource and eat your heart out

06-30-2005, 08:13 PM	PM User \| #2
Roelf Senior Coder Join Date: Jun 2002 Location: Zwolle, The Netherlands Posts: 1,110 Thanks: 2 Thanked 28 Times in 28 Posts	the easiest is to define a DataSourceName to the excel sheet. The sheet has to contain a named range, which the driver will treat as the table. from the php-page, you can then make a dsn-connection to the datasource and eat your heart out