-- Original message --
From: Sam Smith <[EMAIL PROTECTED]>
>
> I've got it working writing out a file (fopen) to CSV (comma delimited) and
> the "header('Content-Disposition: attachment; filename="myFile.csv"')"
> method but it's clumsy for the user to figure out h
I've got it working writing out a file (fopen) to CSV (comma delimited) and
the "header('Content-Disposition: attachment; filename="myFile.csv"')"
method but it's clumsy for the user to figure out how to use the file.
Is there some totally slick way of spitting out a file that Excel can open
righ
nal Message-
> From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 17, 2002 7:54 PM
> To: Chris Boget
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] PHP+MySQL -> Excel ?
>
>
> No, this has nothing to do with PHP. You can run MySQL on Windows or
> U
At 02:13 PM 5/17/2002 -0300, Manuel Lemos posted the following...
>Hello,
>
>On 05/17/2002 01:18 PM, Evan wrote:
>>Is it possible to create an excel file with some data from mySQL, using PHP
>>?
>
>Sure, you can use this class to generate Excel files on fly on even in
>non-Windows platforms.
Hec
Hello,
On 05/17/2002 01:18 PM, Evan wrote:
> Is it possible to create an excel file with some data from mySQL, using PHP
> ?
Sure, you can use this class to generate Excel files on fly on even in
non-Windows platforms.
http://www.phpclasses.org/biffwriter
--
Regards,
Manuel Lemos
--
PHP
> > Are there examples anywhere that illustrate how this can be done? I'm not very
> > interested in looking into this alternative.
> You are not very interested, but you want examples?
eep, sorry. "not" should have been "now".
> Just read the MyODBC docs at mysql.com.
Excellent. Thank you
> Are there examples anywhere that illustrate how this can be done? I'm not very
> interested in looking into this alternative.
You are not very interested, but you want examples? Just read the MyODBC
docs at mysql.com.
-Rasmus
--
PHP General Mailing List (http://www.php.net/)
To unsubscrib
> No, this has nothing to do with PHP. You can run MySQL on Windows or
> UNIX, doesn't matter, and set up a connection directly from Excel to
> MySQL.
> PHP can of course run anywhere you want and manipulate the data in MySQL
> which will then be reflected in Excel.
Are there examples anywhere t
[snip]
> It is also possible to connect directly to MySQL from Excel via MyODBC.
True, but only if you are running PHP on a windows platform, yes?
[/snip]
Nope, no PHP, just the ODBC driver would have to live on Windows
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, vi
No, this has nothing to do with PHP. You can run MySQL on Windows or
UNIX, doesn't matter, and set up a connection directly from Excel to
MySQL.
PHP can of course run anywhere you want and manipulate the data in MySQL
which will then be reflected in Excel.
-Rasmus
On Fri, 17 May 2002, Chris Bo
> It is also possible to connect directly to MySQL from Excel via MyODBC.
True, but only if you are running PHP on a windows platform, yes?
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
It is also possible to connect directly to MySQL from Excel via MyODBC.
-Rasmus
On Fri, 17 May 2002, Chris Boget wrote:
> > > Is it possible to create an excel file with some data from mySQL, using PHP
> > > ?
> > Yes if you know the file format for excel. If not then write your data into a
> >
[snip]
Is it possible to create an excel file with some data from mySQL, using PHP
?
[/snip]
Evan,
I'll send you the article I recently wrote for evolt.org, it details all of
the things you need to know. Excel will honor all HTML table formatting
issues, except color. Colors need to be stated as
Thanks to all :-)
Bye,
Evan
"Evan" <[EMAIL PROTECTED]> ha scritto nel messaggio
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Is it possible to create an excel file with some data from mySQL, using
PHP
> ?
>
> Thanks,
> Evan
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscri
> > Is it possible to create an excel file with some data from mySQL, using PHP
> > ?
> Yes if you know the file format for excel. If not then write your data into a
> CSV file.
I just output the data as regular HTML (tabled, usually) but send the following
headers first:
header("Content-Disp
al Message-
From: Justin French [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 17:32
To: Evan; [EMAIL PROTECTED]
Subject: Re: [PHP] PHP+MySQL -> Excel ?
I guess you'd have to look around for exact specs on how Excel "marks up"
it's source (if you want formatting, bold, etc), bu
I guess you'd have to look around for exact specs on how Excel "marks up"
it's source (if you want formatting, bold, etc), but it's quite easy to
create a CSV (comma separated value) file which can easily be imported into
Excel, if you're happy to have no formatting.
I'm sure a quick "dig" around
On Saturday 18 May 2002 00:18, Evan wrote:
> Is it possible to create an excel file with some data from mySQL, using PHP
> ?
Yes if you know the file format for excel. If not then write your data into a
CSV file.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software
Is it possible to create an excel file with some data from mySQL, using PHP
?
Thanks,
Evan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
19 matches
Mail list logo