RE: Excel Problem...

2014-08-28 Thread David Phelan
-talk Subject: Re: Excel Problem... You might also try saving the output as CSV and opening it in excel that way. Its an annoying workaround but may work. AS for CF8, ask about Railo then - its FOSS, and is faster than ACF. So what is the specific error? Is it in CF or Excel. If Excel are you

Re: Excel Problem...

2014-08-27 Thread Larry Lyons
You might also try saving the output as CSV and opening it in excel that way. Its an annoying workaround but may work. AS for CF8, ask about Railo then - its FOSS, and is faster than ACF. So what is the specific error? Is it in CF or Excel. If Excel are you getting this message? Excel

Re: Excel Problem...

2014-08-24 Thread Larry Lyons
So what is the specific error? Is it in CF or Excel. If Excel are you getting this message? The file you are trying to open, '[filename]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file.

Re: Excel Problem...

2014-08-24 Thread Les Mizzell
So what is the specific error? Is it in CF or Excel. If Excel are you getting this message? Excel actually opens. So, it's an Excel error. However, it just says There's an error with no further information. I *wish* it was the error below, because then I'd have something to go on. The

Re: Excel Problem...

2014-08-24 Thread Maureen
Have you tried naming the spreadsheet with an xlsx extension. cfheader name=content-disposition value=attachment;filename=spreadsheet.xlsx cfcontent type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet On Wed, Aug 20, 2014 at 5:15 PM, Les Mizzell lesm...@bellsouth.net wrote:

Re: Excel problem

2001-02-01 Thread Stephen Hait
Try outputing the number already formatted: #NumberFormat(YourNumberVariable,'_99,999,999')# HTH, Stephen I have a page where I allow users to download an excel file of the query they have done. I use the CFCONTENT TYPE="application/vnd.ms-excel" and it works nicely except for one field.

RE: Excel problem

2001-02-01 Thread Cornillon, Matthieu
Sandi, I don't know if I understand exactly what you are trying to do, but I can give you some information that might help. At some point in what you are doing you are populating an Excel file, right? If this is a static Excel file that is dynamically populated, you can change the formatting

RE: Excel problem

2001-02-01 Thread Sandi Benditt
At 10:51 AM 2/1/2001, Stephen wrote: Try outputing the number already formatted: #NumberFormat(YourNumberVariable,'_99,999,999')# Although that works, I need the numbers without the commas and I can't get that to work. I think I forgot to mention that I share this template with other tables