Excell/API/Macro/Conversion

[krywarick6]

I'm writing a macro within Excel. When I transfer a cell value into a SolidWorks model dimension I divide the cell value by 1000 to get a millimeter value for the model, as in the following example:

Part.Parameter("Dim@Sketch@Model.SLDPRT").SystemValue = [cell].Value / 1000

This works fine for linear dimensions.

Problem: I want to transfer an angular value. I can't seem to figure out what the relationship is during the transfer. For instance, when I want to transfer the value of 36°, it transforms into 2063°.

Does anyone have a suggestion for a conversion factor? It doesn't appear to even be a radian value, ie. 36/360*2pi = .628pi. The closest that I can get is (36/1000) * (36/2), but this yields 37°+.

I'm totally baffled.

Regards,

Christopher Zona
Litens Automotive Partnership
Concord, Ontario, Canada

 

[pmover]

i'm baffled as well...

have you considered calculating the radian value within excel, then transferring the radian value to solidworks, and then changing the radian value to degrees in solid works? a possible workaround? not familiar with solidworks...

-pmover

 

[IRstuff]

Why are you baffled?

36 radians is 2062.6º. And given that the default angle measurement unit in Excel is radians, this makes perfect sense.

TTFN

 

[gearguru]

Krywarick6,
you can use the built-in function "degrees()" if you want to display an angle in degrees; the formula
=degrees(angle_in_radians)
is perfectly legal, see the help in excel.

I do not know details about your calculations, but if you need to convert meters (i believe) to millimeters, you need to multiply by 1000, not divide...

 

[krywarick6]

Great stuff guys, thanks for the help.

gearguru - I heed what you're saying. My reason is this: when the cell value leaves Excel and goes to SolidWorks it is interpretted a meter value when it enters SolidWorks. If the value is divided by 1000 when it leaves Excell then it is seen as a decimal meter. Otherwise I would totally agree. Thanks

Regards

Chris