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
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/
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 [mailto:
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
> 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
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-
>
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
"formu
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
24 matches
Mail list logo
