(API) Take forces with characteristic points

[eng_leandromartins]

Hello everyone,

I searched other topics but every time I found something similar the topic was closed because it was too old.

I would like to use API to automatically transfer the results in the image below to Excel.

I thank you in advance! 

[HoshangMustafa]

@Stephane.kapetanovic 

you stated:

hi @eng_leandromartins 

sometimes, column indexes are provided on the forum; other times, you may need to search for them yourself or develop a bot.

If you can't find them, it's best to ask here.

Best Regards

What do you mean by this phrase "bot"?

Best regards

[Stephane.kapetanovic]

Hi @HoshangMustafa

I still don't see how I can help you. 

'bot' means a program that performs a search for you. In this case, look up the column indexes to make a dictionary. 

Best regards 

[eng_leandromartins]

Hi @Stephane.kapetanovic 

Do you know why when I put "Combinations", where indicated it doesn't select any combination?

[Stephane.kapetanovic]

hi @eng_leandromartins 

if you use a working and editing language in Brazilian, you can choose ‘TOD’ instead of ‘all’.

Key (Integer)	Part 1	Part 2	Part 3	Country
1	ALL	to	By	United States
33	TOU	A	P	France
34	TOD	A	CA	España (Spain)
39	TUT	a	P	Italia (Italy)
40	ALL	la	By	Romania (Romania)
44	ALL	to	By	Great Britain
48	WSZ	do	K	Polska (Poland)
49	ALL	bis	S	Deutschland (Germany)
55	TOD	para	Por	Brasil (Brazil)
70	все	до	Через	Russia
81	ALL	to	By	Japan
86	全部	至	BY	China

Best Regards

[eng_leandromartins]

Sorry, @Stephane.kapetanovic I wasn't very clear.
I want to select Combinations only. When I put "Combinations", it doesn't select any Combinations.
I'm working with the English language.

[Stephane.kapetanovic · Accepted solution]

hi @eng_leandromartins 

not knowing what type of combinations, you will have to adapt the code.

Sub SelectionAllCombinationsAPI()
  Dim RobApp As RobotApplication, Selections As RobotSelectionFactory
  Set RobApp = New RobotApplication
  
  Set Selections = RobApp.Project.Structure.Selections
  For Each Typ In Array(I_PS_CASE_COMBINATIONS, I_PS_CASE_CODE_COMBINATIONS)
    Txt = Txt & Selections.CreatePredefined(Typ).ToText & " "
  Next
  Debug.Print Trim(Txt)
  Set RobApp = Nothing
End Sub

Best Regards

[eng_leandromartins · Accepted solution]

Thank you,
It worked perfectly.
I'll leave the code in C# below for those interested.

IRobotApplication robotApp = new RobotApplication();
RobotSelectionFactory selections = robotApp.Project.Structure.Selections;
string txt = String.Empty;
foreach (var typ in new object[] {IRobotPredefinedSelection.I_PS_CASE_COMBINATIONS})
{
    txt += selections.CreatePredefined((IRobotPredefinedSelection)typ).ToText() + " ";
}
robotTable.Select(IRobotSelectionType.I_ST_BAR, "all");
robotTable.Select(IRobotSelectionType.I_ST_CASE, txt.Trim());

[Stephane.kapetanovic · Accepted solution]

RobotSelectionFactory selections = robotApp.Project.Structure.Selections;
robotTable.Select(IRobotSelectionType.I_ST_BAR, "all");
robotTable.Select(IRobotSelectionType.I_ST_CASE,
    selections.CreatePredefined(IRobotPredefinedSelection.I_PS_CASE_COMBINATIONS).ToText());

[Stephane.kapetanovic]

a simpler solution to find column indexes for your programs.

Header Explorer - Stop searching for where to find column indexes in Robot Structural Analysis