I have a cfcomponent that takes in query and export it directly to an *.xls spreadsheet. It is currently create onle a single sheet but it can be modify to do multiple.
Interested? Let me know and I'll upload it for ya (code is on the machine, have to burn it to a CD).
Otherwise, you can go here: http://www.google.com/url?sa=t&source=web&ct=&cd=1&url=http%3A%2F%2Fwww.bennadel.com%2Fpro jects%2Fpoi-utility.htm&ei=yubdSZ-9KprMMpfozPIJ&usg=AFQjCNGZB4m35AIvsZ2tmBgSh9SPrCGogA&sig 2=H3ZtvVjY-L-DdPGWO8FCVA
Very interested! Thank you. Is the link below to the latest and greatest?
The code is below, need your logic to seperate the data by year. You need POI, version 2.5.1 Final, otherwise the latest stable version is 3.2 Final, you can download it here http://poi.apache.org/.
Check your ColdFusion8\lib, CFusionMX7\lib (or any other version of CF) directory for poi**.
I created before I found similar solution from Ben Nadel - POI Utility Component, would have use it to save time writing the code.
Use at your own risk It has been tested by the client that I work for so it should be fairly stable.
Edited: For some reason, HTML block hides the code, see the attached file instead.
POIHSSFUtility.cfm.txt 8.0 K