Robot Structural Analysis Forum
Welcome to Autodesk’s Robot Structural Analysis Forums. Share your knowledge, ask questions, and explore popular Robot Structural Analysis topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

(API) - Exporting modal harmonic load case - getting FRF results

8 REPLIES 8
SOLVED
Reply
Message 1 of 9
t.sautierr
2490 Views, 8 Replies

(API) - Exporting modal harmonic load case - getting FRF results

Hello,

 

I’m having some issues exporting a set of data tables from Robot to Excel. I have some 48 tables I want to export, which correspond to 48 FFR response function results. Apparently I cannot gather the whole 48 cases in on single table, so I am currently exporting the tables one by one. Is there any way to export a set of tables all at once (in one or several *.xls/ *.csv files)?

 

API ? Excel?

 

Thank you!

 

 

 

8 REPLIES 8
Message 2 of 9
Rafal.Gaweda
in reply to: t.sautierr

I am afraid one-by-one by API.



Rafal Gaweda
Message 3 of 9
Rafal.Gaweda
in reply to: Rafal.Gaweda

Example attached.



Rafal Gaweda
Message 4 of 9
t.sautierr
in reply to: Rafal.Gaweda

Thanks a lot .. works perfectly !

 

One sapre question : is there any document that lists which columns number is related to which result ?

 

"

Set RT = RobApp.Project.ViewMngr.CreateTable(I_TT_NODE_DISPLACEMENTS, I_TDT_DEFAULT)

RT.Select I_ST_NODE, Nselection
RT.Select I_ST_CASE, Str(FRFCasenumber)
RT.AddColumn (1783) 
RT.AddColumn (1784)
RT.AddColumn (1785)

this is where you get the speed result ? Ihave found the number for acceleration but do you the list for all numbers?
Path = TempFolder + "\" + "FRF case " + Str(FRFCasenumber) + " results.txt"
RT.Printable.SaveToFile Path, I_OFF_TEXT
Open Path For Input As #hFile
OpenTextFileToString = Input$(LOF(hFile), hFile)
Close #hFile

AdjustString OpenTextFileToString, k"

 

Thanks

Message 5 of 9
Rafal.Gaweda
in reply to: t.sautierr


 

One sapre question : is there any document that lists which columns number is related to which result ?

 

No, get columns numbers first from opened table by you in robot

Then use them in RT.AddColumn

 



Rafal Gaweda
Message 6 of 9
Rafal.Gaweda
in reply to: Rafal.Gaweda

Update 1 + acceleration results



Rafal Gaweda
Message 7 of 9
t.sautierr
in reply to: Rafal.Gaweda

Yes We manage to do that and also to export in .csv file !

 

I think I'll try to make something more general to edit any data I want in .csv file, but still don't understand How do you that to get acceleration for exemple, you have to addcolumn 1789 or XXXX ? We is that piece of information?

 

Thx and good we.

 

TS

Message 8 of 9
Rafal.Gaweda
in reply to: t.sautierr

Chenges in the code made

 

    RT.AddColumn (1789)
    RT.AddColumn (1790)
    RT.AddColumn (1791)
    RT.AddColumn (1792)
    RT.AddColumn (1793)
    RT.AddColumn (1794)

 

        For j = 1 To 9 ' 9 here

 



Rafal Gaweda
Message 9 of 9
t.sautierr
in reply to: Rafal.Gaweda

got it!

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums