In this tutorial we will learn the basics of the Excel writer, and how to set parameters for formatting. The tutorial will make use of weather information stored in a CSV format. Let’s start FME Workbench, and generate a new workspace. For the reader, Choose CSV format and select WeatherData2009.csv as the source. For the writer, choose Microsoft Excel, and select a name and location for the new file that will be created. Open the writer parameters dialog, and set “Overwrite Existing File” to “Yes”. This will ensure that the data is overwritten, and not appended to the original file. Click OK to place the reader and writer on the canvas. The writer that appears on the canvas will create a new worksheet in our Excel Spreadsheet. Set the writer’s General Parameters Sheet Name to “Precipitation” Each worksheet that we create must have its own feature writer. Let’s add a second worksheet that we can use for our formatting. To create a new worksheet, simply copy the existing worksheet, change the name, and connect it to the CSV reader. Change the name to “High Precipitation” through the worksheet General Parameters Sheet Name. We will Use the Excel worksheet named “High Precipitation” and make changes including attribute formatting, custom number formatting, and Start Cell location. Attribute formatting includes the options for setting a new font, font colors, background fill color and pattern, text alignment, and cell protection. Attribute formatting is applied to the entire column, rather than to individual cells. Let’s make a change to the attribute “Year” so that it is displayed in bold italics. From the Font panel, click the button and set the font to Arial, the Font style to Bold Italic, and the Size to 9. Click OK to confirm the change. Custom Number Formatting allows you to format values for individual cells by using MS Excel formatting rules and formulas. Although individual cell values are formatted, keep in mind that the formula is applied for the entire column. Lets use custom number formatting to emphasize precipitation values that exceed 75mm. To do this we will select attributes from JAN to DEC. Click on the “Edit..” button, and use the “Custom Number Format” with the appropriate formula. The formula will modify the colour of numbers for individual cells; the numbers that exceed 75 will be colored red, and all other numbers will remain black. We can also modify the origin for where data will be placed by defining its start cell location. From the Format Parameters tab, expand the Start Position by clicking on the arrow. A new Start Column=3, and the Start Row=2. Run the workspace Open the newly created Excel spreadsheet. Two new worksheets have been created, one for each writer that we used. In addition, notice how the formatting changes made to the “High Precipitation” worksheet do a much better job of communicating the trends for precipitation by year and month.