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
9 matches
Mail list logo
