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!
Solved! Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
Solved by Rafal.Gaweda. Go to Solution.
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
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
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
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