How do i end ny write range in a loop using studiox

Mark_Rajkumar · February 15, 2023, 2:15am

How do i end my loop using studiox without getting the abive error message.

Anil_G · February 15, 2023, 2:20am

Before writing the data check if the datatable you are writing is empty or not dt.Rowcount>0 and then only append it

Cheers

Mark_Rajkumar · February 15, 2023, 2:41am

Hi @Anil_G can u show me with an example

Anil_G · February 15, 2023, 2:48am

Steps and activities are these…

Before you write range or append range activity…

Add a if activity…give the condition as dt.Rowcount>0 where dt is the datatable you are writing to excel

Then on the then side of if condition add the write range or append range activity

Cheers

system · February 18, 2023, 2:49am

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