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
| Listing_Title |
Product_ID |
Category |
Name |
User_Name |
Email |
Address |
City |
State |
Zip |
Phone |
CCNo |
ExprYr |
ExprMonth |
Bid |
Taxable |
First_Name |
Last_Name |
CardType |
| Some sample text |
1243 |
390 |
Jim Smith |
301977 |
[EMAIL PROTECTED] |
123 Any street |
Gaithersburg |
MD |
20877 |
3015551212 |
4111111111111110 |
2007 |
5 |
28700.50 |
No |
Jim |
Smith |
4 |
|
| Some other text to demonstrate this thing |
1255 |
393 |
Janet Smith |
301979 |
[EMAIL PROTECTED] |
123 Any Road |
Hope |
BC |
V3R 7U7 |
6049876543 |
4111128114113220 |
2007 |
9 |
5700.50 |
No |
Janet |
Smith |
4 |
|
