magicExcel

It can generate Excel spreadsheets from JSON streams, SQL queries and HTML tables.

A method to support CSV will be implemented in the future.

Features:

• Methods:
• build_from_table : Generate Excel document by coding HTML tables.
• build_from_json : Generate Excel document using query-format JSON
• build_from_query : Generate Excel document simply by building a query

What is new in this release:

• With build_from_table, there was a memory leak issue with formatting table cells for very large spreadsheets. Because of this issue, data cells will not be formatted by default and a new attribute has been added to build_from_table to turn it on if needed.

What is new in version 0.4.0:

• This release is a large bug fix pertaining to missing character entities in the vent of lone ampersands in the table cells.

What is new in version 0.3.1:

• Auto Column Widths (automatic, by default)
• Support for Explicit Column Widths
• Apparently my previous versions weren't applying the data formatting to the spreadsheet. This has been fixed.

Requirements:

• ColdFusion 9 or higher
• OpenOffice suite