Unable to write data in the excel file

Help Studio
, ,
1

Hi All,

When i try to write data in the excel we are receiving below error message.
write cell : The process cannot access the file\filename\file.xlsx because it is being used by another process. I crossed checked that excel file is not opened.

Please assist.
Thank you.
Raghu

2

Just in case, open the Task Manager and check if you have any Excel processes running

3

Hi @Raghu_km

Use Kill process activity to kill excel before opening it.

4

Hi @Raghu_km ,

Are you using excel scope in that process for the same file? If yes use close workbook activity to close it.

5

Yes i am using excel scope. Please give more clarification on this.

6

Are you using close workbook to close it?

7

Sorry Harshith i didnt get what you are asking.

8

Are you using modern activity?

9

I am not using.

10

Do you get the same issue if you use a kill process activity before running the activity?

11

@Raghu_km

image
image1116×335 19.5 KB

After excel scope activity, use close workbook activity as shown in the image.
Pass output of excel scope activity as input for Close workbook activity.