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

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

t.sautierr
Advisor Advisor
2,957 Views
8 Replies
Message 1 of 9

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

t.sautierr
Advisor
Advisor

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!

 

 

 

0 Likes
Accepted solutions (2)
2,958 Views
8 Replies
Replies (8)
Message 2 of 9

Rafal.Gaweda
Autodesk Support
Autodesk Support
Accepted solution

I am afraid one-by-one by API.



Rafal Gaweda
0 Likes
Message 3 of 9

Rafal.Gaweda
Autodesk Support
Autodesk Support

Example attached.



Rafal Gaweda
Message 4 of 9

t.sautierr
Advisor
Advisor

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

0 Likes
Message 5 of 9

Rafal.Gaweda
Autodesk Support
Autodesk Support
Accepted solution

 

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
0 Likes
Message 6 of 9

Rafal.Gaweda
Autodesk Support
Autodesk Support

Update 1 + acceleration results



Rafal Gaweda
Message 7 of 9

t.sautierr
Advisor
Advisor

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

0 Likes
Message 8 of 9

Rafal.Gaweda
Autodesk Support
Autodesk Support

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
0 Likes
Message 9 of 9

t.sautierr
Advisor
Advisor

got it!

0 Likes