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.
Thank
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 projec
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
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 expor
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
> basi
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
>
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
(assuming
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 a
[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
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 ali
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 t
[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 a
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:
&
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 t
jer [mailto:[EMAIL PROTECTED]
Sent: 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
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 (http://www.p
[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: http://www.php.net/
rd [mailto:[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(&qu
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-revalidat
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 be
[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...
U
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 exc
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.
The file output for Excel is in the tab delimited format and the IMG tag
is what calls the graph. I ha
> 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,
> -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 value
-Original Message-
> From: 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
compute the values 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:
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: http://www.php.net/unsu
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 th
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
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
