Write range activity:

Help Studio
, ,
1

image
image725×625 28.2 KB

write range only write the Status column.
I want to write all the 3 row in excel

2

@AbarnaKalaiselvam

I see you are using write range in a loop…

I guess you need to use outside the loop

Cheers

3

Hi,

Can you check content of primo and invsts variable using Break point or LogMessage?
If they are empty, please review logic to assign value.

Regards,

4

yeah i done that in a message box. pimno and invsts contains value

5

HI,

Can you set Breakpoint at WriteRange activity then debug run? We can check content of datatable etc at Locals panel as the following.

image
image1555×699 47.1 KB

Regards

6

Hi @AbarnaKalaiselvam - Can you check below points

  1. Before you writing the data to excel can you print data table using Output DataTable activity and check it has the required data or no
  2. Make sure the data table variable is defined within a scope
  3. Instead of column names can you try giving column index
Ex: Row(0) = "Completed"
Row(1) = Pimno
Row(2) = invsts
  1. If it didn’t work, can you also give a try with Add Data Row activity instead of Assign activity

Picture2

7

variable scope is the probem.
Thankyou @ushu

8

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