Generating Workbooks

Title CF Source Output Description
Simple Workbook source workbook An example in the simplest form. A workbook with one sheet and two rows, no styles or fonts specified.
Cell Types source workbook An example showing the different types available to each cell. The type "string" is always the default.
Cell Types and Styles source workbook An example that shows how to assign fonts to each cell and change the style of the cell. Also shows how to merge cells and set the column span for a cell.
Default Fonts and Styles source workbook An example that shows how to set default styles and fonts for an entire workbook.
Global Styles source workbook An example that shows how to designate styles and fonts before outputing your data (Global Styles). This removes the duplication of style information at each cell and makes code maintenance much easier.
Multiple Sheets and Printing Attributes source workbook An example that shows how to create multiple sheets per workbook. We also explore how to set some of the possible printing attributes.
Multiple Sheets and Printing Attributes source workbook An example similiar to Sample 6 but we populate the workbook based on data from a database.

Reading Workbooks

Title CF Source Input Description
Simple Import source workbook An example showing how to read in an excel file without header rows.
Import with Header Rows source workbook An example showing how to read in an excel file with header rows.
Get Sheet Names source workbook An example that shows how to get a list of the names of each sheet in the workbook.
Get Column Names source workbook An example that shows how to get a list of the names for each column of a workbook sheet.

Quick Report Tag

Title CF Source Output Description
Simple Report source workbook An example that shows how to generate a simple Excel report with one single line of code using cf_xls_quickreport.