Indicate in Excel Failed. Error: No document found in the Excel Instance with process id

Help StudioX
, ,
1

Hi, I have a problem when I tried to do things in excel process scope, the following pop up window will show if I want to click or type into in the excel file. I tried restart the computer, close and reopen excel and UiPath but still don’t work.

Now, I can edit the web activities but can not modify on excel. Already made excel activities work well but can’t change the indication anymore.

Screenshot 2023-08-08 141808
Screenshot 2023-08-08 141808806×260 6.2 KB

3

want to download the file from website into excel file and do modifications, those modifications include click and type into activities. However, in current situations, if I drag an activity into the process scope and try to indicate through the indication button, the pop up window will show and I cannot select where I want to use the activity.

4

You don’t use UI Automation (Click, Type Into, etc) to automate with Excel. You use the Excel activities like Write Range, Append Range, Write Cell, etc.

The Excel scope isn’t a UI Automation scope, that’s why you’re getting errors when trying to use UI Automation activities inside it.

5

When I select click or type into activities in excel scope, it actually let me do the process in the past. Ex: select filters, zoom in and out. So I think it’s fine to use?

6

That isn’t the best way to automate with Excel.

Work with it as data, not as a UI app.

7

Hi Paul,

I’m getting this error as well. Is there an actual solution to this error or can you point me to the Excel activity that will covert a PDF to an Excel table?

Steps are:

  1. Create a new document
  2. Attach with Use Application/Browser activity
  3. Menu (Alt) > Data (A) > Get & Transform Data (P) > Get Data (N) > From File (F) > From PDF (P)
  4. Open PDF file
  5. Select ‘Page001’ (in the same window as the next click so the window is open and interactive)
  6. Click ‘Load’ (here’s where the error is raised)
  7. Save (Ctrl + S)
  8. Close document

Cheers,

Sam

8

There is no “convert a PDF to an Excel table” activity. That’s not a standard, consistent thing to do. It depends on how the PDF is formatted. As I already said, you shouldn’t be using UI automation in Excel. The proper procedure is to get the data from the PDF into a datatable (again, this depends on how the PDF is formatted). Then you use the normal Excel activities to write to Excel.