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
