Whatever message this page gives is out now! Go check it out!

Using cfspreadsheet

Last update:
May 18, 2026
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.

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page