Export monster Query to EXCEL file with multiple worksheets.

[Guest]

Hi,
I have a big problem, on export my monster datas into Excel file.
I able to generate Excel file by using CFCONTENT tag, the problem is my data rows more than 65536 rows (which more than excel maximum rows).

Is there a way that I can generate into multiple worksheets in single excel file and I can control rows for per worksheet?

Please advise,
Eric

[Guest]

Hi Expert out there , please big help on above problem!

[MikerRoo]

Check out Apache POI.

[Guest]

thanks emeraldz and MikerRoo on ur value feedback.

Emeraldz,
I tried it repeat the same data on every worksheet. Will make some changes on the cfloop.
many thanks.

[emeraldz]

Assuming you're currently using CSV format, you could always try dumping the data to Excel's XML format, in which you can specify multiple worksheets. This format works with Excel 2003, but I haven't tested it with over versions, so YMMV. The attached code is a quick example. Just make sure the output is valid XML (e.g. no extra spaces before the XML declaration, no debug output, etc).

Greg