Excel output in one cell

Joined: 03 May 2006

Posts: 2

can you post some of the code so we can determine the problem?Mehul Thakkar <mehul_303@...> wrote: All,I am experiencing a wierd problem with the CFCONTENT downloading an excel file. It puts the whole out put in one single cell even though I am using chr(9) for tab and chr(10) and chr(13) for carriage return, line feed. The wierd part of it is, it works if I change my CFFORM tag to FORM but as soon as I make it CFFORM it put the data in one single cell.I am on CFMX 6.1.Any ideas or suggestions ?Thanks,MehulYahoo! Groups Links<*> To visit your group on the web, go to:http://groups.yahoo.com/group/cold_fusion/<*> To unsubscribe from this group, send an email to:cold_fusion-unsubscribe@yahoogroups.com<*> Your
use of Yahoo! Groups is subject to:http://docs.yahoo.com/info/terms/-hankcfman

Joined: 04 May 2006

Posts: 2

Excel output in one cell

Hi Mehul,

I faced this problem and solved by one tricky method, can you please try this.

1. First you design in excel file (spread sheet) how you want the result
2. then save it as html for that you have option in excel (save as webpage)
3. Now you got html file with excel style sheets, save this file as .cfm
4. and do the corresponding changes in the necessary place(I mean whatever cfquery and cfoutput).
5. put the cfcontent on the top of the page then it will work fine

Thanks
Mahesh
On 5/3/06, Mehul Thakkar <mehul_303@...> wrote:

All,I am experiencing a wierd problem with the CFCONTENT downloading an excel file. It puts the whole out put in one single cell even though I am using chr(9) for tab and chr(10) and chr(13) for carriage return, line feed. The wierd part of it is, it works if I change my CFFORM tag to FORM but as soon as I make it CFFORM it put the data in one single cell.I am on CFMX 6.1.Any ideas or suggestions ?
Thanks,Mehul

YAHOO! GROUPS LINKS

Visit your group "cold_fusion" on the web.
To unsubscribe from this group, send an email to:
cold_fusion-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Joined: 04 May 2006

Posts: 2

Excel output in one cell

Hi Mehul,

I faced this problem and solved by one tricky method, can you please try this.

1. First you design in excel file (spread sheet) how you want the result
2. then save it as html for that you have option in excel (save as webpage)
3. Now you got html file with excel style sheets, save this file as .cfm
4. and do the corresponding changes in the necessary place(I mean whatever cfquery and cfoutput).
5. put the cfcontent on the top of the page then it will work fine

Thanks
Mahesh
On 5/3/06, Mehul Thakkar <mehul_303@...> wrote:

All,I am experiencing a wierd problem with the CFCONTENT downloading an excel file. It puts the whole out put in one single cell even though I am using chr(9) for tab and chr(10) and chr(13) for carriage return, line feed. The wierd part of it is, it works if I change my CFFORM tag to FORM but as soon as I make it CFFORM it put the data in one single cell.I am on CFMX 6.1.Any ideas or suggestions ?
Thanks,Mehul

YAHOO! GROUPS LINKS

Visit your group "cold_fusion" on the web.
To unsubscribe from this group, send an email to:
cold_fusion-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

freelanceprogrammers.org Forum Index » Cold Fusion

Excel output in one cell