I have a problem with my process…
I have one excel file as attached… I want to check the contain Column A of Sheet Name " input(dosmetic) " , if the contain include some keyword same with Sheet Name " Defect code " then it will write the " 1 " number into the B column of Sheet " include(dosmetic) "
But problem is the excel has many row, it can not run and I must wait very long time and then close process… when I delete many row, it can run normally.
Pls check my XAML file and support to me.
Thanks in advance!