Using jXLS and jXLSUtiltiy.cfc to export Excel files - multiple sheets
Just an update on using jXLS. In my last post about it I said I haven't yet attempted an Excel file with multiple sheets. Well I just did and it works with no further code changes on my end. You simply put additional tag markup in a second sheet and boom, it's there.
I definitely recommend this to anyone who needs to export complicated excel spreadsheets (i.e., anything more than just a simple list/query dump).