Extract data from a SAP ALV-Grid into a UiPath DataTable variable

[Marcelo_Vina (Marcelo Viña)]

Could you tell me if is it possible to extract Data from a SAP ALV Grid directly into a UiPath Datatable variable?

Which function or activity should I have tu use?

I tried with “Data Scrapping” but I got Error: “This control does not support data extraction.”

I tried “Screen Scraping”, with better luck, and I got a GetVisibleText ‘SAPALVGrid’ activitie with a Sapalvgrid ‘GenericValue’ variable!
Anyway I write to ask if there is any way to get a Datatable variable directly from the ALV grid, because I don’t know how could I perform for eg. the separation in columns of the data contained in this GenericValue variable, etc.

I also thought about the possibility of using the “export to Excel function” provided by SAP.

I appreciate your suggestion about the best alternative to folow.

Thanks in advance!

[Palaniyappan (Palaniyappan P)]

Hi
Welcome to UiPath community

Did we try with this option

@Marcelo_Vina

I also thought about the possibility of using the “export to Excel function” provided by SAP.

Or the output of screen scrapping, a string variable can be passed as input to GENERATE DATATABLE ACTIVITY that would give us a datatable output

Cheers @Marcelo_Vina

[Marcelo_Vina (Marcelo Viña)]

Hello Palaniyappan, I appreciate your quick answer!

Could you give any example about the alternatives you sugest? In order to better understand what should I do.

Thanks, Marcelo.

[Palaniyappan (Palaniyappan P)]

Fine
At some point if tome we won’t be able to scrape a structured tabular form of data with the help of Data Scrapping method
so those structured data can be read with the help of SCREEN SCARPPING method
Where this screen scrapping method from design tab in studio will scrape those tabular data and give us with tab delimited string variable as output
—now we got an activity called GENERATE DATATABLE ACTIVITY where tab delimited string can be passed as input and we could be able to get a datatable as output

Activities - Generate Data Table From Text

For example this thread would help you

How to read tab delimited data file into data table?

Hello. I think the easiest solution is to use the newly added Generate Data Table Activity. Just read the file as a text file and give as an input to the activity. Inside specify what type of column and row separators you need. This should return the results as a datatable.

Cheers @Marcelo_Vina

[Marcelo_Vina (Marcelo Viña)]

Hello Palaniyappan,

I understud. Thank you very much for your clear answer!

I’ll work in that way and be back with comments.

Thanks, Marcelo.

[Palaniyappan (Palaniyappan P)]

Sure
Cheers @Marcelo_Vina

[gheorghestan]

@Marcelo_Vina , UIAutomation.Activities 21.2-preview comes with support for scraping SAP ALV Grid tables. Please give it a try and let me know your feedback!

Thanks.
Gheorghe