Error while running "write cell" in Excel application scoope

Help
1

Hi there!
I’ve got a problem while running “write cell” in Excel application scope.
My sequence is:
-Excel App Scope(://file.xlxs)
-read range (sheet1)
-append range(sheet2)
-write cell (sheet2, cell “C2”)

After running this process I recieve error that file is used by other application. Do you have an idea whats wrong might be?

Thanks.

1 Like
2

  1. Make sure your file is not opened manually or by any application before running your process.

  2. Kill the excel process before triggering your main workflow.

  3. Place all your activities inside the Excel application scope.

  4. In the properties of Excel Application Scope, disable the following options -

  • Create New File - When selected, if the workbook cannot be found at the specified path, a new Excel workbook is created with the name specified in the WorkbookPath property field. When cleared, if the workbook cannot be found at the specified path, an exception is thrown, informing the user. By default, this checkbox is selected.
  • Read-Only - Opens the specified workbook in Read-Only mode. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked for editing or has an edit password. By default, this check box is not selected.

Regards,
Karthik Byggari

1 Like
3

It stays the same:
"THe process cannot access the file because it is being used by another process.

IMG_7959
IMG_79593024×4032 2.89 MB

1 Like
4

@Slavich You are using workbook write cell use excel write cell

2 Likes
5

Solved. You are right. Thank you!

1 Like
6

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