excel python interface

See more:

Python

MS-Excel

i am working project where ANAYS WORKBENCH is interfaced with MS EXCEL via python script.

# IronPython imports to enable Excel interop
import clr
clr.AddReference("Microsoft.Office.Interop.Excel")
import Microsoft.Office.Interop.Excel as Excel

workingDir = AbsUserPathName("C:\Users\shreepal\Downloads\Compressed/")

def updateHandler():

    # Define key ranges in the Workbook
    lenCell = worksheet.Range["B6"]
    ldCell = worksheet.Range["B7"]
    dfCell = worksheet.Range["B8"]

    # Get the Workbench Parameters
    lenParam = Parameters.GetParameter(Name="P1")
    ldParam = Parameters.GetParameter(Name="P2")
    dfParam = Parameters.GetParameter(Name="P3")

    # Assign values to the input parameters
    lenParam.Expression = lenCell.Value2.ToString()
    ldParam.Expression = ldCell.Value2.ToString()

    # Mark the deformation parameter as updating in the workbook
    dfCell.Value2="Updating..."

    # Run the project update
    Update()

    # Update the workbook value from the WB parameter
    dfCell.Value2 = dfParam.Value.Value


# Open the Workbench Project
Open(FilePath = workingDir + "ExcelParameterScripting.wbpj")

# Open Excel and the workbook
ex = Excel.ApplicationClass()
ex.Visible = True
workbook = ex.Workbooks.Open(workingDir + "ParameterExample.xlsm")
worksheet=workbook.ActiveSheet

#Apply the update handler to the workbook button
OLEbutton = worksheet.OLEObjects("CommandButton1")
OLEbutton.Object.CLICK += updateHandler

This code will launch Excel and Workbench and add the command to execute the update script when we push the button in excel.

**problem is that the action to update the spreadsheet and model is assigned as an OLEObject to the button. Unfortunately this is only active when the script is running. Once it is done the click action is removed, and the button becomes useless. can anyone provide me the code for this button which will able to update the system as many times it is clicked?**