topic Re: Exporting modal harmonic load case in Robot Structural Analysis Forum

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

t.sautierr — Mon, 03 Jun 2013 07:21:14 GMT

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!

Re: Exporting modal harmonic load case

Rafal.Gaweda — Fri, 31 May 2013 09:06:41 GMT

I am afraid one-by-one by API.

Re: Exporting modal harmonic load case

Rafal.Gaweda — Mon, 03 Jun 2013 08:06:22 GMT

Example attached.

Re: Exporting modal harmonic load case

t.sautierr — Wed, 05 Jun 2013 11:15:15 GMT

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

Re: Exporting modal harmonic load case

Rafal.Gaweda — Wed, 05 Jun 2013 12:44:31 GMT

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

Re: Exporting modal harmonic load case

Rafal.Gaweda — Fri, 07 Jun 2013 11:08:56 GMT

Update 1 + acceleration results

Re: Exporting modal harmonic load case

t.sautierr — Fri, 07 Jun 2013 14:41:07 GMT

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.

Re: Exporting modal harmonic load case

Rafal.Gaweda — Fri, 07 Jun 2013 15:07:45 GMT

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

Re: Exporting modal harmonic load case

t.sautierr — Fri, 07 Jun 2013 15:51:34 GMT

got it!