EMAIL PROTECTED]
Subject: RE: [PHP] excel 2 csv 2 mysql
Pretty cool, man... I actually didn't know about xls2csv.
Learn something new every day -- this'll certainly come in handy.
'Course, it's not exactly standard with most distributions. For anyone
looking for it, you can dow
om: daniel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 1:26 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; daniel
Subject: RE: [PHP] excel 2 csv 2 mysql
ok i've built a class to acomplish this now
class Export_Excel {
var $command
function Export_Excel() {
7;re going to have to use COM or something similar on a windows
server to get effective access to the server.
Another option is dynamically adding at as an odbc datasource and querying
it. Again, this will only work on a windows server...
It's all much easier if you can convince users to upload csv files.
-
Justin,
For reading, you could try this:
http://www.zakkis.ca/products/abc_excelparser/index.php
Cost is 150 CAD - quite steep. Tried the online demo - seems to work. Will only work
with cells containing strings though - doesn't resolve formulae. If
you purchase it, perhaps you could let me know
>>
>>>= Original Message From <[EMAIL PROTECTED]> =
>>>Yeah... you're going to have to use COM or something similar on a windows
>>>server to get effective access to the server.
>>>
>>>Another option is dynamically adding at as a
>Another option is dynamically adding at as an odbc datasource and querying
>>it. Again, this will only work on a windows server...
>>
>>It's all much easier if you can convince users to upload csv files.
>>
>> - jon
>>
>>-
>>jon
effective access to the server.
>
>Another option is dynamically adding at as an odbc datasource and querying
>it. Again, this will only work on a windows server...
>
>It's all much easier if you can convince users to upload csv files.
>
> - jon
>
>-
>jon
nior manager, online production
>epilepsy foundation
>http://jonroig.com
>
>
>-Original Message-
>From: daniel [mailto:[EMAIL PROTECTED]
>Sent: Monday, March 31, 2003 7:48 PM
>To: [EMAIL PROTECTED]
>Subject: [PHP] excel 2 csv 2 mysql
>
>
>hi guys i am trying
on 01/04/03 11:48 AM, daniel ([EMAIL PROTECTED]) wrote:
> hi guys i am trying to work out how to dynamically be able to upload an excel
> file , export it to csv to be able to import into mysql , is there any
> examples out there ? fopen gave me binary code :|
also see fgetscsv()
Justin
--
PH
ince users to upload csv files.
- jon
-
jon roig
senior manager, online production
epilepsy foundation
http://jonroig.com
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] excel 2 csv 2
hi guys i am trying to work out how to dynamically be able to upload an excel
file , export it to csv to be able to import into mysql , is there any
examples out there ? fopen gave me binary code :|
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/un
11 matches
Mail list logo