The cfspreadsheet tag lets you manage Excel spreadsheets. The tag lets you do the following:

  • Read a spreadsheet file (XLS file) and store it in a ColdFusion spreadsheet object, query, CSV string, or HTML string.
  • Write a single sheet to a new XLS from a query, ColdFusion spreadsheet object, or CSV string variable.
  • Add a sheet to an existing XLS file.
    Use the spreadsheet functions to manipulate rows and columns in a spreadsheet and the data in the rows and columns. You can also specify and get comments, values, and formulas for a cell in the spreadsheet.
    Microsoft Office Excel 2007 is supported by cfspreadsheet and all the spreadsheet functions except the following:
  • SpreadSheetAddSplitPane
  • SpreadSheetAddFreezePane
    For detailed information about cfspreadsheet and all the spreadsheet functions, see CFML Reference.

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy