Process Excel

Help Studio
, , ,
1

Hello I have a question !
I am trying to automate an application which contains excel sheets.
is it possible to use excel functions with vb.net?
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

2

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

3

I just want to retrieve values ​​in cells

4

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

5

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

6

recover ? i didn’t get your point

7

I cannot identify the excel sheet. How to do ?

8

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

9

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

10

can your share the screenshot here?

11

2020-10-09_22h12_46
2020-10-09_22h12_461910×817 200 KB

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

12

Have you tried data scraping for this?

13

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
Try
For i As Integer = 1 To EXCELAPP.Workbooks.Count
MsgBox(Excelapp.Workbooks.Count)
For j As Integer = 1 To Excelapp.Workbooks(i).Sheets.Count
If Excelapp.Workbooks(i).Sheets(j).ToString = “Feuil1” Then
MsgBox(“Ok”)
End If
Next
Next
EXCELAPP.Visible = False
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try

14

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