Html to excel (advanced)

[david_sternberg]

I know how to add the following code to the top of the a .cfm file in order to
put the code in an excel format. <!--- These two lines are what put this into
an excel spread sheet format---> <CFHEADER NAME='content-disposition'
VALUE='attachment; filename=results.xls'> <!--- Set the content type of the
file.---> <CFCONTENT TYPE='text/tabdelimited'> This is the easy part. But now
I have spoiled my users and they want to split the data up into different
sheets in the .xls file. Does anyone have any idea how to do this? I've looked
everywhere but cannot determine if this can be done. Be my hero and show me a
way. Thanks Dave

[philh]

Hi Dave, You definitely have to interact with the Excel DLL to do this, or,
heaven forbid, roll your own mso:namespace stuff. I don't envy you. Someone
out there probably has some concrete examples; keep your ear to the ground.

[cf_menace]

If you're using CFMX, you can use java to access the Excel format using [url]http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA[/url] has code examples.

[david_sternberg]

Thanks. I'm just going to tell them. It can't be done. I have too many other things to do that require my attention.

Dave