Error Job stopped with an unexpected exit code

Now my flow as below.

But after it show error as below.

I think it cause big size.
image

Please guide me about it.

Hi @fairymemay

  • Can you delete all excel processes from task Manager first and then run your workflow.
  • Try to delay activity also before writing the data.
  • Try to use KILL PROCESS activity with process name property as “EXCEL”.
  • if still doesn’t work may be the file is corrupted copy the same file information in another excel and then run and see if you are still receiving the error.

Regards
Gokul

@Gokul001 Now I use delay as below.

And I use run with slow step.

But show same error in write range activity.

Please guide me about it.

Hi @fairymemay

Can you try with Excel application scope Write Range Activity

Regards
Gokul

@Gokul001 Same error.

Hi @fairymemay

After Excel application scope Use Kill Process Activity

Before Writing into the excel print value in the look and check all the values in the Log

Regards
Gokul

@Gokul001 same

Try with is activity @fairymemay

Share the sample XAML file

@Gokul001 my flow as attached.

Main.xaml (7.5 KB)

Hi @fairymemay

Try to use Kill process inside the Excel scope as in the screenshot

Regards
Gokul

@Gokul001 After run show as below.

Hi @fairymemay

Change the Excel scope write range to Workbook write range

Regards
Gokul

@Gokul001

Remove the Excel application scope, Only keep the write range activity of the workbook @fairymemay

@Gokul001 Same error.

But If edit textfile to 2 rows , it can run completed.

In real data have 300K rows.

image

How to solve it?

@fairymemay
Have a try on this way to write the Vale in the excel

Try to use Studiox activity in studio

Go to → Activity panel → Click Filter → check the Show Mordern

image

Use excel scope activity, Use Excel scope Activity, Write DataTable to excel activity

What to write → DataTable Name

Destination as → Excel.Sheet(“Output”)

Output is the sheet name

Regards
Gokul

@Gokul001

Use Kill activity and delay in the process if you had this error @fairymemay

@Gokul001 delay before write ?

Yes @fairymemay Both the activity before Write DT. Run the process in Debug mode