Excel still having same value from previous run

Help Studio
1

Hi All,

I am using excel application scope i am using datascraping splunk result and copying in excel using write stream when the previous run not successful excel write stream not working excel contains same old value. i am deleting file after execution only not in btw.

How to delete if the progream interrupt in btw please?

2

Hi @Sathish_Ashokan

use the try catch activity and place the code within that and add an delete file activity in the catch so that if there is any error occurred then it moves to the catch block and then the delete file activity gets executed.

Regards

3

Hi @Sathish_Ashokan

Please try the following steps:

  1. Surround your excel application scope activity with Try Catch
  2. In the catch block add an exception and inside that add delete file activity.

If there is any exception in the try block, then the catch block will be executed and your file will be deleted. The above will help you to solve your issue.

Cheers!