Demo11
Example heading with h2 size
Example heading with h3 size
Following is sample java code.
import win32com.client as wc
import clr
import model_path as modelPath
def setup(maport_config_file):
try:
# Add CLR references
clr.AddReference(
"ASAM.XIL.Implementation.TestbenchFactory, Version=2.1.0.0, Culture=neutral, PublicKeyToken=fc9d65855b27d387")
clr.AddReference("ASAM.XIL.Interfaces, Version=2.1.0.0, Culture=neutral, PublicKeyToken=bf471dff114ae984")
clr.AddReference(
"ASAM.XIL.Implementation.FrameworkFactory, Version=2.1.0.0, Culture=neutral, PublicKeyToken=d64b0277da8a2c74")
# Import XIL API.NET classes from the .NET assemblies
from ASAM.XIL.Implementation.TestbenchFactory.Testbench import TestbenchFactory
from ASAM.XIL.Interfaces.Testbench.Common.Error import TestbenchPortException
from ASAM.XIL.Interfaces.Testbench.MAPort.Enum import MAPortState
MyTestbenchFactory = TestbenchFactory()
MyTestbench = MyTestbenchFactory.CreateVendorSpecificTestbench("dSPACE GmbH", "XIL API", "2018-B")
MyMAPortFactory = MyTestbench.MAPortFactory
MyValueFactory = MyTestbench.ValueFactory
print("Creating MAPort instance...")
# Create an MAPort object using the MAPortFactory
DemoMAPort = MyMAPortFactory.CreateMAPort("DemoMAPort")
print("...done.\n")
# Load the MAPort configuration
print("Configuring MAPort...")
DemoMAPortConfig = DemoMAPort.LoadConfiguration(maport_config_file)
# Apply the MAPort configuration
DemoMAPort.Configure(DemoMAPortConfig, False)
print("...done.\n")
if DemoMAPort.State != MAPortState.eSIMULATION_RUNNING:
# Start the simulation
print("Starting simulation...")
DemoMAPort.StartSimulation()
print("...done.\n")
return DemoMAPort, MyValueFactory
except TestbenchPortException as ex:
print("A TestbenchPortException occurred:")
print("CodeDescription: %s" % ex.CodeDescription)
print("VendorCodeDescription: %s" % ex.VendorCodeDescription)
raise
except Exception as e:
print("An unexpected error occurred:", e)
raise
def readFromExcel(row, col):
try:
# Dispatch Excel application
ApplicationExcel = wc.Dispatch("Excel.Application")
ApplicationExcel.Visible = False
# Open the workbook
workbook = ApplicationExcel.Workbooks.Open(modelPath.ExcelFilePath)
# Access the first sheet
sheet = workbook.Sheets(1)
# Read the value from the specified cell
value = sheet.Cells(row, col).Value
# Close the workbook without saving
workbook.Close(SaveChanges=False)
# Quit the Excel application
ApplicationExcel.Quit()
return value
except Exception as e:
print("An error occurred:", e)
if 'ApplicationExcel' in locals():
ApplicationExcel.Quit()
def writeToExcel(row, col, value):
try:
# Dispatch Excel application
ApplicationExcel = wc.Dispatch("Excel.Application")
ApplicationExcel.Visible = False
# Open the workbook
workbook = ApplicationExcel.Workbooks.Open(modelPath.ExcelFilePath)
# Access the first sheet
sheet = workbook.Sheets(1)
# Write the value to the specified cell
sheet.Cells(row, col).Value = value
print(f"Written value '{value}' to cell ({row}, {col})")
# Save the workbook
workbook.Save()
# Close the workbook
workbook.Close()
# Quit the Excel application
ApplicationExcel.Quit()
except Exception as e:
print("An error occurred:", e)
if 'ApplicationExcel' in locals():
ApplicationExcel.Quit()
def KL30_off(row):
try:
path1 = modelPath.kl30
value = readFromExcel(row, 6)
return path1, value
except Exception as e:
print("An error occurred in KL30_off:", e)
def KL30_on(row):
try:
path = modelPath.kl30
val = readFromExcel(row, 6)
value = 0
if val == "left":
value = 1
elif val == "right":
value = 2
elif val == "both":
value = 3
return path, value
except Exception as e:
print("An error occurred in KL30_on:", e)
def can_write(row):
try:
signal_name = readFromExcel(row, 5)
value = readFromExcel(row, 6)
path1 = modelPath.canWrite + signal_name + "/Value"
return path1, int(value)
except Exception as e:
print("An error occurred in can_write:", e)
def can_read(row):
try:
global path
signal_name = readFromExcel(row, 5)
value = readFromExcel(row, 6)
path = None
if signal_name == "Low_beam" or signal_name == "High_beam":
path = modelPath.canReadSLML + "/" + signal_name + "Sts_L"
return path, value
except Exception as e:
print("An error occurred in can_read:", e)
def vol_write(row):
try:
value = readFromExcel(row, 6)
path = modelPath.batteryVoltWrite
return path, value
except Exception as e:
print("An error occurred in vol_write:", e)
def LED_read(row):
try:
value = readFromExcel(row, 6)
signal = readFromExcel(row, 5)
path = "LEDModelPath/" + signal
return path, value
except Exception as e:
print("An error occurred in LED_read:", e)
def ExtNtc_write(row):
try:
value = readFromExcel(row, 6)
signal = readFromExcel(row, 5)
path = "ExtNtc_write_Model_path/" + signal
return path, value
except Exception as e:
print("An error occurred in ExtNtc_write:", e)
def InNtc_write(row):
try:
message = readFromExcel(row, 4)
value = readFromExcel(row, 6)
path = "InNtc_write_model_path/" + message
return path, value
except Exception as e:
print("An error occurred in InNtc_write:", e)
def performTask(first_cell_value, row):
try:
if first_cell_value == "KL30_off":
return KL30_off(row)
elif first_cell_value == "KL30_on":
return KL30_on(row)
elif first_cell_value == "can_write":
return can_write(row)
elif first_cell_value == "vol_write":
return vol_write(row)
elif first_cell_value == "can_read":
return can_read(row)
elif first_cell_value == "LED_read":
return LED_read(row)
elif first_cell_value == "ExtNtc_write":
return ExtNtc_write(row)
elif first_cell_value == "InNtc_write":
return InNtc_write(row)
else:
return None, None
except Exception as e:
print("An error occurred in performTask:", e)
import win32com.client as wc
import common_def as common_def
from Auto import model_root
def main():
try:
excel = wc.Dispatch("Excel.Application")
excel.Visible = False
workbook = excel.Workbooks.Open(model_root.ExcelFilePath)
for sheet in workbook.Sheets:
print(f"Sheet: {sheet.Name}")
used_range = sheet.UsedRange
num_rows = used_range.Rows.Count
num_columns = used_range.Columns.Count
start_row = 4 # Corresponding to row C4
start_col = 3 # Corresponding to column C
path, value = common_def.can_read(7)
print(path, value)
for row in range(start_row, num_rows + 1):
first_cell_value = common_def.readFromExcel(row, start_col)
if first_cell_value:
print(row, start_col, first_cell_value)
if first_cell_value in ("LED_read", "can_read"):
path, value = common_def.performTask(first_cell_value, row)
print(path, value)
elif first_cell_value.endswith(("write", "on", "off")):
path, value = common_def.performTask(first_cell_value, row)
print(path, value)
else:
print(f"Skipping row {row}")
except Exception as e:
print("An error occurred in main:", e)
if 'excel' in locals():
excel.Quit()
finally:
if 'excel' in locals():
excel.Quit()
if __name__ == "__main__":
main()
'''