Could anyone give advice with using AttachToExcel

[idslk]

Hello Colleagues,

Is anyone out there, who knows how to use this function?


If i use ParameterTypes.Distance i get:
System.Runtime.InteropServices.COMException (0x80040310): Invalid length unit given for distance parameter
If i use ParameterUnits.Centimeters i get:
Microsoft.Scripting.ArgumentTypeException: expected ParameterTypes, got ParameterUnits

There is only one number in the used Excelfile in Cell 'A1'.

TIA
Stefan

 

[oldfox]

If i use ParameterUnits.Centimeters i get:

Hi Stefan, have you tried: ParameterTypesUnits.Centimeters ?

 

[idslk]

Hello Chris,

thanks for your reply, read it and tested it a few moments ago...no luck...

Regards
Stefan

 

[oldfox]

Well, that's all I had. Really a shot in the dark. Hope you find something that works.

 

[NateLiquidGravity]

I couldn't get it to work either.

 

[simonb65]

Sounds like a question for @ajayre (a.k.a The Script Guru)!

 

[idslk]

@simonb65 and @NateLiqGrav,
thanks for your confirmation

 

[albie0803]

Looking at this again I came across

# create parameter with specific units
WidthParam = MyPart.AddParameter('Width', ParameterTypes.Distance, ParameterUnits.Centimeters, 7.32)

should it be ?????

AttachToExcel('C:\Users\Allan\Test.xlsx', 'Sheet1', 'A1', ParameterTypes.Distance, ParameterUnits.Centimeters)

just a stab in the dark, I really have no idea

 

[NateLiquidGravity]

I tried it like that (and other variations) earlier. It seems like something is just unfinished.

 

[ajayre]

This is a bug. Albie is correct that the last parameter should be units not parameter type, e.g. UnitTypes.Centimeters. Will be fixed for the next release.

Andy

 

[idslk]

Thank you Andy.
Could you please also throw some light on https://www.alibreforum.com/forum/index.php?threads/how-to-set-a-referencesketchpoint.20883/ ?

Regards
Stefan