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

[akshaygm12 (gm)]

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 .

[akila93]

HI @akshaygm12,

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

[akshaygm12 (gm)]

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

[akila93]

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

[akshaygm12 (gm)]

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

[akshaygm12 (gm)]

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

[akila93]

Use index or Column Name

[akshaygm12 (gm)]

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 .

[akshaygm12 (gm)]

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 ,

[siddharth]

Hi, Akshay. Try this.

ReadExcelData.zip (15.8 KB)

Let me know if you have any queries.

[akshaygm12 (gm)]

thanks siddarth