-----Original Message----- From: Adam Dayhoff [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2003 2:27 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Exporting to Excel
I am attaching an example that I use. I haven't had problems with formatting not coming into excel. This example works with CF5 and Excel 2002. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2003 10:06 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Exporting to Excel We've always used the custom tag CF_Query2Excel and have not experienced the loss of formatting. -----Original Message----- From: Kory Bakken [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2003 9:56 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Exporting to Excel When exporting a CFQUERY resultset to MS Excel I lose date and number formatting. This makes sense to me. But just in case, does anyone know if there is a way to retain that formatting in Excel. Kory Bakken ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ******************************************************************* * This message and any attached documents are confidential and * * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents. * ******************************************************************* ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are NOT the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. This message and any attachments are confidential to the intended recipient at the e-mail address to which it has been addressed. If you are not the intended recipient you may not copy, forward, disclose or use any part of this message or its attachments. If you received in error please notify the sender immediately by e-mail or contact The Innovation Group, US, at 800-669-9689 and then delete this message from your system. Neither the sender nor any office or company in The Innovation Group plc group will be liable for any viruses. Any opinions contained in this message are those of the author and are not given or endorsed by any company in The Innovation Group plc group through which this message was sent unless otherwise expressly stated in this message and the authority of the author in so stating is verified. The Innovation Group, US, at 8345 Lenexa Drive, Suite 100, Lenexa, Kansas, 66214, USA. ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]