This also works in Netscape, we do it with NS 4.7x all the time.  I think
you can transfer more styles(CSS) via IE over NS.  If you do it, one thing
we have run into is when you include your style sheets via a <link> tag,
for whatever reason NS 4.7x on Win2k will first post a error msg to the
style link.  Our fix was just to put those styles on the page via a
<cfinclude>

Snipe - <CF_BotMaster Network="EFNet" Channel="ColdFusion">

On Tue, 30 Oct 2001, cf refactoring wrote:

> Are you on an IE-only platform?
> 
> If yes, you can try try sending an HTML table to Excel
> instead of a .csv. Excel will read in an HTML table
> and preserve formatting information so you can get
> really fancy if you want.
> 
> --- Nathan Shaw <[EMAIL PROTECTED]> wrote:
> > This is all being done dynamically. Yes, if I bring
> > it
> > in manually into Excel, it is not a problem at all.
> > 
> > What I need to know is:
> > 1) how to tell Excel to treat the zip code as a text
> > field OR 
> > 2) how to trick Excel into thinking the zip code is
> > a
> > text field.
> > 
> > Nate
> > 
> >
> -------------------------------------------------------
> > thinking aloud.
> > 1) export / import as a text field
> > 2) single quote at the front of the field
> > 
> > How are you importing / exporting?
> > 
> > Eric Dawson
> > 
> > From: Nathan Shaw <[EMAIL PROTECTED]>
> > Reply-To: [EMAIL PROTECTED]
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Subject: cf to excel formatting problem
> > Date: Mon, 29 Oct 2001 10:48:29 -0800 (PST)
> > 
> > I am exporting some data to Excel and one of the
> > fields is zip code. Excel is stripping all leading
> > 0's
> > (zeros) off of the zip codes. I need it to leave the
> > zip code alone, i.e. treat it as text instead of a
> > number. Any ideas anyone?
> > 
> > So far, I have tried:
> > 1) Using an obscure ASCII char in front of the zip.
> > RESULT: Excel puts in a box when it encounters an
> > ASCII char it does not understand
> > 
> > 2) Enclosing the zip in both single quotes and
> > double
> > quotes.
> > RESULT: Excel leaves the quotes in instead of
> > treating
> > them as a text qualifier
> > 
> > 3) Looked at the Allaire forums, where I saw the
> > same
> > question asked but not answered.
> > 
> > 4) Read up on Excel at cfcomet, but most things
> > there
> > are a little overkill for what I am trying to do.
> > 
> > TIA,
> > 
> > Nate
> > 
> > =====
> > ----------------------------
> > Nathan Shaw
> > Senior Web Applications Developer
> > iaffect, Inc.
> > http://www.iaffectonline.com
> 
> 
> =====
> I-Lin Kuo
> Macromedia CF5 Advanced Developer
> Sun Certified Java 2 Programmer
> 
> 
> 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to