XLSAdapter is a ColdFusion module that provides extensive support for Microsoft's Excel file format. The module is a collection of custom tags that allow the creation and reading of Excel files using a pure java solution. XLSAdapter gives the developer complete control over nearly every Excel feature. These include but are not limited to.
Features
- Creation of Excel workbooks (Microsoft Excel 97 file format) without using a COM solution.
- Reading Excel workbooks(Microsft Excel 97 file format) into a ColdFusion query.
- Extensive support for setting styles for each cell. These include setting the font (family, size, weight, underline, italics), borders, data formats, data types, horizontal/vertical alignment and wrapped text.
- Easy formula building using reference IDs.
- Multiple sheets per workbook.
- Headers and footers for each sheet.
- Support for individual print setups for each sheet of a workbook. This includes orientation, scalings, fitting to a x pages in width and/or height, header/footer margins, page margins, horizontally/vertically centering and printing gridlines.
- Support for print areas, repeating rows, freeze panes and merged cells.
- Support for exporting ColdFusion queries to workbooks with a single line of code.
- Intuitive style and font specification that is modeled after cascading style sheets.
- Tags included: cf_xls_workbook, cf_xls_font, cf_xls_style, cf_xls_sheet, cf_xls_printsetup, cf_xls_printarea, cf_xls_header, cf_xls_footer, cf_xls_freezepane, cf_xls_repeatingrows, cf_xls_mergedcells, cfx_XLSReader and cf_xls_quickreport.
- Supports ColdFusion MX and ColdFusion MX 7.
- A downloadable demo, online examples, online documentation and support available.