fuk me this is much better than bifwriter
-Original Message-
From: [cz]Emo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP to Excel Export
I like this:
http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel
I like this:
http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/
Last time I've readed help there wasn't support for formulas.
Anybody know sth which can output formulas?
Mainly I need SUBTOTALS, which can show "plus-minus" to hide some rows.
Or another tip how to do it. Thanx
E
On Fri, 4 Jul 2003 [EMAIL PROTECTED] wrote:
> excel has a char limit of 255 , if you can find a work around for it please
> do let me know , also , check out the bifwriter , i think the pear packages
> just outputs csv right ?
Spredsheet_Excel_Writer outputs an Excel binary, not csv.
--
excel has a char limit of 255 , if you can find a work around for it please
do let me know , also , check out the bifwriter , i think the pear packages
just outputs csv right ?
> Hi Group,
>
> I am working on an app the creates an Excel file. Right now I am using
> the PEAR package Spreadsheet_Exc
At 16:56 3-7-2003, you wrote:
Hi Group,
I am working on an app the creates an Excel file. Right now I am using the
PEAR package Spreadsheet_Excel_Writer. It works great but I have one
problem. I have a field greater then 255 to export and the PEAR package
truncates anything over 255.
Has anyone u
Hi Group,
I am working on an app the creates an Excel file. Right now I am using the
PEAR package Spreadsheet_Excel_Writer. It works great but I have one
problem. I have a field greater then 255 to export and the PEAR package
truncates anything over 255.
Has anyone used or know of a Excel class
Hi
I have following problem.
Some data retreived from mysql db I need to send to the user as a *.csv
file. Usually I separate fields (usually double quoted) with comma (,) or
semicolomn (;) and the records with cr/lf (Windows)
It works fin until I do not have cr/lf in any of the fields.
Unfortu
neat,
> and I'll probably use it for some other projects I do.
>
> Thanks,
> Chad
>
> -Original Message-
> From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 11:47 AM
> To: Martin Lucas; 'Chad Day'; [EMAIL PROTECTED
-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 11:47 AM
To: Martin Lucas; 'Chad Day'; [EMAIL PROTECTED]
Subject: Re: [PHP] PHP to Excel?
The layout on that site is so annoying. Yeah, it looks pretty, but it's
annoying. It's PHP2Excel BiffW
;Chad Day'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 11:24 AM
Subject: AW: [PHP] PHP to Excel?
hi chad,
on http://www.cnovak.com/ you'll find a php-class that generates native
excel-files, even with cell formatings and other more or less us
. Juni 2002 16:52
> An: [EMAIL PROTECTED]
> Betreff: [PHP] PHP to Excel?
>
>
> I'm trying to get data from my MySQL database into Excel
> using PHP. I know
> and I am doing it right now by generating a CSV file, but is
> there any way I
> can do formatting, like
reports and it requires very little effort. Just an idea
-Original Message-
From: Chad Day [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP to Excel?
I'm trying to get data from my MySQL database into Excel using PHP. I know
[snip]
I'm trying to get data from my MySQL database into Excel using PHP.
[/snip]
[shameless plug]
http://www.evolt.org/article/Using_MySQL_and_PHP_to_Present_Excel_Spreadshee
ts/20/26896/index.html
(watch wrap)
[/shameless plug]
HTH!
Jay
--
PHP General Mailing List (http://www.php.net/)
T
I may be completely off-base here, but I think thats more of an Excel
compatible XML document thing, then a CSV which (I believe) is just
data.
Adam Voigt
[EMAIL PROTECTED]
On Tue, 2002-06-18 at 10:52, Chad Day wrote:
> I'm trying to get data from my MySQL database into Excel using PHP. I know
I'm trying to get data from my MySQL database into Excel using PHP. I know
and I am doing it right now by generating a CSV file, but is there any way I
can do formatting, like make certain cells bold, etc etc? Is there a list
of codes somewhere I can use to put before my field output to make a f
[snip]
SUM(IF(If FOO is this, return this number, else return a blank)) that looks
like this really
SUM(IF(RecordID = '100101', 1, '')) as min1
Which works correctly BUT, if the statement is false it does not show a
blank cell in the worksheet, but a "0" (zero).
I have tried
stuff, 1, '\'' (escap
Again, thanks to folks on the list I learned the "stupid IE trick" for
opening an Excel worksheet in the browser from a PHP generated table. Here
is another quick question...in my DB query for the values I have
SUM(IF(If FOO is this, return this number, else return a blank)) that looks
like this
17 matches
Mail list logo