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
