Working with Excel spreadsheets


show more Working with Excel spreadsheets provides you with in-depth training on Developer. Taught by Daniel Short as part of the ColdFusion 9 New Features show less
please wait ...

Working with Excel spreadsheets

In ColdFusion 8, it was fairly trivial to create a very simple Excel spreadsheet. You could generate a plain old HTML table. And then tell cf content to tell the browser it was an Excel spreadsheet. Excel would open it just fine and it would be on your way. But doing anything more advanced than that was difficult and often required third-party components or software installed on the server, and let's forget about trying to read Excel spreadsheets. Cold fusion 9 changes that by giving us deep access to spreadsheets, allowing us to add new worksheets, create, edit and read the results or formulas, format rows and columns, and on and on.

There are over 30 new functions for working with spreadsheets in ColdFusion 9. In this video, we are going to cover reading and writing spreadsheets and just give you a basic introduction to using Excel with ColdFusion. So to get started in Chapter7, let's open excel.cfm. Now, the only thing I have in here is our tried and true query from Chapter 3. I...

Working with Excel spreadsheets
Video duration: 4m 56s 2h 40m Intermediate

Viewers:

Working with Excel spreadsheets provides you with in-depth training on Developer. Taught by Daniel Short as part of the ColdFusion 9 New Features

Subjects:
Developer Web
Software:
ColdFusion
Author:
please wait ...