Excel scope question

Help Activities
, ,
1

Hi,
Within Excel application scope I am using Read Range from Sheet1, using write Range to write to Sheet2, and appending to Sheet3. Can I use the same Excel Scope because it is the same Excel File?

Thank you,

1 Like
2

Hi @A_Learner,

Yes, you can use the same Excel Application Scope. It will not be a problem.

Hope it helps :slight_smile:

3

Thank you, @gustavo.cervelin! For some reason, I am getting Exception. File being used by another process error.

1 Like
4

Hi @A_Learner,

Make sure all activities you are using (Read Range, Write Range and Append Range) inside of the Excel Application Scope are from App Integration - Excel

image
image349Ă—562 11.6 KB

If you use the activities from Workbook inside of the Excel Application Scope, you will get this error

image
image360Ă—568 9.56 KB

If this solves your problem, kindly mark this post as solution to close this topic.

If you need extra help and/or have any question, please let me know :slight_smile:

Thanks!

5

Hi!

You can use only workbook activities it won’t require any Application scope. if the file is opened in Excel. we can’t perform operations…

if you’re using Excel activities which @gustavo.cervelin mentioned you can perform the actions even if the excel is opened.

Note: Don’t use mix ex:- Excel Application scope inside that Read range from workbook instead of read range from excel.

you can use multiple read range by using one excel application scope. if the file is presented in the same location.

or

you can also read the different sheets which is presented in the same file.

Regards,
NaNi

1 Like
6

Hi @A_Learner

I think its better to go with workbook activities as its works in back ground you may not get the exception excel is opened until its opened manually!

As you re using the the multiple read range with excel application scope when you re appending the data to another excel the previous excel is still opened that causes the exception as you may try with close work workbook activities or kill process to over the issue each time you re appending.

Regards

7

Thank you @gustavo.cervelin

1 Like
8

Thank you, @THIRU_NANI

1 Like
9

Thanks a lot @pravin_calvin

10

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