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

excel
activities
studio

#1

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 .


#2

HI @akshaygm12,

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


#3

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


#4

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


#5

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


#6

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


#7

image

Use index or Column Name


#8

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 .


#9

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

cint(drExcel(0).ToString)

column named 23 already belongs to this table its geting ,


#10

Hi, Akshay. Try this.

ReadExcelData.zip (15.8 KB)

Let me know if you have any queries.


#11

thanks siddarth :slight_smile: