Excel Scope Write Range "file in use" does not throw error

excel
activities
studio

#1

Hi all and devs,

Issue:

Using an Excel Scope, with a filepath in a variable, when the file is in use, the Excel Write Range activity is automatically saving the file locally to “C:\Users\<username>\Documents”.

Or am I going crazy?

I’m wondering if this is something anyone else is noticing.

Studio and OS version used:

image

Excel Activity version:

image

Workaround:

I will probably end up using Workbook Read Range to check if file is in use before entering Excel Scope so I can throw an error as desired.

Solution?

Assuming I’m not crazy and this is indeed a problem here are my solution Ideas:

  • I think the Excel Write Range should either throw an error when it is in use or (preferrably) change the filename to include a number like “directory\filename (2).xlsx” or “directory\filename (3).xlsx”

Thank you.

Clayton.


#2

@qateam @Gabriel_Tatu


#3

tried with excel package 2.0.6526 (latest release)
if i have the same excel doc opened, the excel scope activity+write range, will write the data in it
there is no additional file created, anywhere :slight_smile:
can you share your wf?


#4

I reproduced the issue in this workflow sample:
_TestCanvas.xaml (9.0 KB)

I opened the file on another machine so it is in use and the file got saved in documents folder instead:
image

I don’t see the update for 2.0.6526 on this server. However, my laptop has Excel 2.06526 and it did the same thing as shown above.

Thanks.


#5

Can you manually open an excel document on machine2 while is opened by another user on machine2?


#6

Yes, so I can open the excel file with multiple users or on different machines but one opens as read-only. I also verified that the Excel Scope is opening the file as read-only then writes file to local documents folder instead.


#7

Interesting, i will check and get back to you here