Need your support to solve this issue, i have tried a lot
Ref my screenshots and discussions with Mr.Steve.
I have concern, My process flow is below :
Open Excel-01 and read few cells and stored it as Variable
2.Open Excel-02 and apply filter - Do filter by using saved variable
3.End of Filter you will have only one row - Compare qty column from Excel 1 and Excel - 2
4.If both the qty is matching i need write one of saved variable in column name " OLS AVAIL ID"
i can able to do step 1 to 3 but step 4 is not working for me, i tried to put message box its correctly reading the data in the respective cell but when i use write cell its not working.
It’s normally a good idea to post your .xaml file (and the excel files that your program uses), when asking about specific questions like this. It makes it much easier for us to try and help you.
If you want to compare that the value in valQty is the same as filter2.Rows(0)(“QTY”).ToString you first need to change your valQty from Generic Type to String.
When you’ve done that, you can do valQty.Equals(filter2.Rows(0)(“QTY”).ToString)
There are also the options valQty.StartsWith or valQty.Contains that you can use, if you are not certain of the exact text within the cell.
When i tried with different sheet in same excel workbook its working i tried to Write cell in Sheet3 A2 its working but if i change it to Sheet2 there is a above error.