Ok, so I export a file that has the same header, including the style
sheet as your example. Then tag the cells with credit card number as
class="cell_cc"
when opened in excel, it does the same ole thing, scientific notation
and changes last digit to 0
On Jul 11, 2005, at 12:40 PM, Scott Cadillac wrote:
Hi Folks,
That was me who sent that CSS to Excel example. Here it is again,
plus a
another CSS class for formatting dates.
..cell_date {
font-size:9pt;
font-style:normal;
mso-number-format:"mmm\\-d\\-yyyy";
mso-generic-font-family:auto;
}
The attached has classes for credit-card numbers, currency values
and phone
number masking.
By using HTML and CSS for your Excel export, obviously you can make
some
very professional finished export results.
Don't forget to use rewrite the HTTP Content-type, to either force
Excel to
open or prompt the user for download with an *.xls extension.
Hope that helps.
~ Scott Cadillac
~ 403-254-5002
~ [EMAIL PROTECTED]
~ Custom Software for Business
http://custom.softwarefor.net
~ The XML-Extranet Partnership
~ P.O. Box 69006
RPO Bridlewood SW
Calgary, Alberta
Canada T2Y 4T9
-----Original Message-----
From: Roland Dumas [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 1:30 PM
To: [email protected]
Subject: Re: Witango-Talk: exporting to excel: credit card number
mess
On Jul 11, 2005, at 12:22 PM, Robert Garcia wrote:
There was a post about this a few months ago, if I remember, and
someone posted how to tell excel the format of the fields using
css. I haven't tried it yet, but I made a note about it, cuz that
would be very handy.
I recall that, but haven't found in the archives yet.
If you need something quick and dirty, put a "cc:" at the front of
the card numbers so excel will treat as text, not numbers. You can
pull the cc: in one step when opening.
--
that's exactly what I'm doing as a band-aid.
______________________________________________________________
__________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
<Sample-Excel.htm>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
