You're welcome ;-) ~ 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 3:11 PM > To: [email protected] > Subject: solved and thank you: Witango-Talk: exporting to > excel: credit card number mess > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
