Facing an issue while writing the data to an excel

Help Activities
, ,
1

The image shows a computer screen displaying an automation log with various task entries and error messages related to an Excel file disconnect and system exceptions. (Captioned by AI)
The image shows a computer screen displaying an automation log with various task entries and error messages related to an Excel file disconnect and system exceptions. (Captioned by AI)1920×1440 479 KB

Attached image was the error

1 Like
Forum Engagement Daily Reports
3

Hi @kavitimoulika135

Ca you try to use workbook activities it will give absolute results

Try this if it works please mark this as a solution

4

Thanks, I need to use only modern as per my requirements

1 Like
5

And also this error getting only in run mode in debugging it’s working fine

6

Hi @kavitimoulika135

Wherever you are using classic activities if it is not working try to use modern activities it will work.
Happy automation if it works mark this as a solution thank you

7

Hi @kavitimoulika135 Use Kill process activity to kill the excel process in the beginning.

Also let me know what exactly you are performing here please share list of actions.

8

Use some delays and check as well kill process with process name as “excel”

9

Before performing any action inside excel put some delay.

10

I’ve already used kill process and delays with 2-3 seconds

11

Kill Process shouldn’t be used like this. It can leave Excel in an improper state and cause errors, corrupt files. Too many people use Kill Process as if it’s an automatic thing you should do. It isn’t.

1 Like
12

Stop doing that. You don’t need Kill Process and you don’t need delays. Take that code out. Reboot. Then test. If you’re still seeing the errors, show us your code.

13

@kavitimoulika135,

Basic sanitation required in your code.

Don’t use two Excel process scope inside each other. If you have to work on multiple files at the same time, use two Use Excel file activities in a single Excel process scope

If you are using Kill Process inside the Excel Process scope to Kill the excel, remove this code and put it outside of it.

1 Like
14

@kavitimoulika135

one thing that you need to do is keep use excel file inside excel processs cope and from options select automation,kill process,use fresh session,disable macros if not needed ..also remove kill process as excel process scope would handle it better

cheers

15

  1. You might ising multiple Excel scopes/instances at the same time leading to conflicts.

  2. Try to keep all Excel activities inside a single Excel Application Scope instead of opening and closing multiple times.

  3. Make sure the Excel file isn’t opened manually

  4. Always use the Close Workbook or Quit method to release Excel objects instead of relying on the process to exit.

Mark solution if its help :blush:

16

Thank You all Problem solved already

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.