Process Excel

Hello I have a question !
I am trying to automate an application which contains excel sheets.
is it possible to use excel functions with
I tried to use the excel activities, but impossible because it is not the excel application that I use. Maybe it’s possible but I didn’t succeed

you can do it in both way. give me the overview what you want to do with excel sheet?

I just want to retrieve values ​​in cells

Yeah you can do it with both ways like code and also with uipath activities.

Ok ok but how to recover the instance of excel? I’m stuck here

recover ? i didn’t get your point

I cannot identify the excel sheet. How to do ?

use read range activity it requires two things first your work book path and second your sheet name. give these two things to this activity then what it will do it will give you a datatable which contains your excel sheet data

Yes I know this method but in my case I don’t use Excel but an application that uses excel sheets, so my excel sheet doesn’t have a path or maybe I didn’t identify it

can your share the screenshot here?

Here is the application, and we also see the excel sheets

Have you tried data scraping for this?

Yes, DataScrapping allows me to recover the value. But I also have to select some cells to add information.
I tried this but it doesn’t work :
Dim Excelapp As Microsoft.Office.Interop.Excel.Application
Dim Wbs As Microsoft.Office.Interop.Excel.Workbooks
For i As Integer = 1 To EXCELAPP.Workbooks.Count
For j As Integer = 1 To Excelapp.Workbooks(i).Sheets.Count
If Excelapp.Workbooks(i).Sheets(j).ToString = “Feuil1” Then
End If
EXCELAPP.Visible = False
Catch ex As Exception
End Try

If data scraping is working then first do data scraping then on the basis of cell value identify table row then insert value there.