Buddy i didnt get you , can you come again…
Cheers @priyankavivek
Buddy @priyankavivek i saw you xaml, it didn’t have any errors and logical mismatch as well
but i would like suggest you that make sure if these are the columns to be compared, sometimes we might dissenter the value wrongly with column index…so if you are sure with the column name kindly mention them directly within double quotes like this
row(“columnname”).ToString.Trim.Equals(row1(“Columnname”).ToString.Trim)
Lets try this buddy
Cheers @priyankavivek
i would try this now thankyou
i think this must be the problem
better try with column name buddy
that would work for sure
and i think that column must be hidden,
unhide it and try buddy @priyankavivek
@priyankavivek
This excel might have hidden column. Try reading the complete and check the contents of datatable. And to avoid indexing please use column names instead of column number.
datatable i have checked i will try with column name
i have got the result as “yes” the condition which is not satisfying i need to make it no
using (hint :null)condition any idea on this? i have to fill the empty as “no”
Well,
if the aim is just to fill empty as ‘No’
Then ,
Read range of the excel file : →
- For each row in data table
- Open another while loop
- if - row (count).ToString.Trim.Equals(“”) then assign YourDataTable.(rowCount)(ColumnCount)=“No”
- Write range in Excel again.
I think this will work .
Regards
Yes buddy ofcourse here is your sample xaml for this @priyankavivek
to mark null with NO @priyankavivek
no.zip (9.5 KB)
Cheers
checking on that buddy
i used another if condition to check whether it is "no"its working fine buddy,thanks for your reply!!!thank you so much…
thank you so much it working fine now! thanks for your help
still i have queries can i proceed?