指定Excelファイルが開いているか、閉じているかチェックする手段

UiPath Studio EnterPrise Editionを利用中の初心者です。
WF実行中に、指定Excelファイルが開いているか、閉じているかチェックする手段はないでしょうか?もしあればサンプルコードでご教示をいただきたく、よろしくお願い致します。

Hi @gorby

If you are using the excel process scope activity then please check in properties panel so that there is an option like highlighted below so please mark as True if you wanted the excel to be opened or else please mark as False if you wanted the excel not to be opened.


Regards

Hi You are misunderstanding my question.
I want to know if the Excel file is opend or closed at the checkpoint.

Hi @gorby

Use an try catch activity and place the workbook activities within that and If the excel is not opened it continues the process and if the excel is opened then it throws an error and the process moves to the catch block so from this you can know whether the excel is opened or not.

Regards

Hi, What do you mean “the workbook activities”? So many workbook activities are places in activity panel.
ExcelCloseWorkbook activities?

Hi @gorby

Above mentioned all are the workbook activities.

Regards

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