Different manual combination table

[Konrad.O]

WIP

A copy of the archived "Different manual combination table" topic:

https://forums.autodesk.com/t5/robot-structural-analysis-forum/editing-load-cases-in-excel-api/m-p/8... 

[bac5VG3Q]

Hello, 

Regarding these comments, I would like to make sure that Robot API is not able to copy the load table (single loads) to Robot through VBA. I found this video that shows how a single load is created (minute 20:20):

https://www.youtube.com/watch?v=6Kv4zqgRGOo&list=RDCMUCQA3aXtNDnsT80V59qQmKGQ&start_radio=1&rv=6Kv4z...

I would like to do the same with a loop so a total of 100 or 200 loads are applied to the Robot model from a predefined excel sheet.

Thanks for your help.

[Stephane.kapetanovic]

hi @bac5VG3Q 

Obtaining a copy of the complete table seems not implemented but it is possible to iterate line by line.

this youtube example shows the creation of a load record with API from VBA. In your case you can create a loop through an algorithm or an Excel table.

Best regards

[WALIDGIO]

hello,

i used to copy this type of excel table to Robot in this format as it is in Robot Tables

as it is in RSA 

But in your sheet the nature of cases is now showing,

please can you add case nature and if it possible to format the table as showing in the image

can you solve it thank you

[Stephane.kapetanovic]

hi @WALIDGIO 

the macro contained in "RMI_loadcomb_nested_with_subnatures_3" that you're using isn't based on emptying your project table as it is. Instead, it allows you to edit, modify and rewrite combinations directly from Excel to the Case Server.
However, the case natures encountered during reading are listed in the "Basic" tab in J2 "Available case natures names" and in C3 and following on a case-by-case basis.
As this is a free program, you can modify it as you see fit.

Best Regards

[WALIDGIO]

Yes, I'm trying to import seismic Cases but it only load Basic case

but my combination includes seismic cases how to add the in the sheet