Hi I am trying to determine the best way to create an excel spreadsheet.
Currently we have either written a comma delimited file or created an html table and used cfcontent to give it a mimetype which excel recognises. The problem is that spreadsheets generated this way tend to be quite large. Unfourtently we have a client who despite our advice would like to be able to generate an excel spreadsheet with around 11k rows. Are there any other ways? I've had a look at cfcomet and it appears you can use ADO on the server to generate a spreadsheet however it would appear that this requires excel on the server which our sysadmin people refuse to do for security reasons. Is there a better way? DO i actually need excel on the server to use ADO? Thanks Kola ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
