Weld Worksheet allows you to scope weld controls for the weld curves. Weld Worksheet scripting allows you to record the worksheet editing for automation. It enables you to select and edit multiple cells in a column in the worksheet.

To activate Weld Worksheet:

weld.UseWorksheet = YesNoType.Yes #Activates the worksheet.

To search for the Weld control with the given text:

weld.NameFilter = ‘’  #Enter the text to search for inside the ‘’.
weld.WeldWorksheetCreateControlForCurveBodies()​ #Creates weld control for the curve bodies.

To export the weld worksheet:

weld.WeldWorksheetExport("FilePath") #Exports the worksheet entries as .csv file and save it to the given file path.

To import the weld worksheet:

weld.WeldWorksheetImport("FilePath") #Import the worksheet parameters as .csv file from the given file path.

To set the Edge Mesh Size in the worksheet:

row_id =[2]   #Add the row id. Here, the row id is 2. Multiple row id can be added with comma separation.
edgemesh_size=2.0 #Define the size of the edge mesh.
weld.SetWeldWorksheetEdgeMeshSize([row id], edgemesh_size) 

To set the Weld Angle in the worksheet:

row_id =[1]   #Add the row id. Here, the row id is 2. Multiple row id can be added with comma separation.
weld_angle=30 #Define the weld angle.
weld.SetWeldWorksheetWeldAngle([row_id], weld_angle) 

To set the Offset Layer Height in the worksheet:

row_id = [1] #Add the row id. Multiple row id can be added with comma separation.
offset_layer_height = 30 #Define offset layer height.
weld.SetWeldWorksheetOffsetLayerHeight([row_id], offset_layer_height)​

To set the Number of Layers in the worksheet:

row_id = [1] #Specify the row id. Multiple row id  can be added with comma separation.
num_layers = 1 #Define the required number of layers.
weld.SetWeldWorksheetNumLayers([row_id], num_layers)​

To set the Offset Layer Growth Rate in the worksheet:

row_id = [1] #Specify the row id. Multiple row id can be added with comma separation.
offset_layer_growth_rate = 1.3 #Define the growth rate for offset layer
weld.SetWeldWorksheetOffsetLayerGrowthRate([row_id], offset_layer_growth_rate)

To set the Sharp Angle in the worksheet:

row_id = [1] #Specify the row id. Multiple row id can be added with comma separation.
sharp_angle = 20 #Define the sharp angle.
weld.SetWeldWorksheetSharpAngle([row_id], sharp_angle)

To set the Absolute Tolerance in the worksheet:

row_id = [1] #Specify the row id. Multiple row id can be added with comma separation.
absolute_tolerance= 10 #Define the absolute tolerance.
weld.SetWeldWorksheetAbsTol([row_id], absolute_tolerance) 

To set the Lap Angle Tolerance in the worksheet:

row_id = [1] #Specify the row id. Multiple row id can be added with comma separation.
lapangle_tolerance= 10 #Define the lap angle tolerance.
weld. SetWeldWorksheetLapAngleTol([row_id], lapangle_tolerance)

To set the Material Id in the worksheet:

row_id = [1] #Specify the row id. Multiple row id can be added with comma separation.
material_id= 10 #Specify the material id.
weld.SetWeldWorksheetMaterialId([row_id], material_id)

To set the Smoothing in the worksheet:

row_id = [10] #Specify the row id. Multiple row id can be added with comma separation.
smoothing= 0 #Set Smoothing to No. 0 is the default value. 1 - Enables Smoothing and 0 - Disables Smoothing.
weld.SetWeldWorksheetSmoothing([row_id], smoothing)

To enable the Generated End-Caps in the worksheet:

row_id = [3] #Specify the row id. Multiple row id can be added with comma separation.
generate_endcaps= 0 #Generates triangular end caps at the free ends of the weld.	
weld.SetWeldWorksheetGenerateEndCaps(row_id, generate_endcaps)