Can't open excel

Help
, ,
1

I have excel files , it can open normally(from UIPath)
but I edit some row in excel and save completed.
When it opens again, it cannot be opened.

Help me please.

2

Hi @fairymemay,

Can you share what is the error you are getting?

3

@RAMESH_G

image
image824×147 3.91 KB

If I cick yes , show below

image

4

Hey @fairymemay, are you using any Write Range activities in your workflow, and also, are you using Excel activities or Workbook activities?

5

@monsieurrahul I use write Cell Activity

6

Please check if you are providing the cell range properly, especially if it’s dynamic.

If you’re using Excel activities (Excel Application Scope), please use a Close Workbook activity to close your workbook after reading ie., before you write data to it.

7

@monsieurrahul I have 2 file excel (file A and file B)

  1. I read data from file A Completed
  2. write data from file A to file B Completed
  3. edit file B Can’t open file B
8

I understand your workflow. I would like to know if you are using Excel activities or Workbook activities? A screenshot would help.

9

I use excel application scope but I use write cell workbook.

10

Please try the below steps:

  1. Read data from file A using Read Range activity inside an Excel Application Scope.
  2. Close Excel Instance.
  3. Write data to file B using Write Range activity inside an Excel Application Scope.
  4. Close Excel Instance.

In the Excel Scope, set the Output property. Please refer the documentation to know more about the property.

1 Like