I had some issue when I tried CSV in the past. I don't know if there was some
issue with use of commas in the data and not getting Excel to properly use
some data, with commas, some more data so that it'd omit the quotes as well
or what. In the end, for the quick and dirty throwaway project I
[snip]
Can PHP be used to generate an excel file
[/snip]
http://www.php.net/com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
1) You'll be better off using templates, AFAIK.
2) PHP has classes to generate PDF's without the need of extensions.
(http://www.fpdf.org/)
On 4/18/07, Jonathan Kahan [EMAIL PROTECTED] wrote:
Hi all,
Can PHP be used to generate an excel file that A) Contains Macros B) Allows
Graphics to be
Or, even better and more useful:
http://pear.php.net/package/Spreadsheet_Excel_Writer
It's not perfect, but it does the basic job.
Also, if you output an HTML table and set the content type in your header to an
Excel content type, it should ask the client PC to open the page in Excel
2007. 04. 18, szerda keltezéssel 12.25-kor [EMAIL PROTECTED]
ezt írta:
Or, even better and more useful:
http://pear.php.net/package/Spreadsheet_Excel_Writer
It's not perfect, but it does the basic job.
Also, if you output an HTML table and set the content type in your header to
an
On Wed, April 18, 2007 10:46 am, Jonathan Kahan wrote:
Can PHP be used to generate an excel file that A) Contains Macros B)
Allows
Graphics to be attached C) where cells can contain borders as well as
cells
being merged. I know there is some PHP excel functionality so i am
assume
basics
On Wed, April 18, 2007 11:25 am, [EMAIL PROTECTED] wrote:
Also, if you output an HTML table and set the content type in your
header to an Excel content type, it should ask the client PC to open
the page in Excel (assuming they have it installed). This works for a
real quick and dirty
On Wed, April 18, 2007 3:42 pm, Zoltán Németh wrote:
Or you can use COM as Jay recommended, but that requires Excel to be
installed on the PC that's running PHP and can get a little ugly.
really? I thought it requires only winsuxx to be installed...
COM only requires Windows (afaik there's no
06, 2004 5:15 PM
To: jon roig
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP, Excel, and tab delimited files question
jon roig wrote:
Nah... Try it in excel itself and you'll see what I'm talking about.
You have to do it in numeric fields.
Do this in an excel field:
- Type 10 and hit
[snip]
Right... But the principal is still the same. Excel handles those types
of fields in a uniform way, regardless of whether you do the entry
yourself or if you just import a csv file.
[/snip]
Actually that is not correct. We have prefaced the data with the single
quote in the output process
It may wind up being a user-learning issue.
I dump things to pipe delimited file (whether in *nix land or winDoze)
and that way the users can open it in Excel. The ones who have to open
the files I just go to their desks the first time and show them how to
open the file, delimit it on the | and
Don't do it in the header, but in the field itself just put a ' before
the first character and excel will interpret it as a text field.
-- jon
---
jon roig
web developer
email: [EMAIL PROTECTED]
phone: 888.230.7557
-Original Message-
From: Jay Blanchard
[snip]
Don't do it in the header, but in the field itself just put a ' before
the first character and excel will interpret it as a text field.
[/snip]
Tried that, the ' shows up. Don't want that to happen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Do double quotes around help?
Jay Blanchard wrote:
[snip]
Don't do it in the header, but in the field itself just put a ' before
the first character and excel will interpret it as a text field.
[/snip]
Tried that, the ' shows up. Don't want that to happen
--
PHP General Mailing List
: Friday, February 06, 2004 3:02 PM
To: Jay Blanchard
Cc: jon roig; [EMAIL PROTECTED]
Subject: Re: [PHP] PHP, Excel, and tab delimited files question
Do double quotes around help?
Jay Blanchard wrote:
[snip]
Don't do it in the header, but in the field itself just put a ' before
the first character
jon roig wrote:
Nah... Try it in excel itself and you'll see what I'm talking about. You
have to do it in numeric fields.
Do this in an excel field:
- Type 10 and hit return.
... It becomes 10, right?
Now try it like this: '000100
... Tada! It stays as 00100 and puts a little green tab in the
You need a class that can create xls files with images.
Or you can create a Web Archive:
http://officeupdate.microsoft.com/office/webarchive.htm
Jay Blanchard wrote:
Good morning!
I have several reports that are generated using PHP MySQL for which I
would like to include a graph using the
[snip]
You need a class that can create xls files with images.
Or you can create a Web Archive:
http://officeupdate.microsoft.com/office/webarchive.htm
[/snip]
Thanks! We have looked at this, but have arrived at the problem of
opening the file for the user. Here is the process in a nutshell...
Jay Blanchard wrote:
[snip]
You need a class that can create xls files with images.
Or you can create a Web Archive:
http://officeupdate.microsoft.com/office/webarchive.htm
[/snip]
Thanks! We have looked at this, but have arrived at the problem of
opening the file for the user.
This should
Can you just write out the formula to a cell? i.e. write the value
=SUM(C1:C5) to a cell and see if it's evaluated? Just throwing things
out...
I would think that you wouldn't need formulas. Isn't that the idea of using
PHP to create the Excel document? Have PHP compute the values of the
Are you on a Win32 platform?
If so, use COM...
$cell = $sheet-Cells($row,$col);
$cell-activate;
$cell-formula = your formula;
---
Scott Hurring
Systems Programmer
EAC Corporation
[EMAIL PROTECTED]
Voice: 201-462-2149
Fax: 201-288-1515
-Original Message-
From:
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Subject: Re: [PHP] PHP Excel
I would think that you wouldn't need formulas. Isn't that the
idea of using
PHP to create the Excel document? Have PHP compute the values of the
formulas and print out the actual
What if the user opens up the sheet and changes a number
after PHP creates it? Wouldn't you want formulas to
re-compute the sheet and keep it correct? :)
Like I said, it depends on your case. When I create an Excel file, it's a
snapshot of everything. If you need an updated speadsheet, you
Hi Jeff,
I didn't get your question. Can you elobrate little bit more, if
possible? What is the input and what is output you are expecting and
what do you want to do in the process?
Thanks.
Jeff Lacy wrote:
Hello Everyone,
A client of mine is working with excel, and I need to move the
24 matches
Mail list logo