RE: [PHP] PHP to Excel Export

2003-07-08 Thread electroteque
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

2003-07-08 Thread \[cz\]Emo
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

2003-07-04 Thread Mika Tuupola
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

2003-07-03 Thread daniel
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

2003-07-03 Thread Chris Hayes
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

[PHP] PHP to Excel Export

2003-07-03 Thread Mark McCulligh
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

[PHP] PHP to Excel (csv)

2002-10-07 Thread Ivo Stoykov
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

Re: [PHP] PHP to Excel?

2002-06-18 Thread 1LT John W. Holmes
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?

2002-06-18 Thread Chad Day
- 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?

2002-06-18 Thread 1LT John W. Holmes
;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

AW: [PHP] PHP to Excel?

2002-06-18 Thread Martin Lucas
. 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

RE: [PHP] PHP to Excel?

2002-06-18 Thread J. Anderson Scarbrough
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

RE: [PHP] PHP to Excel?

2002-06-18 Thread Jay Blanchard
[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?

2002-06-18 Thread Adam Voigt
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

[PHP] PHP to Excel?

2002-06-18 Thread Chad Day
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

RE: [PHP] PHP to Excel, Quick Question, DONE

2002-05-03 Thread Jay Blanchard
[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

[PHP] PHP to Excel, Quick Question

2002-05-03 Thread Jay Blanchard
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