(API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

[Rafal.Gaweda]

Macro for dumping all opened tables in Robot (with all tabs) to Excell

Wait patiently until "Dumping finished" message appears on screen

ANSI csv files are stored in windows %temp% (loaction can be changed in macro if one wants) so they can be reused if needed 

(if files are not properly open in Excel, open VBA editor and play with code changing separators characters, relevant code marked in macro)

[Rafal.Gaweda]

Newer version in attachment

[Rafal.Gaweda]

Corrected opening files in Excel

[ledinhchinh0409]

hi. @Rafal.Gaweda

Thank you, this is very helpful. But can export results in the 'sheet' in an excel file instead of the 'excel file'  as it is now?

[Rafal.Gaweda]

Hi @ledinhchinh0409

Here you are

[ledinhchinh0409]

hi. @Rafal.Gaweda

Thanks very much. However when I export to excel it does not have the desired format.

[Rafal.Gaweda · Accepted solution]

Hi @ledinhchinh0409

Try attached.

If it does not work as you expect please change List Separator in Windows Regional Settings onto ";"

[piperr]

This is amazing @Rafal.Gaweda !!!

[ledinhchinh0409]

@Rafal.Gaweda

It worked very well. Thank you very much!

[Muhammed.OPERA]

That's very useful, amazing @Rafal.Gaweda

Keep on 

[jmmarin]

Thank you. It is very useful!!

[WALIDGIO]

it does't work for my ROBOT 2025 and excel 2021

any way to fix it ?

[Stephane.kapetanovic]

hi @WALIDGIO 

you need to create Robot tables so that the program can read them

Best Regards

[LionelDallenne]

Hi @Stephane.kapetanovic ,

As you said, robot tables need to be created so that the program can read them. However, it also only works when the table are visible and shown in Robot. Any ideas how to automate this? To make it more tangible, I would need the following table for instance to be retrieved (Results - Forces), hence autoatically opened in Robot.

Thanks!

[Stephane.kapetanovic]

hi @LionelDallenne 

Here is a brief example of the use of tables for the extraction of forces in bars

Best Regards

[LionelDallenne]

Thanks @Stephane.kapetanovic 

It seems I'm now able to create the table I need within Robot.

Thanks for your help so far.

[HoshangMustafa]

Hi @Stephane.kapetanovic 

I tried your excel file without success

[Stephane.kapetanovic]

hi @HoshangMustafa 

no problem here, are you sure you authorized the workbook macros when you opened it?

Best Regards

[LionelDallenne]

Hi @HoshangMustafa,

please make sure as well to unblock the Excel file in the file properties in Explorer.

Best regards,

[Stephane.kapetanovic]

hi @LionelDallenne 

this is not the case it is an excel 97-2003, so no additional blocking

Best regards