The Microsoft Excel writer writes attribute records into a spreadsheet. The writer provides the following capabilities:
Table Creation: The Microsoft Excel writer uses the information within the FME workspace (mapping file) to automatically create worksheets and named ranges as required. All worksheets and named ranges will be created when the first input feature is processed. If no features are sent to a feature type, then the corresponding worksheet or named range will not be created. However, creating an empty worksheet or named range is still possible by sending a feature with no attributes to the corresponding feature type. All feature types that belong to the same Excel Sheet are created on receiving the first feature destined for that Excel Sheet.
Images: Images can be written to destination Excel files in either JPEG or PNG form. Unlike other data, images are not constrained to the cells of the worksheet.
By default, images will be written without positioning and will display with the top left corner of the image at cell 0,0. Specifying the xlsx_row_id and xlsx_col_id will allow for the positioning of the image in the sheet and identify the top left corner starting point.
By default, images will be written using their original size. The size of the image can be adjusted by specifying either the xlsx_raster_width and xlsx_raster_height format attributes or by specifying xlsx_raster_scale_factor which allows for a positive scale factor to multiply both the width and height with, maintaining aspect ratio. If both are specified, the scale factor is preferred over the explicit width and height.
Note that the feature type level Start Column and Start Row affect the cell-based value start location but do not affect the position of the raster. Use the xlsx_row_id and xlsx_col_id attributes instead.
Images can be relocated inside the Excel application once written with the Excel writer.
Multiple Worksheets and/or Named Ranges: One writer can have multiple worksheets and/or named ranges created in a new or existing spreadsheet, including multiple named ranges on a single sheet.
Writer Mode Specification: The Microsoft Excel writer allows you to specify what to do with incoming features.
Writer mode can be specified at three levels: the writer level that sets the starting value for each of the feature types, the feature type level, or on individual features (via the fme_db_operation format parameter).
Microsoft Excel Workbench Writer Parameters