Apply macro to Excel output with Python

Hi @lambertus​ , would it be possible to have your macro stored in an Excel template that can be used during the write process in your workspace? That might be an easier option for you if it will work in your use case.

I have done it with a shut-down script as well as with the python caller after the feature writer.

This is an example of using the python caller after the feature writer. You can go with a python shut-down script instead if you want. Very basic example that only fills in header information in the Excel document. Of course you could do all of your formatting and other manipulation that you would need here as well. In my case I am using an Excel template that contains all of my formatting for this specific report, so I just use this to fill in the header information. Not that there isn't a way to do this with pure FME, as there are many ways to go about it.

import fme
import fmeobjects
import openpyxl
 
def excel_header(feature):
    '''
    Add the project information
    headers.
    '''
    # Excel path
    excel_document = feature.getAttribute('_dataset')
    
    # Workbook
    wb = openpyxl.load_workbook(excel_document)
    
    # Worksheet
    ws = wb.active
    
    # Filename value
    filename = feature.getAttribute('_filename')
    ws['B1'] = filename
    
    # Coordinate system
    coordinate_system = feature.getAttribute('Coordinate System')
    ws['B2'] = coordinate_system
    
    # Layer
    layer = feature.getAttribute('autocad_layer')
    ws['B3'] = layer
    
    # Entity handle
    handle = feature.getAttribute('autocad_entity_handle')
    ws['B4'] = handle
    
    # Timestamp
    timestamp = feature.getAttribute('_timestamp')
    ws['B5'] = timestamp
       
    # Save the workbook
    wb.save(excel_document)

 openpyxl documentation

https://openpyxl.readthedocs.io/en/stable/