How to get the null value data while reading the data from read row

hi iam having the data like this. if i use the read row then it will take only the data which has some value all the null cell will be neglected . after i loop data from it will loop upto the data it contains in that .ex ( 0 , 2 , 2 , 0 ) the size of that will be 2 so it will loop 2 times . iwant the null values also that it will loop for 4 times how can i do this .

HI @akshaygm12,

Use Read range activity to get all the data from the excel sheet.

i thought that but how to increment the value in read range .

In Range pass "" so it will read the all the data from the sheet

if i tried to print it its saying not in raange or already present in the datatable .

i dont want all the data . i want row by row data .


Use index or Column Name

in this the datatable will contain all the data how can i restrict to get only the one row data . ex first-row – 1, 0, 2 ,1,
second row - 2 , 0 ,1 ,1

first i have to read the first row data one by one if it contains null also . how can i do that .

in above it will contain the two rows data in a single datatable .

if i use the
23 value is their using the for loop drexcel to dtexcel .


column named 23 already belongs to this table its geting ,

Hi, Akshay. Try this. (15.8 KB)

Let me know if you have any queries.

thanks siddarth :slight_smile:

1 Like