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

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 E

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. --

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_Exc

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 u

Re: [PHP] PHP to Excel?

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

RE: [PHP] PHP to Excel?

- 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

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

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 repo

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/) T

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

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, '\'' (escap