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 .
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
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.
ReadExcelData.zip (15.8 KB)
Let me know if you have any queries.