Hello,
I’m trying to use a formula: row.Item( Firstcolumn as string )=row.Item(SecondColumn as string) in if statement but it return:
Try like this
row.Item( “Firstcolumn Name” ).ToString.Equals(row.Item(“SecondColumn Name”).ToString
Regards,
Mahesh
thank you,
another question i had to read a range for ex "A4" to "C34" but the lenght is varying, did "A4:C34" working?
Yes A4:C34 will work
and if i need to check if it is not equal?
in fact, i have an excel sheet and i need to check in 1 column if there is a special character “?” and return the value of the corresponding cell in another column column2 and for the end shows all the values in one other columns