Microsoft Excel Writer Parameters

By default, this option is set to No, which means that features will be written to the original file. Select Yes to delete an existing file before writing out any features. If a template file is selected, this parameter is ignored and the destination file will be deleted before writing out any features.

If you specify a template file, the writer will make a copy of the template file in the location specified in the Destination Microsoft Excel File parameter. All operations will be performed on the copy: the template file specified remains unchanged. If a template file is used, the destination file will always be overwritten, regardless of what is chosen for the Overwrite Existing File parameter.

When you specify a Template File, you can select one of the sheets as the template sheet. Click the browse button to view the list.

Named ranges that exist on the template sheet are not duplicated.

The writer feature type option to Drop Existing Sheet/Named Range is irrelevant if specifying a template sheet, since the existing sheet will always be replaced by the template sheet. However, the writer feature type option to Truncate Existing Sheet/Named Range is applied to template sheets before being copied to the destination file.

To access writer feature type options, open the Feature Type Properties dialog by clicking the settings button on a feature type in the workspace.

• Drop sheet: Worksheets are deleted and recreated after all existing sheets. (The sheet order may change.)
• Drop named range: Formatting and data in the extents of the existing named range are lost, but formatting in cells that exist outside the named range is unaffected. Original extents of the named range are lost. A new named range is created using the numbers specified in the Feature Type parameters Named Range Start Column and Named Range Start Row.

If a template file or template sheet are specified as writer options, the option to truncate existing sheets or named ranges is applied to the template sheet before it is copied to the destination file. Inserted items such as charts and pictures are not deleted.

• Truncate sheet: Formatting such as cell color and column widths that exist in cells outside the data extents remain.
• Truncate named range: Formatting in the extents of the existing named range is lost, but formatting in cells outside this existing named range is unaffected.

The the Feature Type parameters Named Range Start Column and Named Range Start Row are ignored.

Data written to the named range use the original start positions and begin writing at the specified offset.

Note that worksheet names must be less than 31 characters in length.

This parameter specifies whether or not to write the headers of the attributes. This parameter has an effect only if the sheet is being created (which happens when it is new or if it is being dropped). Existing sheets either in the output file or from a template file will not have header rows added to them.

This parameter specifies a relative order of the feature type. Valid values are all positive integers (starting from 1).

The sheet with the lowest relative order will be the first sheet in the workbook, with sheets having a higher order placed after it. If a value is not specified, then the sheet will be placed after all sheets with a specified sheet position. If two sheets have identical sheet position values, then the two will be ordered according to their incoming order.

If the sheet feature type has no specified position, but it contains a named range feature type which does, then the position on the named range will be used. If the sheet with no position contains two named ranges with different sheet positions, then one of those values will be selected arbitrarily (therefore, to avoid ambiguity, it is always best to specify the position on the sheet feature type directly).

Example

If you write 7 sheets in the form of [sheetName,sheetPosition]

{(A, ),(B,9),(C, ),(D,4),(E,4),(F, ),(G,2)}

the sheets are written in the order

G,D/E,B,A/C/F

where the order of (A/C/F) and (D/E) are dependent on their incoming order to the writer.

Using Feature Type Fanout will pass the sheet order of the template feature type to all its fanned out feature types. (See the topic Setting Feature Type Fanout in FME Workbench help.)

For additional information, please see Writer Mode Specification.

This determines which raster format will be used for rasters written to the workbook. There are three supported options

• JPEG
• PNG
• BMP

When sending a raster feature to the writer, there are a few attributes you can add to modify the result.

Attribute Name	Description
xlsx_row_id	Determines the row that the top of the picture will be placed onto. Only positive integer values are valid. If not specified, this value will default to 1.
xlsx_col_id	Determines the column on which the left of the picture will be placed. Only positive integer values or the Microsoft Excel Column letter designations (A,B,..,XFD) are valid. If not specified, this value will default to A (1).
xlsx_raster_scale_factor	Allows the raster to be scaled by a factor. This can be any positive numeric value greater than 0.0. If not specified, the raster will be written out using the xlsx_raster_height and xlsx_raster_width. If specified, xlsx_raster_height and xlsx_raster_width will be ignored. For example, a scale factor of 2.0 will double the width and height of the raster.
xlsx_raster_height	Sets the raster height to the specified number of pixels. Only positive integer value greater than 0 are valid. If xlsx_raster_scale_factor is specified, this value will be ignored. If this is used, you should also specify xlsx_raster_width. If neither is specified, the raster will default to its actual size.
xlsx_raster_width	Sets the raster width to the specified number of pixels. Only positive integer value greater than 0 are valid. If xlsx_raster_scale_factor is specified, this value will be ignored. If this is used, you should also specify xlsx_raster_height. If neither is specified, the raster will default to its actual size.