The Write Excel task will write data to a Microsoft Excel 2007 document (.xlsx) or previous Excel versions (.xls) from the contents of a RowSet variable. That variable can contain data from a database or from another file type such as

CSV

, fixed-width, or

XML

.

Writing an Excel document can be as simple as specifying the Input RowSet Variable and Output File attributes. By default, this will create an Excel document with raw unformatted data. However the Write Excel Task can also create elaborate spreadsheets with page headers, footers, titles, column headings, text formatting, and more. Almost every formatting option found in Excel is available through the options in the Write Excel Task's sub-elements.

A Template File can be specified which may contain your corporate logo and special formatting options (such as color and font themes) for creating professional spreadsheets. Formats can be overridden for individual columns and rows, which will supersede any settings you may have created in the template file.