Like PERL, Python is also commonly used to perform engineering tasks or to build more complex software.

If your company programming history is more Python oriented, it might be interesting to know how to use Python to pilot Excel or other application that are exposing a OLE object.

Here is an example of a Python script that calls Excel

import win32com.client
    excel = win32com.client.Dispatch('Excel.Application')
    excel.Workbooks.open(ficXls)
    #parcours de la zone de données
for li in zoneLi:
        Coord=[]
        Coord.append(id)
        id=id+1
        for col in zoneCol:
            valeur=excel.ActiveSheet.Cells(li,col).Value
             Coord.append(valeur)

In this post category, I will add the different codes that I know when you use Python for your enginerring work or for your development tools.