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

[t.sautierr]

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!

[Rafal.Gaweda · Accepted solution]

I am afraid one-by-one by API.

[Rafal.Gaweda]

Example attached.

[t.sautierr]

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

[Rafal.Gaweda · 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]

Update 1 + acceleration results

[t.sautierr]

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

[Rafal.Gaweda]

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

[t.sautierr]

got it!