RE: [PHP] PHP to Excel Export
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/ 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 Emo "Mika Tuupola" <[EMAIL PROTECTED]> píse v diskusním príspevku news:[EMAIL PROTECTED] > 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. > > -- > Mika Tuupola http://www.appelsiini.net/~tuupola/ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP to Excel Export
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 Emo "Mika Tuupola" <[EMAIL PROTECTED]> píse v diskusním príspevku news:[EMAIL PROTECTED] > 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. > > -- > Mika Tuupola http://www.appelsiini.net/~tuupola/ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP to Excel Export
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. -- Mika Tuupola http://www.appelsiini.net/~tuupola/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP to Excel Export
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_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 that allow fields greater then > 255. > > Thanks, Mark. > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP to Excel Export
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 used or know of a Excel class that allow fields greater then 255. i just write a .csv file with a header that claims it is for Excel. Then Excel just opens it and converts it for me. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP to Excel?
In that case, here's a function I use to set an Excel header.
##
#
# Creates headers to send MS Excel file
#
##
function COM_ExcelHeader($filename = "download")
{
//MS Excel Headers
header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: attachment; filename=" . $filename .
".xls");
}
---John Holmes...
- Original Message -
From: "Chad Day" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 11:40 AM
Subject: RE: [PHP] PHP to Excel?
> Annoying doesn't begin to describe it.
>
> I'm going with the HTML/Excel Header bit, since Biffwriter costs way too
> much for a for-profit business to use. Thanks anyway.. looks pretty 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]
> 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 BiffWriter that your looking for on that site.
> Should be one of the topics when you expand the central "dot" (after you
> close the "news' popup). annoying...
>
> Like someone else said, I just use HTML and send an Excel header(). Works
> great and it's perfect for simple stuff. I'll probably move to PHP2Excel
> BiffWriter eventually, though.
>
> ---John Holmes...
> - Original Message -
> From: "Martin Lucas" <[EMAIL PROTECTED]>
> To: "'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 useful
things.
>
>
> greetings
>
> martin
>
> > -Ursprüngliche Nachricht-
> > Von: Chad Day [mailto:[EMAIL PROTECTED]]
> > Gesendet: Dienstag, 18. 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 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 field
> > bold, stuff like that?
> >
> > Thanks,
> > Chad
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP to Excel?
Annoying doesn't begin to describe it. I'm going with the HTML/Excel Header bit, since Biffwriter costs way too much for a for-profit business to use. Thanks anyway.. looks pretty 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] 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 BiffWriter that your looking for on that site. Should be one of the topics when you expand the central "dot" (after you close the "news' popup). annoying... Like someone else said, I just use HTML and send an Excel header(). Works great and it's perfect for simple stuff. I'll probably move to PHP2Excel BiffWriter eventually, though. ---John Holmes... - Original Message - From: "Martin Lucas" <[EMAIL PROTECTED]> To: "'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 useful things. greetings martin > -Ursprüngliche Nachricht- > Von: Chad Day [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 18. 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 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 field > bold, stuff like that? > > Thanks, > Chad > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP to Excel?
The layout on that site is so annoying. Yeah, it looks pretty, but it's annoying. It's PHP2Excel BiffWriter that your looking for on that site. Should be one of the topics when you expand the central "dot" (after you close the "news' popup). annoying... Like someone else said, I just use HTML and send an Excel header(). Works great and it's perfect for simple stuff. I'll probably move to PHP2Excel BiffWriter eventually, though. ---John Holmes... - Original Message - From: "Martin Lucas" <[EMAIL PROTECTED]> To: "'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 useful things. greetings martin > -Ursprüngliche Nachricht- > Von: Chad Day [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 18. 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 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 field > bold, stuff like that? > > Thanks, > Chad > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP to Excel?
I often build simple reports using HTML tables and then add an Excel MIME header to the page which launches Excel. Since newer verions of Excell suport HTML natively, Excel can read the HTML tables and render them appropriately with all your formatting. I find this works well for simple 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 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 field bold, stuff like that? Thanks, Chad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP to Excel?
[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/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP to Excel?
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 > 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 field > bold, stuff like that? > > Thanks, > Chad > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP to Excel, Quick Question, DONE
[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, '\'' (escape a tick which Excel normally uses to display numbers
as text)
stuff, 1, ' ' (a space)
stuff, 1, NULL (which still returns a zero)
stuff, 1, (which throws errors)
stuff, 1, '\"\"' (which still returns a zero)
stuff, 1, '\ ' (escape a space)
The worksheet still has zero values displayed, no matter what I do (except
for that which throws errors). Ideas?
[/snip]
I got it (and feel somewhat a d'oh!). I just ley PHP handle it when it
writes it out;
if($dbrow->min1 > 0){
print($dbrow->min1);
}
for each row...
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
