Hi,
I have the task to create excel sheet with embedded charts and graphs
through PHP. The charts are pie chart and bar chart. The project will be run
on the linux server. My question is it is possible to implement this through
PHP? If yes, then please suggest the available implementations.
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
Hi all,
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 like underlines, italics and i am hoping vertical
[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
In many of our apps we save tab delimited text files to be later opened
from the browser using the following set of headers;
header(Content-Type: application/vnd.ms-excel);
header(Content-Disposition: inline; filename=\excel.xls\);
header(Expires: 0);
header(Cache-Control: must-revalidate
:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 2:40 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP, Excel, and tab delimited files question
In many of our apps we save tab delimited text files to be later opened
from the browser using the following set of headers;
header(Content-Type
[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
Good morning!
I have several reports that are generated using PHP MySQL for which I
would like to include a graph using the excellent jpgraph
(http://www.aditus.nu/jpgraph/) class for PHP.
?php
ob_start();
// excel headers
header(Content-Type: application/vnd.ms-excel);
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
Hello every one:
I'm trying to create XLS files on the fly.
I found BiffWriter. Looks great for adding texts and numbers, but not
formulas.
Has anyone implemented something about formulas?
Thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
of the
formulas and print out the actual value. May not work for your case,
though...
---John Holmes...
- Original Message -
From: LeTortorec, Jean-Louis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 2:42 PM
Subject: [PHP] PHP Excel
Hello every one:
I'm trying to create XLS
: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 2:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP Excel
Hello every one:
I'm trying to create XLS files on the fly.
I found BiffWriter. Looks great for adding texts and numbers, but not
formulas.
Has anyone
-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
Hello Everyone,
A client of mine is working with excel, and I need to move the data from
excel to something php can deal with a little better. Naturally, I figured
using .csv would be easiest, but I am running into several problems.I
can get around them, but I need a regular expression (and
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
Hello Everyone,
A client of mine is working with excel, and I need to move the data from
excel to something php can deal with a little better. Naturally, I figured
using .csv would be easiest, but I am running into several problems.I
can get around them, but I need a regular expression (and
31 matches
Mail list logo
