Scott's attachment, when opened, had each style demarked by an extra
period. so instead of ".classname" it has "..classname" that and a
couple of other little tweaks and it's working like a charm. It also
creates the possibility of a default style:
td {
font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 11px;
mso-number-format:"\@";
so that every cell is passed as text. That makes it easy to grab a
resultset and dump it as an excel file and not have to worry about
formatting the html of each cell.
This cures a class of problems that has plagued folks for a long
time. I came into a company and found lots of crazy workarounds for
Excel's aggressive reformatting.
Thank you
On Jul 11, 2005, at 1:18 PM, Scott Cadillac wrote:
Hi Roland,
Can you send me your sample? So I can test it here?
What desktop OS do you have, and what version of Excel are you using?
Let me know, when you have a moment. Thanks.
~ 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 2:15 PM
To: [email protected]
Subject: Re: Witango-Talk: exporting to excel: credit card number
mess
oh, it's exporting properly. I have been opening in BBEdit to peek
and tweak.
It is a proper html file, header is identical to your example,
including the style sheet.
then, a cell with a cc number has the <td class="cell_cc"> tag
On Jul 11, 2005, at 1:09 PM, Scott Cadillac wrote:
Hi Roland,
Do an export and just save it to your harddrive, now (prior to
opening with
Excel) open it with a text editor - what do you see exactly?
Let us know.
~ 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 2:06 PM
To: [email protected]
Subject: Re: Witango-Talk: exporting to excel: credit card number
mess
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
______________________________________________________________
________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________
__________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
